View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default 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