The bestiary · The Excel Poltergeist

The Excel Poltergeist avatar

Haunting one data team

Specimen · catalogued monster

The Excel Poltergeist

The spreadsheet that secretly runs finance

1Data teams haunted

8 of 20On the leaderboard

It lives in the forty-third tab, rattling macros in the dark and rearranging formulas whenever someone sorts the wrong column. Finance has learned to leave it offerings at month end and never, ever to rename the file.

Symptoms

  • Critical processes run on spreadsheets
  • Macros, manual copy-paste and hard-coded links
  • Versions emailed around as attachments
  • No testing, access control or audit trail
  • One cell error moves the official numbers

Weakness

Exorcism by migration: inventory the critical spreadsheets, move their logic into governed, tested pipelines, and leave Excel for what it does best, the last mile.

Overheard in the corridor

  • “Don't touch that tab, it feeds the board pack.”
  • “Which version is the latest one?”
  • “It's only a spreadsheet, it'll be fine.”
  • “Finance can't close the month without it.”