Read All About IT!
Covid-19 tests under reported due to “Excel error”
It is being reported that the number of Covid-19 cases in England have been mis-counted, due to the statistics being held on an Excel spreadsheet. Nearly 16,000 positive test results were not entered into the “Test & Trace” system, so that people who may have been in close contact with someone who has tested positive may not have been informed of the potential problem.
The Public Health England (PHE) website is here – https://www.gov.uk/government/news/phe-statement-on-delayed-reporting-of-covid-19-cases

Excel has a limit on how many row and columns may be used in any one spreadsheet. It can hold a maximum of 1,048,576 rows and 16,384 columns, which is a staggering amount of information. But, if you have an Excel spreadsheet holding that amount of data, it will struggle to cope in any event, unless the computer has sufficient resources to manage.
It would seem that the maximum limit was reached in a spreadsheet that was being automatically updated with each day’s numbers. The updates were not being entered, but no-one seems to have noticed for a few days.
On Monday, the Press Association (PA) news agency reported that the problem was caused by a Microsoft Excel spreadsheet reaching its maximum file size. Personally I would say that the problem was caused by a lack of knowledge of Excel spreadsheets, rather than any fault in the Excel programme.
Why was such a critical tool in the fight against this pandemic relying on a simple Excel spreadsheet? The solution seems to have been to break down the one Excel spreadsheet into 2 or more such documents. Surely converting the whole lot into a much more sophisticated piece of database software should now be the answer?
We offer free computer advice over the phone. What a shame that Public Health England hadn’t sought our advice early on!
Call us on 01670 432 324 for advice on any Excel spreadsheet issues!
UPDATE:
The BBC is reporting that Public Health England were collating all of the various pieces of information in an old Excel format – XLS. That was replaced by XLSX in 2007! (https://www.bbc.co.uk/news/technology-54423988)
XLS was limited to 65,536 rows and 256 columns of data, whereas XLSX increased that to 1,048,576 rows and 16,384 columns. Quite a difference!