View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Amk Amk is offline
external usenet poster
 
Posts: 6
Default Synchronize the Pivot table page field selection in 2 tables?

I have 2 pivot tables that use the same data source. Each has the same Field
(Field1) in the Page Area. Is there a way to link the Item selection in the
page field so that select ing Field 1 Item1 in Pivot1 also selects Field1
Item1 in Pivot2?