But there are still massive pain points or improvements that could be added. For instance:
- linking between excel and powerpoint. Almost anyone who will show an analysis, whether in a bank, accounting firm, consultant, etc will prepare some table and charts in excel and will want to use them in powerpoint. The link between the two is unstable, screws the formatting, or requires lots of manual steps.
- Microsoft should really look into Apple’s take on excel, with a sheet being a canvas on which you can add tables, charts, the tables have scroll bars if they overflow. Instead of the rigid single grid per tab, where if you show two tables one over the other you need to align the columns even when they have different data types.
- VBA hasn’t been updated in 20 years and it clearly shows. There needs to be a more modern scripting language. I have heard rumors about javascript. Not convinced it’s a great choice, but that would still be better than VBA.