Check out this link...

http://www.contextures.com/excelfiles.html#Pivot
--
HTH...

Jim Thomlinson


" wrote:

How to Synchronize page fields for two or more than 2 pivot tables?
I have two pivot tables that have the same page fields. I want them to
have the same page fields selections.

For example,
Page fields for pivot table 1 a Product, Market;
If I choose product: A, B;
Market: JP, UK
for pivot table 1;

I want pivot table 2 have those selections automatically for those two
fields.

Regards.

Any one has any ideaes? Thanks.