People do silly things. We have a department at work which pulls data from our ERP system to excel. They’re pulling 10’s of thousands of rows to return only a few bits of detail like product descriptions for a handful of items. I’ve offered to help them but they really don’t want help. They seem to be happy with this monster.
There’s another department which runs reports from our BI system, exports it to Excel, adds some calculations, then builds reports from that. They literally just need to ask the BI analyst to build them a report to their requirements.
I’m convinced people like screwing around in excel because it gives them something creative to do in an otherwise bland job.