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?

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

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

Under Pivot tables, look for 'Change Multiple Page Fields'

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