The Spreadsheet Nobody Dares to Touch

Somewhere in a business, there's often a spreadsheet that everyone depends on but nobody particularly understands.

It might calculate prices, track stock, organise customer orders or produce the figures needed for a monthly report. Over the years, different employees have added formulas, extra worksheets and increasingly complicated ways of making it work.

Now, whenever something needs changing, the same person gets called over.

They're the only one who knows which cells can be edited, which formulas must be left alone and why one particular column should never be deleted.

It's a surprisingly common situation, and it raises an uncomfortable question about how businesses manage important information.

Imagine a hypothetical Wellington manufacturing company using an Excel workbook to calculate production costs.

The spreadsheet began as a straightforward pricing tool. Over time, it accumulated supplier prices, labour estimates, material calculations and special rules for different products.

Today, employees use it to prepare quotes.

The workbook performs an important job, but nobody has documented how its calculations work. If a formula breaks, the company depends on the employee who originally built it.

That creates a risk.

Not because spreadsheets are inherently unreliable, but because the business has allowed an important process to depend on knowledge held by one person.

If that employee takes leave, changes roles or leaves the company, maintaining the system becomes considerably more difficult.

And as the spreadsheet grows, even small changes can have unexpected consequences.

It's tempting to assume that a complicated spreadsheet should immediately be replaced with custom software.

Sometimes that's appropriate, particularly when the business needs stronger permissions, reliable audit records or more sophisticated workflows.

But replacement isn't always the sensible first step.

A spreadsheet can often be improved by documenting its calculations, protecting important formulas, separating input fields from calculated results and introducing more consistent data entry.

Some repetitive tasks might also be automated.

For example, supplier prices could potentially be imported from another application rather than entered manually, provided the systems support a reliable connection.

These improvements can make an existing workbook easier to maintain without requiring everyone to learn an entirely new platform.

The important thing is understanding what the spreadsheet does before changing how it works.

A useful test of any important business tool is whether another employee could operate it confidently with reasonable instructions.

Could they understand where information comes from? Would they know how to identify an incorrect result? Could they make a routine update without accidentally damaging something?

If the answer is no, the business may need better documentation, clearer procedures or a more suitable system.

It's also worth considering how much the spreadsheet is expected to do.

A workbook that once handled a handful of calculations may now be responsible for processes involving several departments.

At some point, the convenience of keeping everything in one file can become a limitation.

At Software Logic, I help New Zealand businesses explore spreadsheet automation, integrations and custom software where existing tools have become difficult to maintain.