4 ms·
Having worked a decent amount in Excel, here are my key issues: - VBA Macros and Sheets are two distinct paradigms. Within an Excel file, it is not always clea
by Blackstone4 7y ago
Having worked a decent amount in Excel, here are my key issues:
- VBA Macros and Sheets are two distinct paradigms. Within an Excel file, it is not always clear how the two interact and requires meaningful digging.
- Once a numerical model has been calculated in a sheet, it is difficult to scale it. Yes, it is possible to copy sheets but if you make a change or want to do something 100's+ of times, it's a pain.
- Data integrity is a problem. Opps I pressed the wrong key and I deleted some data. Oh shit, I don't have Git to compare what was changed.
PS article dated 2017