alt Hacker NewsThe solution is actually just not using Excel. If you're essentially using Excel as a LOB backend and database, that should probably not be in Excel.
It's fine if you have a few formulas. As soon as you're busting out macros it's time to sunset the workbook and make an application. There's a lot of God Excel workbooks sitting around on share drives with no audibility or quality control.
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.