Forum Discussion
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.
Also, when you say Data Query file are you using Power Query and do you want the queries to refresh also, in which case my PivotCache suggestion won't do it for you
This instead....
Sub RefreshAll
ThisWorkbook.RefreshAll
EndSub
Hi there!
I think I have similar concern here.
I have several excel files with pivot tables each and with at least two sheets and I want to automatically refresh in one click of a button all these files which are all connected to db server.
Would really appreciate your responses.
Thanks!
- Hi Dana
Just to clarify, do you want to open multiple files, refresh each, then save and close them?
