You can do this with programming. There's a sample file he

http://www.contextures.com/excelfiles.html#Pivot

Under PivotTables, look for 'Change Page Field'

Henrik wrote:
Is it possible to update (here understood as changing an element of a field)
in more than one table with one operation only, or do all tables have to be
updated manually?

For instance, if I have several pivottables with a 'Country' field in the
page section and I want to update all from, say. Germany to France, can that
be done in one operation?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html