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.

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.