Refresh Multiple Pivot Tables
 

I have 6 versions of the same pivot table set up so when I
refresh one it automatically updates the other five. The
pivot table is set up through an external data source. I
need to add the same field to all of them but when I into
the individual tables and add the field it is making the
table need it's own refresh and behave totally on it's own
which now means I have to refresh 6 times and the file
itself is now 6 time larger. Is there a way to add the
field to one table and then update the others
automatically so they are all still looking at the same
data.

Any help would be appreciated.

Paul.

Refresh Multiple Pivot Tables
 

I haven't run up against this particular problem, but I doubt you can alter
the built in behavior. In any event, you can create a button on your menu
and assign a macro that runs this command

Public Sub UpdateData()
ThisWorkbook.RefreshAll
End Sub

--
Regards,
Tom Ogilvy

"Paul" wrote in message
...
I have 6 versions of the same pivot table set up so when I
refresh one it automatically updates the other five. The
pivot table is set up through an external data source. I
need to add the same field to all of them but when I into
the individual tables and add the field it is making the
table need it's own refresh and behave totally on it's own
which now means I have to refresh 6 times and the file
itself is now 6 time larger. Is there a way to add the
field to one table and then update the others
automatically so they are all still looking at the same
data.

Any help would be appreciated.

Paul.