Add a 'Write back from Pivot Table feature. I have developed this feature using VBA, it enables me to change a value on the pivot by a click
I can present my Demo for this cool feature1 vote
This is already supported in Excel 2010 and later when using PivotTables based on data from Analysis Services (or other write-back enabled OLAP providers).
Better backward support for vba macros, it's ridiculous to have to write a new macro for each version of excel in a company.1 vote
As long as you’re using functionality that exists in previous versions, macros should be backward compatible.
If you have a specific problem, please feel free to post it on UserVoice or on answers.microsoft.com.
- Don't see your idea?