This could be more of a symptom of Excel (and spreadsheets) being too darn hard to get right.
I've switched to Sqlite and Jupyter from what was a useful but hard to debug spreadsheet with really long repeated formulas that were just database joins. The amount of code to view has probably dropped by 90%. Of course now its easier there is ten times the functionality, but at least its a lot easier to understand some SQL vs Excel formulas.