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?