simoultaneous pivot tables

[Guest]

How do you change the page field on multiple pivot tables? I am creating
multiple pivot charts from the pivot tables and the only field that al of the
tables have in common is the page field. The row, data, and column fields
are different. All of the pivot charts are based off of the same source
data. If I have to do itin VB, can someone give me an example? I don't know
how to do pivot tables in VB.

 

[Debra Dalgleish]

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

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

Under Pivot Tables, look for 'Change Page Field'