I have worked my way through Pivot Table Data Crunching Excel 2010 - great book -and have set up a number of macros for each pivot table grouping. I have set up a macro for Refresh All but it doesn't seem to work I have set up macros to refresh each state of the pivot table and that works as long as you remember which button you have pressed in the first place. If you press the wrong button - errors! I have set up Pivot Clear All in the Quick Access Toolbar and that works OK. How do I get a refresh or a reset for all the pivot table states or create a macro for Pivot Clear All? Can I write a macro which will will allow me to click a menu button in any order and go to the next pivot table state without Pivot Clear All?
I hope someone can help me!
Kind regards
Tom
I hope someone can help me!
Kind regards
Tom
Last edited:
