You can do this with programming. There are sample files he
http://www.contextures.com/excelfiles.html
Under PivotTables, look for 'PT0021 - Change All Page Fields'
Amk wrote:
I have 2 pivot tables from the same source data. I want to change the
selection in the page area of one pivot table and have the second table
similarly pivoted. (Both tables have the same field in the page area,)
--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog:
http://blog.contextures.com