[justapassenger]

Yes, there's many many cases that should likely not be using Excel.

But given that Excel is the second-best tool for everything, world runs on it.

And when you try to build systems to replace Excel for a specific task, you quickly learn how extremely powerful Excel is and how hard is to replace it and add value that customers would care about.

[array_key_first]

I've been there, the problem is that replacements are not as versatile or "floppy". But that's also a good thing, because Excel is too versatile to the point where most workbooks are filled with bugs on top of bugs and nobody cares.

[justapassenger]

Yes, bugs in sheets are worst part of excel, by far.

But many end users prefer dealing with bugs than with inflexible software that doesn’t understand all the different ways how real world is messy and hard to model.

I hate using Excel. But I 100% understand why world runs on it.