Excel Pivot Tables
 

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,)

Excel Pivot Tables
 

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