Budget_v4_FINAL_JB_edits_v2.xlsx
You know the file. It started as a simple tracker, then someone added a tab, then it got emailed to three regional managers to fill in their rows, and two of them replied with their own versions. Somebody now spends a morning copying their changes into the master, and one of the changes gets lost because a row was sorted differently.
The same thing happens with price lists, project trackers, stock sheets and rotas. The file is fine. The way it moves around is the problem.
Ask the team which version is current and you get a pause, then a guess, then someone searching their inbox by date.
Why version chaos keeps coming back
Each email attachment is a full independent copy. Once three people have edited three copies, there is no automatic way to combine them, and nobody knows which changes were deliberate.
Teams often try to fix this with naming rules or a shared drive. Those help for a while, but people still download the file to work offline, still attach it to emails for outside contacts, and still keep a personal copy because the shared one is locked by someone else.
The deeper cause is that the spreadsheet is being used as a multi-user database. Excel is excellent for analysis by one person. It was never designed to be the single record that ten people update at once.
What the chaos costs you
- Time spent merging copies and chasing people for their latest version
- Decisions made on an old copy that someone had open in an email
- Changes that vanish without trace, with no record of who made them
- Customers or suppliers sent the wrong price list
- A single file becoming too large and slow to open
The hardest cost to see is the lack of history. When a figure changes, you cannot tell who changed it, when or why. If it was a mistake, you may only notice weeks later.
How we replace the emailed spreadsheet
First we look at whether a lighter change will do. If the file is mostly read by many and edited by one or two, moving it to SharePoint, OneDrive or Google Sheets with co-authoring and a no-attachments rule may solve it. We will say so if that is the case.
When many people edit the same records, we build something designed for that job.
- We map the spreadsheet: which tabs are data, which are calculations, which are reports, and who edits what.
- We move the data into a proper database with a simple web front end. Each person sees and edits only their rows or region.
- Forms replace free typing, with dropdowns and validation so values like dates and product codes stay consistent.
- Every change is logged with who made it and when, and older values can be restored.
- Calculations the spreadsheet did are rebuilt in the application, checked against the original file until they match.
- An Excel or CSV export button stays, so people who like working in Excel can still pull a copy for analysis without it becoming a competing version.
| Situation | Usually enough |
|---|---|
| One editor, many readers | Shared file with co-authoring in Microsoft 365 or Google Sheets |
| A few editors, simple data | Shared file with protected ranges and a clear owner |
| Many editors, same records | Small web app on a shared database |
| Outside parties must contribute | Web form or portal with their own logins |
Life after the last attachment
There is one place to look and it is always current. Regional managers update their own figures through a form, the master view updates immediately, and nobody spends a morning merging. When someone asks why a price changed, the history shows the answer.
Excel does not disappear. Analysts still export data and build their own models. The difference is that the export is a snapshot for analysis, not a rival master copy.
Permissions also become possible in a way they never were with an attachment. A regional manager sees their region, an outside contractor sees only the rows that concern them, and nobody accidentally forwards the whole company's margins to a supplier.
Does this describe your team?
- File names include words like final, latest or v7
- Someone regularly merges edits from several copies
- You have sent out the wrong version of a price list or schedule
- Nobody can say who changed a particular figure
- The file is slow to open and people are afraid to touch it