Knowledge base

Notes on Excel and VBA development

Background articles on using and maintaining business-critical Excel and VBA applications, written from what we see in client projects — not general Excel tips.

Articles

Taking over an existing Excel or VBA project: what to check

The developer of your spreadsheet or macro-driven application has moved on. What a careful takeover looks like, and how AI assistance can speed up the first phase, depending on the file.

Read the article

Working with multiple users in Excel at the same time

Why collaborating in Excel often goes wrong at business-critical scale, and how we solve it without you having to leave the Excel Desktop App.

Read the article

What people build in Excel — and when it's too big for a file

Reports, planning, costing and more: the applications we see most often, and the honest answer on when off-the-shelf software is actually the better choice.

Read the article

Ten mistakes that make an Excel file unreliable

From hard-coded values buried in formulas to missing input validation: the mistakes we see most often in business-critical files.

Read the article
Contact

Does this sound familiar in your organisation?

Briefly describe what you're dealing with, and Dennis will reply within one working day.

Go to the contact form