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.
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?
Just to clarify, do you want to open multiple files, refresh each, then save and close them?