Resources

What is Excel hell?

8 min read

Excel hell is the condition where spreadsheets that started as convenient tools have quietly become critical infrastructure — and no one can safely change them anymore.

How it starts

It always starts innocently. Someone builds a quick budget model, a pricing calculator, or a stock reconciliation in Excel. It works perfectly. Other people start using it, then adding to it. New sheets, new formulas referencing other sheets, eventually formulas referencing other files.

Two years later: a 47-sheet workbook drives a monthly close process. Three people's jobs depend on it. Nobody fully understands how it works anymore. The person who built it left.

The signs you're in it

• Formulas that reference other files on network drives that may or may not still exist
• Hardcoded values buried inside formulas ("why is this multiplied by 1.07?")
• Hidden sheets containing logic that nobody touches because "it might break something"
• Circular reference warnings that everyone has learned to ignore
• Key-person dependency: one person is the sole maintainer, and they're a flight risk
• The file hasn't been modified in eight months but it's still used in the monthly report
• Inconsistent formulas — most rows compute one way, a few rows compute differently

Why it matters more than people think

The KPMG Spreadsheet Survey found that 91% of spreadsheets contain material errors. The European Spreadsheet Risks Interest Group (EuSpRIG) catalogues dozens of documented cases where spreadsheet errors caused material financial misstatements, regulatory failures, and operational losses — including the JP Morgan "London Whale" trading loss, where a copy-paste error in a VaR model contributed to a $6 billion loss.

These aren't edge cases. They are the expected outcome when business-critical processes are implemented in a tool with no version control, no testing framework, no access controls, and no separation of logic from data.

What to do about it

Audit first, then remediate. You can't fix what you can't see. A spreadsheet risk audit surfaces the specific issues in your workbooks — broken references, hardcoded values, hidden logic, external dependencies — and ranks them by risk weight. From there you can prioritise which workbooks to document, fix, or replace.