3 ms·
Nearly every Excel wordbook I've ever reviewed has errors caused by updating a complicated model. Often this is down to people adding/deleting/copying or modif
by mr_toad 9y ago
Nearly every Excel wordbook I've ever reviewed has errors caused by updating a complicated model.
Often this is down to people adding/deleting/copying or modifying rows/columns and forgetting to change cell formula.
So, in theory you can modify a workbook and get instant results. In practice this seems to be nearly impossible to to get right.
- munchbunny 9y agoMaybe that implies that we just need to start teaching analysts to write code, but the problem is that when you switch from spreadsheets to honest-to-goodness text-based code, you're just trading one set of problems (spreadsheet mistakes) for another (bugs in your code). In the end I'm personally still in favor of Excel because it has a much gentler learning curve, though you are right that bulk operations in Excel are ripe territory for errors. I don't think it's "nearly impossible" though, it comes down to following best practices the same way you would in any programming language.