You probably have one.
The spreadsheet everyone can use, as long as they know the rules.
“Only type in the yellow cells.”
“Don’t touch those columns.”
“Make sure you sort the whole table.”
“Use the master copy.”
“If that number looks wrong, ask before you change it.”
None of this means the spreadsheet is bad. It may have worked perfectly well for years.
The trouble starts when somebody forgets one of those rules and nothing appears to go wrong.
The spreadsheet still looks fine
Imagine you use a spreadsheet to prepare quotes.
Someone needs to update the latest material prices, so they copy a block of figures from an email and paste them into the workbook.
They’re one column out.
A formula disappears underneath the pasted values.
There’s no warning. Excel doesn’t refuse to save the file. The next quote is calculated, the total looks plausible and everyone carries on.
Perhaps nobody notices until a customer questions the price two weeks later.
A broken spreadsheet that shows #VALUE! is irritating, but at least it tells you something has happened.
A spreadsheet producing the wrong answer can be much harder to spot.
You may have seen smaller versions of this already.
Someone sorts customer names but leaves the renewal dates behind.
A formula copied down the sheet stops one row too early.
Someone sees a strange figure, assumes it’s wrong and types the number they expected over the formula.
A hidden lookup still contains last year’s rate.
Nobody is trying to damage the spreadsheet. They’re trying to do their job.
The calculations are stored with the numbers
Part of the difficulty is that a spreadsheet can put very different things in cells that look much the same.
One cell contains a material cost that staff are expected to change.
The cell beside it contains the formula that decides the selling price.
One column contains a job status that changes every day.
Another contains a formula deciding whether that job appears on somebody else’s list.
To the person entering the information, they’re all just cells in the same grid.
That means somebody can think they’re correcting the information while actually changing the rule behind it.
The spreadsheet may keep calculating afterwards. It just calculates something different.
Businesses know this, even if nobody has ever described it that way. That’s why important workbooks gain protected cells, hidden columns, colour-coded input areas and instructions about which parts people should leave alone.
Those safeguards can be enough.
If somebody breaks a formula, spots it straight away and spends five minutes restoring yesterday’s version, there may be no good reason to replace the spreadsheet. Tightening it up could be the sensible answer. We cover that decision separately in Day-1 Build vs improving the spreadsheet.
The situation changes when the wrong answer can leave the spreadsheet before anybody notices.
When a spreadsheet mistake becomes a business mistake
Take the quoting example.
If the formula is wrong but somebody catches it before the quote goes out, you have a spreadsheet repair.
If the quote reaches the customer, the business now has a pricing issue to deal with.
The same applies elsewhere.
A quantity matched to the wrong stock item can become a purchase.
A missing renewal can become a missed customer commitment.
A wrong commission calculation can become somebody’s pay.
A figure left out of a management report can affect a decision.
The workbook itself might look completely normal throughout.
That’s the threshold I’d pay attention to.
Not the number of tabs.
Not whether the formulas look complicated.
Not whether somebody has called the spreadsheet “a bit of a monster”.
Look at what happens when an ordinary mistake survives long enough to be trusted.
There is a better approach
Plenty of spreadsheets can be made safer with better protection, clearer input areas and a little discipline.
But if people need to update the day-to-day information while being carefully kept away from the rules underneath it, there comes a point where separating the two becomes attractive.
A small system can let somebody change a material cost without giving them the ability to overwrite the margin calculation.
They can cancel a renewal without deleting the record.
They can update a job without accidentally changing the rules that decide what happens next.
Excel doesn’t have to disappear. Most of your spreadsheets may stay exactly where they are.
You’re looking for the particular piece of work that’s become too important to remain this easy to change by accident.
Look at the bit people are told not to touch
If you want to know whether a spreadsheet deserves a closer look, start there.
Which cells are protected?
Which columns stay hidden?
Which formulas does nobody want to disturb?
What would happen if somebody changed one tomorrow and the spreadsheet carried on as though nothing had happened?
If the answer is five minutes of annoyance, fix the spreadsheet.
If nobody would notice until the wrong price, order, payment or piece of work had already left it, that one job may deserve somewhere safer to live.
AlphaFirst’s Day-1 Build is designed for contained problems like this.
You don’t need a specification or a plan to replace every spreadsheet in the business.
Especially the bit people are told not to touch.