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.