I do not know what you mean by "Microsoft knows it and invests in it accordingly". For me, the big quality of Excel is that it has almost not changed in 20 years. If Microsoft changes anything in excel, this will hurt millions of users.
> I do not know what you mean by "Microsoft knows it and invests in it accordingly". For me, the big quality of Excel is that it has almost not changed in 20 years. If Microsoft changes anything in excel, this will hurt millions of users.
Microsoft has changed lots of things in Excel. The pivot tables and graphs were rewritten in 2007. The statistics functions were rewritten in 2010. These are pretty fundamental features.
The key is that they made these changes by versioning. v1 Pivot Tables are not automatically converted to v2 Pivot Tables. The new statistics functions have new names -- the old statistics functions are still around. This ensures bug-for-bug compatibility with old spreadsheets.
