List of spreadsheet mistakes
This is a list of spreadsheet mistakes summarized as a table, including information about when the incident was reported, the organization(s) it involved, a brief description of the incident, and what was the main spreadsheet mistake issue.
A 2017 study concluded that up to 90% of spreadsheets had errors that affected their results.[1] Moreover, a 2026 survey by San Francisco-based business operations software startup DOSS, shows that 22% operation professionals deal with spreadsheet errors every day at work. Of those respondents, 59% say the most common error was manual data entry mistakes and 46% of respondents say that the second most common error was in spreadsheet formulas.[2]
| Date | Organization | Description | Issue | Ref. |
|---|---|---|---|---|
| January 1995 | Fidelity Investments | A $2.6 billion miscalculation after an accountant accountant omitted the minus sign on a net capital loss of $1.3 billion | Omitted minus sign | [3] |
| June 2003 | TransAlta | A $24 million loss from buying more US power transmission hedging contracts at higher prices | Cut and paste issue | [4] |
| November 2005 | Kodak | An $11 million severance error was due to accidentally adding too many zeros to a single employee's accrued severance | Manual data entry | [5] |
| October 2008 | Barclays | Unintentionally revealing 179 contracts Lehman Brothers had intended to trade | Hidden columns | [6] |
| July 2011 | MI5 | A spreadsheet formatting error in 2010 caused MI5 to wrongly collect subscriber data on 134 telephone numbers due to the actual last three digits of telephone numbers being changed to ending in 000 | Formatting error | [7] |
| May 2012 | JPMorgan Chase | A $6 billion loss when a Value-at-Risk model was miscalculated | Cut and paste issue | [8] |
| August 2016 | N/A | Research on estimating that one-fifth of papers with supplementary material containing Excel gene lists to have erroneous gene name conversions | Automatic formatting | [9][10] |
| September 2016 | Lazard | Lazard undervalued SolarCity's valuation by $400 million when performing discounted cash flow valuation analyses | Double-counted | [11] |
| October 2020 | Public Health England | Due to Excel's one million-row spreadsheet limit,15,841 positive Covid tests were left off of the official daily figures | Row limits | [12] |
| December 2021 | Crypto.com | Accidental manual entry caused a $100 refund to be a $10.47 million transfer | Manual data entry | [13][14] |
| August 2023 | Police Service of Northern Ireland (PSNI) | In response to a Freedom of Information (FoI) request, the PSNI had accidentally shared names and personal details of 10,000 serving police and civilian personnel | Overlooked spreadsheet | [15][16] |
See also
[edit]References
[edit]- ↑ "Excel errors: How Microsoft's spreadsheet may be hazardous to your health". ZDNET. Retrieved 2025-11-25.
- ↑ Eaton, Kit (May 14, 2026). "The $4,300 Spreadsheet Mistake Everyone's Making". Inc. (magazine). Retrieved 2026-08-21.
- ↑ Godfrey, Kathy (1995-01-06). "Computing error at Fidelity's Magellan fund". The RISKS Digest. 16 (72) 1.
- ↑ Cullen, Drew (June 19, 2003). "Excel snafu costs firm $24m". The Register. Archived from the original on 2025-09-08. Retrieved 2025-11-25.
- ↑ Jelter, Jim (2005-11-10). "Kodak restates, adds $9 million to loss". MarketWatch. Retrieved 2026-08-24.
- ↑ "Barclays Spreadsheet Error Results In Lehman Chaos". Business Insider. Oct 16, 2008. Retrieved 2025-11-25.
- ↑ Mathieson, S. A. (2011-07-01). "MI5 makes 1,061 bugging errors". The Guardian. ISSN 0261-3077. Retrieved 2026-08-24.
- ↑ Whittall, Christopher. "Value-at-Risk model masked JP Morgan $2 bln loss". U.S. Archived from the original on 2023-03-29. Retrieved 2025-11-25.
- ↑ Ziemann, Mark; Eren, Yotam; El-Osta, Assam (2016-08-23). "Gene name errors are widespread in the scientific literature". Genome Biology. 17 (1) 177. doi:10.1186/s13059-016-1044-7. ISSN 1474-760X. PMC 4994289. PMID 27552985.
- ↑ "Scientists rename human genes to stop Microsoft Excel from misreading them as dates". The Verge. 2020-08-06. Archived from the original on 2022-12-17. Retrieved 2025-11-25.
- ↑ Baker, Liana B. (September 1, 2016). "SolarCity adviser Lazard made mistake in Tesla deal analysis". Reuters. Retrieved August 24, 2026.
- ↑ Hern, Alex (2020-10-06). "Covid: how Excel may have caused loss of 16,000 test results in England". The Guardian. ISSN 0261-3077. Retrieved 2026-08-24.
- ↑ Taylor, Josh (2023-09-24). "A crypto firm sent a disability worker $10m by mistake. Months later she was arrested at an Australian airport". The Guardian. ISSN 0261-3077. Retrieved 2025-11-25.
- ↑ Thorne, Simon (2024-01-25). "Spreadsheet errors can have disastrous consequences – yet we keep making the same mistakes". The Conversation. Retrieved 2025-11-25.
- ↑ Thorne, Simon (2024-01-25). "Spreadsheet errors can have disastrous consequences – yet we keep making the same mistakes". The Conversation. Retrieved 2026-08-24.
- ↑ "PSNI: Major data breach identifies thousands of officers and civilian staff". www.bbc.com. 2023-08-08. Retrieved 2026-08-24.