November 16, 2026
Spreadsheet risk management: three steps, not just an inventory
An inventory tells you which spreadsheets could cause a problem. It doesn't stop the problem. Here's the third step most spreadsheet risk tools skip, and why it's the one that actually matters.
Managing spreadsheet risk takes three steps: find the spreadsheets that drive a critical process, control the data at the point of entry, and keep a record that proves nothing moved afterward. Most spreadsheet risk tools stop after the first step.
Why “find it and list it” isn’t managing the risk
A lot of spreadsheet risk management starts and ends with discovery: scan the network, find the spreadsheets that matter, put them in an inventory with an owner and a location attached. That’s a genuinely useful first step — you can’t control what you don’t know exists. But an inventory is a snapshot, not a control. It tells you which spreadsheet could cause a problem. It does nothing to stop the problem from happening in the first spreadsheet on the list.
The risk isn’t abstract. Research presented at the European Spreadsheet Risks Interest Group (EuSpRIG) has repeatedly found spreadsheet cell error rates in the range of 1-5%, with one 2015 study measuring 3.9% under lab conditions. And the consequences aren’t theoretical either: JPMorgan’s own 2013 internal task force report into the 2012 “London Whale” trading losses found that a risk model ran through a chain of spreadsheets filled in by manually copying and pasting data between them, and that one formula divided a sum where it should have divided an average — an error that, by some accounts, cut the reported risk measure roughly in half.
An inventory would have listed that spreadsheet. It wouldn’t have caught the formula.
Three steps that actually manage the risk
1. Find the spreadsheets that matter. Not every spreadsheet in the business is a risk. The ones that are: they feed a number into a financial close, a regulatory filing, a production batch release, a capacity plan, a board report. Start here — the same first step most spreadsheet risk tools already do well.
2. Control the data as it’s typed, not after the fact. This is the step an inventory skips. A value entered outside the expected range, in the wrong format, or inconsistent with a related field should be caught at the moment of entry — not discovered three weeks later when someone reconciles the numbers. That means validation rules defined field by field, enforced where the data is actually typed, in the spreadsheet people already use.
3. Prove nothing moved after control took effect. Control without a record is still just a claim. Every change needs an author, a timestamp, and — once a period is closed or a value is approved — either a block on further edits or a visible, recorded correction. A reviewer, an auditor, or a regulator should be able to look at the history and see exactly what happened, not just trust that it did.
A worked example
Picture a capacity-planning spreadsheet used by a network operations team: inputs from multiple regional teams, formulas that roll up into a single utilization forecast, and a deadline every month. An inventory tool would correctly flag this spreadsheet as critical. It would not catch a regional planner typing a utilization figure as a percentage in one cell and a raw count in the next, or notice that a formula reference silently shifted when someone inserted a row. Entry-level validation catches both, immediately, before the rollup is ever calculated. And when someone does need to correct a figure after the fact, the correction shows up as a new, dated entry next to the original, not a silent overwrite.
What this looks like with IT-TIDY
IT-TIDY governs all three steps without asking anyone to leave Excel. Teams keep the spreadsheets and models they already use. Validation rules are defined field by field and enforced the moment data is typed. Every change is recorded — who, what, when — and closed periods stay locked. In a group with roughly 100 foreign subsidiaries running cross-border procurement planning, this approach took data correct at first submission from 39% to 97% and cut central corrections by 85%, using a Lean Six Sigma (DMAIC) method on a certified path.
If you want to see where your own critical spreadsheets stand on these three steps, the free 60-second check-up gives an initial risk score. If you’d rather test entry-level control directly on one process, a 30-day pilot is enough to run it end to end. For how this compares to inventory-focused tools specifically, see IT-TIDY vs. spreadsheet risk / EUC tools, and for the IT/CIO view of this problem, see the IT teams page.
Sources:
- European Spreadsheet Risks Interest Group (EuSpRIG), Panko, R., “What We Know About Spreadsheet Errors,” revisited 2015 — cell error rate research across multiple studies. https://arxiv.org/pdf/1602.02601.pdf
- Bloomberg, “JPMorgan Whale Report Spreads Blame as Dimon’s Pay Halved,” 16 January 2013 — the task force’s findings on the spreadsheet-based risk model. https://www.bloomberg.com/news/articles/2013-01-16/jpmorgan-halves-dimon-pay-says-ceo-responsible-for-lapses-1-