View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] hittingtime@gmail.com is offline
external usenet poster
 
Posts: 5
Default How to Synchronize page fields for two or more than 2 pivot tables?

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.