NHS Test and Trace IT blunder blamed on Microsoft Excel glitch

The Microsoft Excel software as shown on a laptop display
(Image credit: Shutterstock)

A “technical issue” identified in the government’s flagship NHS Test and Trace contact-tracing scheme centres on serious limitations in the use of Microsoft Excel to log positive COVID-19 cases.

The government disclosed a technical issue, identified on 2 October, in the data load process that transfers positive COVID-19 lab results to reporting dashboards managed by Public Health England (PHE). This has led to a delay in reporting 15,841 positive COVID-19 cases, with some results stretching as far back as 25 September.

The IT blunder itself arose because the Excel spreadsheet being used to collect positive test results reached its maximum file size, which stopped new names being added in an automated process, according to the Press Association (PA).

To rectify this issue, the Excel files have been split into many smaller files so such a problem doesn’t arise in the future.

Further reports, circulating online, suggest a similar explanation, with the number of Excel columns instead reaching their peak of 16,384 rather than the spreadsheet file size reaching its maximum.

Reports also suggest the positive cases data is normally moved from Excel to Access before feeding into PHE’s reporting dashboards. It should be noted that PHE only reports the data it receives, which itself is collected by NHS Test and Trace.

However, neither explanation for the reporting blunder, nor the precise data transfer mechanism, has been confirmed by official sources. The health secretary Matt Hancock is expected to address the issue in a statement in the House of Commons this afternoon.

“A technical issue was identified overnight on Friday 2 October in the data load process that transfers COVID-19 positive lab results into reporting dashboards,” the government said in a statement published online. “After rapid investigation, we have identified that 15,841 cases between 25 September and 2 October were not included in the reported daily COVID-19 cases. The majority of these cases occurred in most recent days.”

“NHS Test and Trace and PHE have worked to quickly resolve the issue and transferred all outstanding cases immediately into the NHS Test and Trace contact tracing system and I would like to thank contact tracing and health protection colleagues for their additional efforts over the weekend.”

RELATED RESOURCE

Enterprise data protection: A four-step plan

An interactive buyers’ guide and checklist

FREE DOWNLOAD

As a result of the backlog, there were an additional 12,871 cases reported on Saturday evening and 22,961 cases reported on Sunday evening, including thousands of out-of-date positive test results.

NHS Test and Trace had previously come under fire because its organisers launched the programme without conducting a Data Protection Impact Assessment (DPIA). Following legal action, the government conceded the scheme violated GDPR as a result of not being reinforced with a completed DPIA, although its organisers would argue that getting the system off the ground took priority.

Keumars Afifi-Sabet
Contributor

Keumars Afifi-Sabet is a writer and editor that specialises in public sector, cyber security, and cloud computing. He first joined ITPro as a staff writer in April 2018 and eventually became its Features Editor. Although a regular contributor to other tech sites in the past, these days you will find Keumars on LiveScience, where he runs its Technology section.