• Home
  • Latest
  • Fortune 500
  • Finance
  • Tech
  • Leadership
  • Lifestyle
  • Rankings
  • Multimedia

Trendingnow

1

He worked 100-hour weeks to save a nearly bankrupt boat company. At 83, he’s just turned down $400 million for it—and gave it all to charity instead

2

Costco's $14 million email settlement: Who qualifies for an up-to $500 payment and how to claim before the Aug. 24 deadline

3

Mamdani’s pied-à-terre tax was designed to hit the wealthy, but it’s sending most New Yorkers to their estate lawyers

1

He worked 100-hour weeks to save a nearly bankrupt boat company. At 83, he’s just turned down $400 million for it—and gave it all to charity instead

2

Costco's $14 million email settlement: Who qualifies for an up-to $500 payment and how to claim before the Aug. 24 deadline

3

Mamdani’s pied-à-terre tax was designed to hit the wealthy, but it’s sending most New Yorkers to their estate lawyers

Damn Excel! How the ‘most important software application of all time’ is ruining the world

By
Stephen Gandel
Stephen Gandel
Down Arrow Button Icon
By
Stephen Gandel
Stephen Gandel
Down Arrow Button Icon
April 17, 2013, 6:46 PM ET
Add Fortune on Google for similar content.

FORTUNE — Apparently some really smart people have trouble mastering Microsoft Office.

Early Wednesday morning, in an e-mail that went out to reporters around 2 A.M., Harvard professors Carmen Reinhart and Kenneth Rogoff copped to making an Excel error in their research paper tying high levels of government debt to low levels of growth. The paper, “Growth in Time of Debt,” has become a powerful data point for those who argue against government spending even to revive the economy — Congressman Paul Ryan cited it in his most recent budget — and is the basis for the two professors’ best-selling book This Time is Different.

Related: Latest study doesn’t settle the growth and debt debate

When it comes to Excel, though, Reinhart and Rogoff aren’t all that different. Wall Streeters can relate. Prominent financial blogger James Kwak calls Excel “one of the greatest, most powerful, most important software applications of all time.” But perhaps we ask too much of the program, or perhaps of our ability to cut and paste. In the past few years, Excel has been implicated in some of the biggest blunders on Wall Street and in finance in general. Here are some notable Excel victims:

Kenneth Rogoff

Reinhart and Rogoff in their 2010 paper claimed that when a country’s debt hits 90% of its GDP, economic grows slows dramatically. The two Harvard professors said the conclusion was based on looking at the debt levels of dozens of countries going back to the 1800s. But according to a new paper from three economists at University of Massachusetts Amherst, a coding error in the Harvard professors’ spreadsheet completely excluded the first five countries in their dataset, including Australia and Canada, from their calculations. The error, along with some other potential mistakes (which the professors refute), caused the professors to conclude that on average, countries in the 90% plus category tended to see their economies shrink -0.1% a year, according to the University of Mass.

Amherst researchers. In fact, the economies grew 2.2%.

London Whale

In the wake of last year’s $6.2 billion JPMorgan Chase (JPM) trading loss, traders have been fired, top executives have been hauled in front of Congress, and the FBI, among other regulators, is investigating. But you know who really needs to be questioned? Bill Gates. According to an internal report on the trading loss released in February, the model that was supposed to monitor and limit the amount of risk the bank’s London traders were taking was “operated through a series of Excel spreadsheets, which had to be completed manually, by a process of copying and pasting data from one spreadsheet to another.” One key measure was added when it should have been averaged. The result: Risk officers at JPMorgan believed the credit derivatives bets were half as risky as they actually were. So, I guess, CEO Jamie Dimon can pass $3.1 billion off on Excel. The rest is still on him.

MF Global

About a year before MF Global went bust, consultants hired by the firm determined it needed to improve the “end user computer tools such as Excel spreadsheets” that the commodities broker used to monitor risk and how much money it had in its customers accounts, and to make sure that some of that money didn’t end up in the account being used by CEO Jon Corzine to bet on whether or not Europe was about to implode. Those upgrades were never made.

Barclays purchase of Lehman Brothers

When Barclays sent over its offer to buy up Lehman Brothers in the immediate wake of the firm’s September 2008 collapse, it did so with an Excel spreadshet. The makers of the spreadsheet, which detailed Lehman’s assets and what Barclays was willing to buy, hid, rather than deleted, nearly 200 cells. But when a junior law associate at Cleary Gottlieb Steen & Hamilton converted the Excel file to a PDF and e-mailed it over to the bankruptcy court, the hidden parts of the spreadsheet reappeared. The result: Along with the parts of Lehman Barclays wanted, the British bank was also forced to swallow losses on an additional 179 toxic deals it never intended to buy.

Utah

Last year, a miscalculation in Utah’s office of education understated the number of students who would enroll in the state’s public schools and led to a $25 million budget shortfall. The state’s superintendent eventually attributed the error to a “faulty reference in a spreadsheet,” and two of the state’s top finance officials were forced to resign.

Fannie Mae

We should have seen the financial crisis coming. Back in 2003, the giant mortgage guarantor made an error in an Excel spreadsheet when transitioning to a new accounting regulation. The result: an error that made Fannie look $1.3 billion more profitable than it actually was. The company was forced to later restate its results.

Native Americans

A tribe of Native Americans entered the wrong row into the cell of the Excel spreadsheet that contained the formula to compute the net present value of the Island of Manhattan, mistakenly leading them to believe that what was to become New York City was only worth $24, which they accepted in beads and trinkets. Just kidding. The error was made in Lotus.

About the Author
By Stephen Gandel
See full bioRight Arrow Button Icon
Add Fortune on Google for similar content.

Latest in

Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025

Most Popular

Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Fortune Secondary Logo
Rankings
  • 100 Best Companies
  • Fortune 500
  • Global 500
  • Fortune 500 Europe
  • Most Powerful Women
  • World's Most Admired Companies
  • See All Rankings
  • Lists Calendar
Sections
  • Finance
  • Fortune Crypto
  • Features
  • Leadership
  • Health
  • Commentary
  • Success
  • Retail
  • Mpw
  • Tech
  • Lifestyle
  • CEO Initiative
  • Asia
  • Politics
  • Conferences
  • Europe
  • Newsletters
  • Personal Finance
  • Environment
  • Magazine
  • Education
Customer Support
  • Frequently Asked Questions
  • Customer Service Portal
  • Privacy Policy
  • Terms Of Use
  • Single Issues For Purchase
  • International Print
Commercial Services
  • Advertising
  • Fortune Brand Studio
  • Fortune Analytics
  • Fortune Conferences
  • Business Development
  • Group Subscriptions
About Us
  • About Us
  • Press Center
  • Work At Fortune
  • Terms And Conditions
  • Site Map
  • About Us
  • Press Center
  • Work At Fortune
  • Terms And Conditions
  • Site Map
  • Facebook icon
  • Twitter icon
  • LinkedIn icon
  • Instagram icon
  • TikTok icon
  • YouTube icon

Latest in

Current price of Ethereum for July 31, 2026
Personal FinanceEthereum
Current price of Ethereum for July 31, 2026
By Joseph HostetlerJuly 31, 2026
53 minutes ago
Current price of Bitcoin for July 31, 2026
Personal FinanceCryptocurrency
Current price of Bitcoin for July 31, 2026
By Joseph HostetlerJuly 31, 2026
53 minutes ago
Sports teams have gone from trophies to trillion-dollar investment targets
NewslettersTerm Sheet
Sports teams have gone from trophies to trillion-dollar investment targets
By Allie GarfinkleJuly 31, 2026
1 hour ago
Current price of oil as of July 31, 2026
Personal FinanceOil
Current price of oil as of July 31, 2026
By Joseph HostetlerJuly 31, 2026
1 hour ago
Current price of silver as of Friday, July 31, 2026
Personal Financesilver
Current price of silver as of Friday, July 31, 2026
By Joseph HostetlerJuly 31, 2026
1 hour ago
Apple CEO Tim Cook on June 08, 2026 in Cupertino, California. (Photo: Justin Sullivan/Getty Images)
NewslettersFortune Tech
Tim Cook takes his final earnings call as Apple feels the supply pain
By Andrew NuscaJuly 31, 2026
1 hour ago

Most Popular

He worked 100-hour weeks to save a nearly bankrupt boat company. At 83, he’s just turned down $400 million for it—and gave it all to charity instead
Success
He worked 100-hour weeks to save a nearly bankrupt boat company. At 83, he’s just turned down $400 million for it—and gave it all to charity instead
By Preston ForeJuly 29, 2026
2 days ago
Costco's $14 million email settlement: Who qualifies for an up-to $500 payment and how to claim before the Aug. 24 deadline
Retail
Costco's $14 million email settlement: Who qualifies for an up-to $500 payment and how to claim before the Aug. 24 deadline
By Sydney LakeJuly 29, 2026
2 days ago
Mamdani’s pied-à-terre tax was designed to hit the wealthy, but it’s sending most New Yorkers to their estate lawyers
Real Estate
Mamdani’s pied-à-terre tax was designed to hit the wealthy, but it’s sending most New Yorkers to their estate lawyers
By Catherina GioinoJuly 30, 2026
1 day ago
Current price of oil as of July 30, 2026
Personal Finance
Current price of oil as of July 30, 2026
By Joseph HostetlerJuly 30, 2026
1 day ago
'Am I paying for the vibes?' Gen Z says it hates capitalism, but their spending patterns show they just don't like being ripped off
Retail
'Am I paying for the vibes?' Gen Z says it hates capitalism, but their spending patterns show they just don't like being ripped off
By Nick LichtenbergJuly 30, 2026
1 day ago
Tim Cook signed off on his final Apple earnings call with a warning about a ‘hundred year flood’ in memory chip pricing
Big Tech
Tim Cook signed off on his final Apple earnings call with a warning about a ‘hundred year flood’ in memory chip pricing
By Alexei OreskovicJuly 30, 2026
11 hours ago

© 2026 Fortune Media IP Limited. All Rights Reserved. Use of this site constitutes acceptance of our Terms of Use and Privacy Policy | CA Notice at Collection and Privacy Notice | Do Not Sell/Share My Personal Information
FORTUNE is a trademark of Fortune Media IP Limited, registered in the U.S. and other countries. FORTUNE may receive compensation for some links to products and services on this website. Offers may be subject to change without notice.