Built with purposeI have never once opened a diagnostic call by telling someone to stop using Excel. Excel is not the problem. A single spreadsheet, maintained by one person and updated once a month, is a perfectly fine way to run a business. The problem shows up later, once that one file has become four, then seven, each one living in a different inbox with a name like "Budget_FINAL_v3_reallyfinal.xlsx".
What actually happens
It rarely starts as a decision. Nobody sits down and decides to keep seven copies of the same tracker. It happens because a manager needed to check something while the owner was travelling, so they emailed themselves a copy. Finance then added a column for a board meeting and forgot to send it back. The file moved to a shared drive that half the team could not open, so a third copy appeared to work around a permissions problem nobody wanted to raise with IT, because there is no IT department, there is one person who also does the books.
Each copy on its own is reasonable. The seventh one is the problem, because nobody can say with confidence which file is current anymore. I have watched two people open what they both called "the report" in the same meeting and read out two different numbers, both correct as of the moment each file was last touched, both wrong as a picture of the business today.
A pattern I see constantly: the file that drifts furthest from reality is not the one people ignore, it is the one they update the most. Someone keeps a personal copy current because they check it every day, while the shared version everyone else looks at was last touched a month ago. The most-used file becomes the least trustworthy one, precisely because it is the one somebody bothered to maintain alone.
What it actually costs
The cost is not the storage. It is the time spent reconciling two numbers that should agree, and the decisions made on a figure that turned out to be three weeks stale. I have seen a purchasing decision made off a stock count that was accurate the day it was pulled and wrong by the time anyone acted on it, because the export sat unopened in an inbox for a week.
The other cost is quieter and harder to see on a spreadsheet of its own: trust. Once someone gets burned by an out-of-date copy, they stop trusting the file entirely, including the current one. That is when people start keeping their own personal tracker "just to be safe", which is exactly how you end up with an eighth copy instead of one fewer.
Why more spreadsheet discipline does not fix it
The usual advice is a naming convention, or a shared drive with stricter permissions, or a rule against emailing files. All of that helps a little, and none of it fixes the actual mechanism, because a spreadsheet has no idea it has been copied. Once a file leaves its folder, there is no link back to one source of truth. You are relying entirely on people remembering to update the right copy and nobody else, which is a discipline problem wearing a filing problem's clothes.
The smallest fix that actually works
The fix that holds up is not a bigger policy. It is removing the reason to copy the file in the first place. If the numbers a person needs are always current, in a place they can open on their own without asking a colleague to forward anything, they stop making their own copy. That is the whole logic behind a report that reads your accounting, POS or payroll system directly and refreshes on a schedule: there is exactly one version, it is always the current one, and anyone with access can open it without an email chain.
This does not mean replacing Excel. Most of the businesses I work with keep it for exactly what it is good at: a quick calculation, a working scratchpad, modeling a single scenario before committing to it. What moves out of Excel is anything checked repeatedly by more than one person, because that is exactly the kind of file that grows a seventh copy.
What to actually do first
Before building anything, I ask one question in the diagnostic: which file, if it went stale for a week, would actually cause a bad decision. That is usually a short list, two or three trackers, not the whole shared drive. Those are worth turning into a live report first. Everything else can stay exactly where it is.
If you already know which file that is, that is the right place to start. Send it over as it exists today, copies and all, and the diagnostic will tell you what it would take to make it the last version anyone has to keep track of.