Excel has one purpose, data analytics, but as it is a very powerful tool in that regard, with loads of flexible features, people tend to use it in ways that will work for a surprisingly long time, before completely failing.
A common example is to build a database in Excel, say a product catalog with all features and pricing listen in dynamic fields, then someone writes a custom macro to interface the database with external systems, and as new employees join more code is written to make the database easier to update and edit, then more systems are brought in to interface with the database, more data is added, say materials needed in production to build said products, and time calculations to findout how long the different products will take to make, and what product you can make with what you have in inventory, and more macros and integrations.
And it keeps going, but Excel has a hard limit on how much data a sheet can contain, and with all of the new features and integrations it will just be a matter of time untill a new update from Microsoft breaks critical functionallity.
And as the Excel database is used for more and more stuff, it becommes more and more dangerous to the company, at the end you will have an unmaintainable mess that is kept alive on a Windows XP VM running MS Office 2003, since that is the latest system that can run the database with all integrations
A proper SQL database is far more efficient robust, and customizable, but require more indepth knowledge about programming.
Calanthesrose@lemmy.world 10 months ago
From the sounds of it, the company’s entire accounting system is done in a very old version of Excel. One Excel spreadsheet. Which is a very bad idea for so many reasons. If it’s not backed up and gets deleted or corrupted… everything is gone. Not to mention that there’s so many better ways to do your main accounting than Excel. Excel has it’s uses, just not…that.
WashedOver@lemmy.ca 10 months ago
Excellent, yes it was a company that spent multiple millions on SAP and everything went back to multiple versions of these excel spreadsheets the accountants maintained that contained all the costing, time, and labour rates. They also generated code to inject new SKUs into SAP. It seemed pretty fragile to me.
PlasterAnalyst@kbin.social 10 months ago
SAP is garbage.
punkwalrus@lemmy.world 10 months ago
Worked for a company in 1998 that had all the employee data on an excel spreadsheet: everything from emergency contacts to date of last paycheck. All of HR. And “for security” it was stored on a floppy disk. One single disk. Which was put back in the safe every close of business. One day, the disk got corrupted. The “backup” was an end-of-year printout, but any changes since then were gone.