The spreadsheet holding your business together: when it stops being a solution

Almost every company has a spreadsheet that does far more than it appears to: it sets the prices, consolidates the sales, reconciles the cash position or splits the commissions. It started as a workaround and has been underpinning decisions for years. The decision it poses is not "spreadsheets, yes or no" — that debate leads nowhere — but when that particular file is still a reasonable solution, and when it has become a risk that needs to be treated as one.

In defence of the spreadsheet

It is worth starting here, because the heroic spreadsheet is usually born for good reasons. It is flexible, already paid for, needs no project, budget or sign-off, and the person who builds it understands the problem better than anyone. For testing a new calculation, running a one-off analysis or supporting a process that is still changing shape, it is hard to beat.

The problem is neither the tool nor the person who built the file. The problem is that some of those provisional solutions become permanent without anyone deciding they should, and keep growing until they underpin decisions that deserve firmer foundations. Nobody chose to have the company's entire pricing logic live in one sheet: it simply happened.

Three signals it has become a risk

There is no need to audit every sheet in the company. It is enough to check whether the file that matters shows any of these three signals.

Only one person understands it

Hidden tabs, chained formulas, manual steps that must be done "in this order and no other", and judgement that isn't written in any cell because it lives in the head of whoever maintains it. While that person is around, everything works. One holiday, one sick leave or one resignation, and the process stops — or worse, is carried on by someone who doesn't know what they're touching. If the file decides prices or payments, that person is a single point of failure, however talented they are. Precisely because they are.

It breaks in silence

A spreadsheet almost never warns you it is wrong. A row inserted outside the range of a sum, a formula overwritten with a hand-typed value, a filter someone left on. The file keeps showing figures that look exactly as they always have, and nobody knows how long they have been wrong. Noisy errors get fixed; silent ones get signed off, sent out and turned into decisions. Of the three signals, this is the most dangerous, because by definition it cannot be seen.

Parallel versions

The file travels by email, gets copied "just in case", and soon the whole family appears: "v7", "v7_FINAL", "v7_FINAL_good". Each department ends up working from its own copy, until one day two people arrive at a meeting with two different figures for the same thing. From then on, every discussion about the business starts with a discussion about which copy rules.

What doesn't fix the problem

Two common reactions fail. The first is banning spreadsheets: the file reappears within weeks under another name, because it covered a real need the ban does not. The second is buying a system to replace it without first understanding exactly what it does. The heroic spreadsheet usually contains business rules written down nowhere else — how that margin is really calculated, which exceptions that customer gets. Migrating it without reading those rules doesn't remove the risk: it buries it inside a new system, with the rules lost along the way.

What to do with a critical spreadsheet

The treatment doesn't start with technology. It starts with recognising the file for what it is: a critical piece of the business.

1. An honest inventory. Which files genuinely underpin decisions — prices, purchasing, payments, commissions. There are usually only a few; the rest of the company's sheets need none of this.
2. Document it. What it does, where its data comes from and which manual steps it needs, even if only on one page.
3. A second person. Someone who understands it and can run it — not just open it.
4. A reconciliation check. One figure from the file compared against another source at a regular rhythm, so that breakage stops being silent.
5. Decide its future calmly. Some files can stay as spreadsheets, with an owner and controls; others hold up something so central they deserve to become a properly supported process. Telling one from the other is part of what surfaces in a data & systems assessment.

Three questions to tell whether your spreadsheet is a risk

1. If the person who maintains it were away for a month, could anyone else produce the same figure?
2. If it calculated something wrong tomorrow, how would you find out — and how long would it take?
3. How many copies of the file exist right now, and which one rules?

The heroic spreadsheet is not the enemy. It is a credit and a signal at the same time: someone solved, with what they had, a problem the company has not yet properly solved. Treating it as a risk is not disrespecting that work; it is taking seriously what it holds up.