How Excel may have caused loss of 16,000 Covid tests in England | Health policy | The Guardian - 0 views
-
dr tech on 05 Oct 20"But while CSV files can be any size, Microsoft Excel files can only be 1,048,576 rows long - or, in older versions which PHE may have still been using, a mere 65,536. When a CSV file longer than that is opened, the bottom rows get cut off and are no longer displayed. That means that, once the lab had performed more than a million tests, it was only a matter of time before its reports failed to be read by PHE."