How can I refresh data in pivot tables lcoated in separate tab
I am not understanding how to execute this. Could you be more specific?
"Jim Thomlinson" wrote:
If you want all pivot tables to be refreshed then
ThisWorkbook.RefreshAll
If you only want specific tables refreshed then it gets trickier...
--
HTH...
Jim Thomlinson
"DavidG" wrote:
I have one data table and have numerous worksheet tabs for each pivot table
accessing the table. I would like a way to refresh all of the pivot tables
without having to go into each tab refreshing the associated pivot table.
Any thoughts?
|