The signals that a spreadsheet has outgrown its job
A spreadsheet is often the right tool, and replacing one that works is a waste of money. The question is not whether it is a spreadsheet but whether it has crossed into territory it was never designed for, and there are recognisable signs.
The clearest one is that a specific person has to be present for the file to work. Others follow the same pattern: several versions circulating with different totals, a monthly ritual of copy-paste that nobody can shorten, and formulas nobody dares change because the last person who tried broke the month-end.
- One person is a single point of failure for the file
- Multiple versions circulating with different totals
- A recurring copy-paste ritual nobody can shorten
- Formulas nobody is willing to modify