Central control for pivot tables

[dcozzi]

I have a bunch of pivot tables that display different data but all from the
same data sorce. I would like to be able to make a selection in 1 piviot
table reflecting all of them.

More background:

I have a database which holds info for many companies and is classified by
quarter. Currently, in the page field, i have company and quarter. Is there a
way for me to select the company and quarter in 1 table and have this done
for all of them?

 

[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 Multiple Page Fields'