Friday, March 31, 2017
Overheard at Booth 2: Excel Spreadsheets
When I first started that job I accidentally corrupted all the team’s spreadsheets. We’re talking ALL of them – forecasts, budgets, rolling forecasts, actuals, P&L Summaries, everything. Didn’t mean to. It just happened. Something about having two separate Excel programs opened at the same time and copying from one version to another corrupted all the hidden macros, which crashed the format.
My boss was pissed. When he asked me what I did and how I did it, I couldn’t think of anything to say except that I was testing them. He said, “Testing them?” and I said, “Yeah, I had to make sure the spreadsheets were idiot-proof. Turns out they’re not.”