If you have several versions of the same spreadsheet and nobody's sure which is right, the answer is usually "none of them, completely". The fix isn't a big software project. The first step is to keep one copy in one shared place where everyone works on the same version, and stop emailing files around. After that, you can decide whether the spreadsheet should be connected to your other systems or replaced by something built for the job.
You open the shared drive to check the job cost spreadsheet. And there are four versions. Version 2, Version 3 Final, Version 3 Final Updated, and one just called "Real Final". Which one do you trust?
The version control problem
Everyone has seen this. Multiple versions floating around. Emailed copies that someone edited offline. No idea which one has the current numbers. This is what happens when important business data lives in Excel and gets shared by email.
It works when you're small and one person owns the file. It breaks as the team grows and more people need to see and change the same information. Then the costs start to show:
- Decisions are made on old numbers
- Meetings start with a debate about whose figures are right
- Someone spends hours merging changes from different copies
- Mistakes in one copy quietly carry forward into the next
- When the person who "knows the spreadsheet" is away, nobody else can trust it
Why the problem keeps coming back
Version chaos isn't really about careless people. It happens because the spreadsheet is doing a job it wasn't designed for. It's acting as a shared database, a reporting tool and a record of approvals all at once. Email and local copies are the natural result when a file has to be shared that way.
It also often means the spreadsheet is being filled from other systems by hand. Figures are copied in from Xero or MYOB, from a job system or from a timesheet app. Every copy is a snapshot that goes out of date the moment it's taken.
The first step isn't a big software change
You don't need to overhaul everything. Start here:
- Pick the master copy. Agree which version is current, check it against the others, and archive the rest somewhere clearly labelled "old".
- Move it to one shared location. Excel in SharePoint or OneDrive, or Google Sheets, lets several people work in the same file at once. Everyone opens the same link; nobody saves a copy.
- Stop emailing attachments. Send a link instead. This one habit removes most version problems.
- Decide who can change what. Lock formula cells and give editing rights only to the people who need them.
- Note where the numbers come from. For each figure that's copied from another system, write down the source. That list becomes your guide to what could be connected automatically later.
When to move beyond the spreadsheet
A shared spreadsheet fixes the version problem, but it doesn't fix everything. It may be time for something more if:
- The figures are mostly copied in from other systems by hand
- Several people need to update it at the same time, every day
- You need an audit trail of who changed what and why
- The file is slow, fragile or relies on one person's knowledge
At that point, the options are to connect the spreadsheet to its source systems, build a report or dashboard that pulls the figures directly, or replace it with a proper tool. Our spreadsheet replacement page explains how we decide which fits. And if the real goal is one set of numbers everyone trusts across the business, see one set of numbers everyone trusts.
Frequently asked questions
Is Google Sheets better than Excel for this?
Either works. Excel stored in SharePoint or OneDrive and Google Sheets both let people work in one shared file at the same time. Use whichever your team already has; the important part is having one copy.
How do we stop people downloading their own copies?
Make it a team rule, send links instead of attachments, and make the shared copy the only one that's ever discussed in meetings. If people keep downloading copies, ask why. Often it's because the file is slow or hard to use, which tells you something.
Should we replace our spreadsheets with software?
Not always. Spreadsheets are fine for analysis and one-off work. They become a problem when they act as the main record for something important that many people rely on. That's when connecting or replacing them is worth considering.
What if the spreadsheet has years of complex formulas in it?
That's common. Document what the main formulas do before changing anything. Those rules are your business logic, and they need to carry over to whatever comes next.
If your team is still asking which spreadsheet is correct, book a free initial chat and we'll talk through a sensible next step.