Excel hell – Pandemic pandemonium between the sheets
Posted by MichaelStrelitz 6 years ago
Categories: General, Management
You will remember the newspaper headlines early last month and the howls of disbelief and horrified laughter at the news that 16,000 positive coronavirus tests were lost.
The blunder involved a CSV file (data in a text file with different related items separated by commas), row limits, and an out-of-date Excel file format. All this in a multimillion-pound, “world-beating” contact-tracing system; that went unnoticed for a week of rising infection.
But the true horror is rooted much deeper and wider; a global pandemic that has been poisoning our data and sickening our businesses for 35 years. While soon vaccines and social changes will see COVID-19 demoted to flu status, Excel will still be with us.

Use spreadsheets for their intended purpose
There is an organisation called The European Spreadsheet Risks Interest Group (EuSpRIG) that lists case after case of costly Excel horror stories involving data entry, calculations, modelling, and analytic chaos that have cost hundreds of millions of pounds and put endeavours of all sorts at risk.
Here’s a sample:
- Scientists rename human genes to stop Microsoft Excel from misreading them as dates
- Spreadsheet error leads to Edinburgh hospital delaying opening
- Company submits a bid nearly $3 million lower than it should have been
- Drinks company’s £5.2M spreadsheet arithmetic error
- M&S results hit by spreadsheet mishap
Such problems result from using Excel for purposes it’s not designed to cope with – for databases, or document management systems, or organisation charts, or security front-ends or….or…
Excel and its predecessor, Visicalc, have been around since the advent of the PC 40 years ago. However its incorporation of modern data techniques lacks structure, robustness, verification, documentation, modularity, versioning, variable typing, variable naming, bound labels etc.
People use Excel because it is the only data manipulation tool in Microsoft Office and with the lack of competition, Microsoft hasn’t invested significantly in personal data management for common business users.
Do you run risks with Excel? Are you using it as a database? Or for data entry? Is the smooth running of Excel spreadsheets key to the success of your operations? If so, contact us at DataSafe. We have the expertise address your requirements and convert your spreadsheet use to a robust application. We’re here to help protect your business.
