When Excel is in the news, it’s never a good thing.
via Above The Law
According to the various affidavits (posted below) the Cleary first-year did not notice that the 179 contracts were marked as “hidden” in Excel, and certainly didn’t notice that those entries became “un-hidden” when he globally reformatted the document.
If you’re buying any troubled assets in the near future, be sure to use the auditing feature in any spreadsheets you get. Show the Formula Auditing toolbar and click the Trace Dependents button. The difference between a reference to a visible and hidden cell is shown below.