Thread: simoultaneous pivot tables

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.

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'

guntherdh wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html