View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DavidG DavidG is offline
external usenet poster
 
Posts: 4
Default 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?