I have a spreadsheet with 2 pivot tables. How can I get the pivot tables to automatically refresh whenever someone clicks on the tab with the pivot without having to manually refresh them.
Thanks.
I have a spreadsheet with 2 pivot tables. How can I get the pivot tables to automatically refresh whenever someone clicks on the tab with the pivot without having to manually refresh them.
Thanks.
Prehaps
Change PivotTable1 to your pivot table name
To use code right click pivot sheet then select view code and paste. Updates next tim you select the sheet
Please Login or Register to view this content.
HTH
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
I just wanted to say thanks to VBA NOOB - this saves me time - as I was pressing the red exclamation mark each time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks