Excel Pivot Tables

[Amk]

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]

You can do this with programming. There are sample files here:

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

Under PivotTables, look for 'PT0021 - Change All Page Fields'