Spreadsheets are cool. Where they fall apart they fall apart spectacularly from people insisting on using them as an alternative to a database solution, in my experience. It doesn’t generally matter for normal user centric use cases but I’ve also had to perform a post bankruptcy audit on more than one company that trying to over leverage spreadsheets of duplicate, inconsistent, over saturated, and unreliable data was at the very least a significant contributing factor for the doors being shut.

Over ten contract managers all with their own version of a spreadsheet that tracks reportable items for their contracts and gets rolled up to a master spreadsheet via formulas that financial business decisions gets made from is the first immediate example that comes to mind.