Forum Discussion
Pierre Gerrits
Feb 09, 2017Copper Contributor
Create a button to refresh pivot tables in a file
I have a large data query file with a few sheets containing pivot tables. I need to add a button to the first sheet that will refresh all the pivot tables in the file.
Detlef_Lewin
Feb 09, 2017Silver Contributor
Hello Pierre
Excel already has such a button on the ribbon:
Data -> Connections -> Refresh All
You could also put it in the Quick Access Toolbar if you don't want to switch tabs.