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

Trendingnow

1

MacKenzie Scott alone accounted for one-third of America's $19.2 billion in megagifts last year

2

Philanthropy leader at Warren Buffett and Bill Gates’ Giving Pledge says children of billionaires are pushing them to give their wealth away faster

3

Now worth $200 million, Sarah Jessica Parker credits being ‘one of eight kids that struggled financially’ for her hunger, ambition, and work ethic

1

MacKenzie Scott alone accounted for one-third of America's $19.2 billion in megagifts last year

2

Philanthropy leader at Warren Buffett and Bill Gates’ Giving Pledge says children of billionaires are pushing them to give their wealth away faster

3

Now worth $200 million, Sarah Jessica Parker credits being ‘one of eight kids that struggled financially’ for her hunger, ambition, and work ethic

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
  • Pinterest icon

Latest in

The end of Putin’s regime will spring from war spending chaos, former central bank advisor says, amid military mutiny threat and fuel-shortage brawls
EuropeRussia
The end of Putin’s regime will spring from war spending chaos, former central bank advisor says, amid military mutiny threat and fuel-shortage brawls
By Jason MaJune 27, 2026
22 minutes ago
Forget the ceasefire — The U.S. and Iran are still exchanging attacks over the Strait of Hormuz as Tehran tries to shut down a competing route
Middle EastIran
Forget the ceasefire — The U.S. and Iran are still exchanging attacks over the Strait of Hormuz as Tehran tries to shut down a competing route
By Jason MaJune 27, 2026
2 hours ago
p
RetailWorld Cup
The 2 billion-print, $2-pack last hurrah for a World Cup legend: the Panini sticker album’s last ride
By Dave Skretta and The Associated PressJune 27, 2026
4 hours ago
‘I’ll listen to ‘Only the Young’ at home on my own’: Zohran doesn’t know about a Swift-Kelce wedding at MSG, but he’s not going
Arts & EntertainmentNew York City
‘I’ll listen to ‘Only the Young’ at home on my own’: Zohran doesn’t know about a Swift-Kelce wedding at MSG, but he’s not going
By Kimberlee Kruesi and The Associated PressJune 27, 2026
4 hours ago
Australia to strengthen enforcement of under-16 social media ban
PoliticsSocial Media
Australia to strengthen enforcement of under-16 social media ban
By Ainslie Chandler and BloombergJune 27, 2026
4 hours ago
g
EuropeGermany
It’s so hot in Germany the Autobahn literally burst open at the seams and had to be closed down
By Kirsten Grieshaber, Sylvia Hui, John Leicester and The Associated PressJune 27, 2026
4 hours ago

Most Popular

MacKenzie Scott alone accounted for one-third of America's $19.2 billion in megagifts last year
Success
MacKenzie Scott alone accounted for one-third of America's $19.2 billion in megagifts last year
By Sydney LakeJune 25, 2026
3 days ago
Philanthropy leader at Warren Buffett and Bill Gates’ Giving Pledge says children of billionaires are pushing them to give their wealth away faster
Success
Philanthropy leader at Warren Buffett and Bill Gates’ Giving Pledge says children of billionaires are pushing them to give their wealth away faster
By Preston ForeJune 27, 2026
9 hours ago
Now worth $200 million, Sarah Jessica Parker credits being ‘one of eight kids that struggled financially’ for her hunger, ambition, and work ethic
Success
Now worth $200 million, Sarah Jessica Parker credits being ‘one of eight kids that struggled financially’ for her hunger, ambition, and work ethic
By Orianna Rosa RoyleJune 24, 2026
4 days ago
Current price of silver as of Friday, June 26, 2026
Personal Finance
Current price of silver as of Friday, June 26, 2026
By Joseph HostetlerJune 26, 2026
1 day ago
Ray Dalio just finished a 10-day trip to China. He says global leaders know America ‘doesn’t have what it takes to fight to maintain its empire’
Asia
Ray Dalio just finished a 10-day trip to China. He says global leaders know America ‘doesn’t have what it takes to fight to maintain its empire’
By Nick LichtenbergJune 24, 2026
3 days ago
Leon Black says Epstein's network included Elon Musk, Sergey Brin and Peter Thiel, while saying 'I knew Jekyll. I didn't know Hyde'
Politics
Leon Black says Epstein's network included Elon Musk, Sergey Brin and Peter Thiel, while saying 'I knew Jekyll. I didn't know Hyde'
By Joey Cappelletti and The Associated PressJune 26, 2026
1 day 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.