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'


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