Pivot Tables

[carrie]

Can I have two pivot charts linked? if I have two pivot tables (same data
source) can I filter on one table and have the other automatically filter to
the same criteria?

Thanks,
Carrie

 

[Debra Dalgleish]

There's a sample file here that changes the page field in all pivot
tables, when the master pivot table is changed:

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

Under Pivot Tables, look for 'Change Page Field'