Your business runs on a spreadsheet one person controls

TL;DR

One spreadsheet quietly becomes your company's real system. Then only one person understands it.
Emailed copies, parallel versions and silent formula errors mean nobody knows the real numbers.
94% of business spreadsheets contain errors. Fixing them eats about 3.6 hours per worker every week.
The fix is not a new tool. It is one master version, one owner, and a rule against copies.

Somewhere in your company there is a spreadsheet called something like Master_Data_FINAL_v3. Everyone has heard of it. Only one person knows what is actually in it. This piece is about that sheet, and what it costs you.

How do you know the spreadsheet has become the system?

The file name tells you first.

Final_FINAL_Updated. Master_v3_new. Orders_Aug_Real_ThisOne. When you need three suffixes to say which file is real, the spreadsheet has stopped being a tracker and become the system your business runs on.

It usually starts small. Someone makes a quick sheet to track orders. Then customers go in. Then payments. Then staff commissions. Within a year the most important database in the company is an Excel file with 40 tabs and no documentation.

And people notice the symptoms before they name the cause. A team on an Excel forum described it plainly: one person owns the master, several people keep their own copies, and the last merge attempt broke the master formulas. Now nobody trusts the numbers. One commenter on a Hacker News thread said it best: his department had "300 weekly files for the last 5 years" with "50 variations on column arrangements," and handling it all was "the full-time job of one of our staff."

What happens when only one person can change it?

That person becomes the single point of failure for your data.

Someone on an Excel forum wrote the situation down exactly: "only I can change it, but I need to save changes while other users may have it open to read." Read that again. Updates can only come from one person, and everyone else can only wait.

So when that person is on leave, the business data freezes. When they are busy, updates pile up. When they edit quickly between calls, mistakes slip in silently. One team sharing a critical order worksheet reported mystery changes appearing in the file and nobody knew who made them. Another user asked how to track changes when autosave now quietly overwrites the "clean" version. The edits happen. Nobody sees them.

This is the part founders miss. The risk is not just version chaos. It is that the entire operating knowledge of the business lives inside one person's habits, and it walks out the day that person leaves. I wrote about that side of it in If your best person leaves, what leaves with them?

How much do spreadsheet errors actually cost a small business?

More than the sheet looks like it is worth, because the errors are silent.

Start with the uncomfortable number: 94% of spreadsheets used in business decision-making contain errors, according to a 2024 review of more than 35 years of research by Prof. Pak-Lok Poon and colleagues (phys.org). Your master sheet is almost certainly wrong somewhere right now, and nobody has found the spot.

Then there is the time. A 2026 survey of operations professionals found workers spend an average of 3.6 hours a week fixing spreadsheet errors, about 22 workdays a year, at roughly $4,300 per worker per year (Inc.). In a 10-person team, that is close to one person's Fridays, every Friday, spent fixing cells instead of doing business. And 22% of ops professionals deal with spreadsheet errors every single day (Wikipedia's list of spreadsheet mistakes).

The worst kind of error is the quiet one. 1 in 5 organizations in that same survey said a spreadsheet error had exposed or compromised confidential data. Wrong VLOOKUPs have caused real under-ordering. One famous error put the wrong people on a layoff list. In a small business the stakes are just as real, they just show up as a wrong quote, a missed payment, or a client you quoted twice.

Why does it keep getting worse?

Because every copy becomes a new version of the truth.

Someone exports the data monthly and saves dated versions. Someone else downloads the sheet "just to work offline." OneDrive creates a conflicted copy when two people edit at once. Each copy starts identical and drifts from the others within a week. This is how a small team ends up with eight versions of the same business and no idea which one is current.

Sharing habits make it worse. A January 2026 survey of UK small businesses found 39% of employees share sheets through "anyone with the link," and 20% of companies only review who has access once a year. Copies leave the building. Old employees keep access. The master keeps living on, half stale, half trusted.

And the bigger the sheet gets, the harder it is to leave. Two-thirds of mid-sized businesses still use spreadsheets as their main decision-making tool, and 80% report serious problems: duplicated data, inaccurate information, version confusion. More than a third say it noticeably hurts the business. The tool that was supposed to be temporary became load-bearing.

Why not just buy software and be done with it?

Because software fails the same way when the team does not use it.

I see this pattern constantly: the founder buys a tool, the team keeps the sheet, and the company now pays for both. The software is not the problem and the sheet is not the problem. The problem is that nothing in the workflow actually replaced the sheet. I wrote about that in You pay for software. Your team uses WhatsApp.

A system only replaces the master sheet when the team trusts it more than the sheet. That means one place to look, updated where the work already happens, with names attached to every change. If the tool sits next to the work instead of inside it, the team will quietly go back to the file they trust. More on that pattern in Your AI tools sit next to the work, not in it.

So before you shop for software, fix the discipline. One master version, one owner, no emailed copies. If that discipline holds for a month, you know your team is ready for a real system. If it does not hold, no software will save you.

What is the smallest fix that actually works?

Make one version the only version. This week.

The file name ends in FINAL_v3 – You have at least three versions and nobody knows which one is real
Only one person may edit it – Updates wait for that person, and so do the mistakes
A copy was emailed last week – The numbers in that copy are already stale
Meetings start with "whose numbers are right?" – You are debating data instead of making decisions

Here is the sequence that works for small teams:

1. Pick the master. Archive or delete every other copy, including the ones in your inbox. 2. Name one owner. Updates go through them, but everyone gets read access, so people stop making their own copies. 3. Stop emailing the file. If someone wants the numbers, they open the master. A link beats an attachment. 4. Write down the answers people ask for most often, somewhere the team can search. The sheet holds data, but the reasoning behind the data should live where people can find it, as I wrote in The answer is somewhere in the chat. 5. Watch the sheet. The day maintaining it costs more than it saves, that is your signal to move to a system built for your team, not a bigger spreadsheet.

The sheet was a smart early decision. It solved a real problem fast. The mistake is letting it become permanent. Your business deserves a memory that does not depend on one person and one file.

Frequently Asked Questions

We are a 10-person team. Do we really have a spreadsheet problem?

Small teams feel it harder, because one person holds a bigger share of the knowledge. When your single sheet-owner is on leave, a tenth of your company's answers go dark. The fix is also cheaper for you: one master file, one owner, no copies. You do not need new software. You need one rule everyone follows.

Does Google Sheets version history fix version chaos?

It helps you look backwards, not move forwards. Version history shows who changed what, but it does not stop people from working off downloaded copies, emailed attachments, or conflicting OneDrive versions. The chaos is a copies problem, not a history problem. One master that everyone opens is what fixes it.

The one person holding the sheet together is me. What should I do?

Start by writing down what only you know: what each tab means, which formulas matter, where the data comes from. Then pick one person and walk them through it. The goal is that your business survives your worst week. A system only you understand is a liability, even when you are the founder.

Should we replace Excel with a proper system?

Replace it when the discipline is ready, not before. If your team can keep one master sheet clean for a month, they are ready for a system. If not, new software becomes shelfware next to the sheet. The sheet is telling you what to build: a system that does what the master sheet does, the way the team works.

How do I stop my team from emailing their own copies?

Make the master easier to reach than the copy. Put the link where the team already works, give everyone read access, and ask one question when a copy appears: what did the master not let you do? People copy the file because they need something. Fix the need and the copies stop. Punishing copies without fixing the need never works.