Excel is used everywhere. With that widespread use comes widespread misuse. If you ever talk to anyone who has worked on help desk in IT if they've seen a cockup due to misuse of Excel they will have a story. Although it's probably dull so don't actually ask.
The use of it to collate data is several massive no-nos. It isn't meant to do that and it's not good at it. It has a bad habit of mangling input data and isn't supported for automated use when there isn't a human watching the screen because well, see above.
Oh
Well they need to sort them selves out