From what I hear from my brother working in a bank, they should be using databases and data querying instead of excel. What excessive excel use leads to, at least in such cases, is awful flimsy practices, certainty and stability.
The financial data and its accumulations run through multiple excel files referencing others. Traceability requirements that they have to guarantee by law are an issue; I wonder if they'll be able to implement them with Excel at all.
Businesses running on Excel is certainly factual. But I have to wonder whether it's necessary of even a good solution for their work.
If they're deep and wide into Excel, I imagine other data tooling would be better. And if they're not, other products like LibreOffice seem viable as direct replacements.
Every large company has sunk countless hours into training people, designing sheets, writing macros etc. Trying to move all that to a different product would be hugely painful and disruptive to everyday operations, because all of that would have to be redone and relearned. No company is going to do that.
It's not like businesses can just not use Excel or whatever. Microsoft has everyone by the balls and they know it.
Excel is a brilliant program, some may even call it excellent.
Businesses run on Excel. While it's feasible (if painful) to replace Word or PowerPoint, replacing Excel is just out of the question.
From what I hear from my brother working in a bank, they should be using databases and data querying instead of excel. What excessive excel use leads to, at least in such cases, is awful flimsy practices, certainty and stability.
The financial data and its accumulations run through multiple excel files referencing others. Traceability requirements that they have to guarantee by law are an issue; I wonder if they'll be able to implement them with Excel at all.
Businesses running on Excel is certainly factual. But I have to wonder whether it's necessary of even a good solution for their work.
If they're deep and wide into Excel, I imagine other data tooling would be better. And if they're not, other products like LibreOffice seem viable as direct replacements.
It's an absolute shit solution but it's being used very widely. And it has certainly led to plenty of fuck ups.
Every large company has sunk countless hours into training people, designing sheets, writing macros etc. Trying to move all that to a different product would be hugely painful and disruptive to everyday operations, because all of that would have to be redone and relearned. No company is going to do that.
Many of my macros / vba code can't run on LibreOffice.
Because they're done with specific ms-office macros or because libre-office has no equivalents?
It may not be an immediate 1 to 1 switch with extensive or specific macros, but I would imagine it would be possible and no worse after migration?