Excel error gives Barclays more Lehman assets than it wanted

First-year law associates unknowingly add contracts when reformatting a spreadsheet in Excel.

A reformatting error in an Excel spreadsheet has cropped up in the largest bankruptcy case in US history, prompting a legal motion by Barclays Capital to amend its deal to buy some of the assets of Lehman Brothers Holdings.

The law firm representing Barclays filed the motion (download PDF) on Friday in US Bankruptcy Court for the Southern District of New York, seeking to exclude 179 Lehman contracts that it said were mistakenly included in the asset purchase agreement. The firm -- Cleary Gottlieb Steen & Hamilton -- said in the motion that one of its first-year law associates had unknowingly added the contracts when reformatting a spreadsheet in Excel.

At the time when the error occurred, Cleary Gottlieb was working under a tight deadline put in place by the bankruptcy court to submit the purchase offer from Barclays, according to the motion. The mistake was discovered Oct. 1 and was first reported by Above the Law, a legal news Web site.

A representative of the law firm declined to comment about the matter Wednesday.

Lehman Brothers declared bankruptcy on Sept. 15, in the first of a series of blows to the financial sector that quickly led to the meltdown of stock markets worldwide. Three days later, Barclays agreed to acquire some of the US assets of the financially strapped investment bank.

"This court has previously recognized the exigent circumstances surrounding the sale order and the harm to the financial markets that would have resulted had this deal not been completed quickly," Cleary Gottlieb said in Friday's motion. It added that the parties to the deal "were working literally around the clock on an extremely compressed schedule." In light of those circumstances, the law firm asked the bankruptcy court to "correct the record to accurately reflect" the list of Lehman contracts that Barclays meant to include in the deal.

According to the motion, Barclays sent the spreadsheet containing the list of contracts to Cleary Gottlieb at 7:48 p.m. EDT on Sept. 18. The spreadsheet -- which contained almost 1,000 rows of data with a total of more than 24,000 individual cells -- needed to be reformatted and converted into a PDF file so it could be posted on the bankruptcy court's Web site before midnight. At 11:37 p.m., Cleary Gottlieb sent the converted file to the court, the motion said.

However, contracts that had been marked as "hidden" in the spreadsheet when it was received by the law firm were added to the purchase offer during the reformatting process, according to the motion. Those contracts weren't supposed to be part of the deal; they also were marked with an "N" for "No" in the original version of the spreadsheet, Cleary Gottlieb said in the motion.

A hearing on the motion has been scheduled for Nov. 5.

Spreadsheets have long been one of the most popular ways for corporate users to store and analyze data. But over the past few years, they have played an increasing role in data breaches because workers are apt to store them unsecured on laptops. In addition, hackers have actively tried to exploit vulnerabilities in Excel.

Join the newsletter!

Error: Please check your email address.
Rocket to Success - Your 10 Tips for Smarter ERP System Selection
Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Heather Havenstein

Computerworld
Show Comments

Cool Tech

Breitling Superocean Heritage Chronographe 44

Learn more >

SanDisk MicroSDXC™ for Nintendo® Switch™

Learn more >

Toys for Boys

Family Friendly

Panasonic 4K UHD Blu-Ray Player and Full HD Recorder with Netflix - UBT1GL-K

Learn more >

Stocking Stuffer

Razer DeathAdder Expert Ergonomic Gaming Mouse

Learn more >

Christmas Gift Guide

Click for more ›

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Walid Mikhael

Brother QL-820NWB Professional Label Printer

It’s easy to set up, it’s compact and quiet when printing and to top if off, the print quality is excellent. This is hands down the best printer I’ve used for printing labels.

Ben Ramsden

Sharp PN-40TC1 Huddle Board

Brainstorming, innovation, problem solving, and negotiation have all become much more productive and valuable if people can easily collaborate in real time with minimal friction.

Sarah Ieroianni

Brother QL-820NWB Professional Label Printer

The print quality also does not disappoint, it’s clear, bold, doesn’t smudge and the text is perfectly sized.

Ratchada Dunn

Sharp PN-40TC1 Huddle Board

The Huddle Board’s built in program; Sharp Touch Viewing software allows us to easily manipulate and edit our documents (jpegs and PDFs) all at the same time on the dashboard.

George Khoury

Sharp PN-40TC1 Huddle Board

The biggest perks for me would be that it comes with easy to use and comprehensive programs that make the collaboration process a whole lot more intuitive and organic

David Coyle

Brother PocketJet PJ-773 A4 Portable Thermal Printer

I rate the printer as a 5 out of 5 stars as it has been able to fit seamlessly into my busy and mobile lifestyle.

Featured Content

Product Launch Showcase

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?