Pivot tables

C

carrie

How do I link 2 pivot tables together? ie. If I filter on one pivot table I
would like the other pivot table to filter to the same criteria. All data is
from the same source.

thanks,
Carrie
 
D

Debra Dalgleish

I suggested the following, when you posted this question a few days ago:

'============================
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'
'======================

Do you try this and have problems?
 
Top