View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nelson[_9_] Nelson[_9_] is offline
external usenet poster
 
Posts: 2
Default linking pivot tables by page fields

Hello,
I have two pivot tables on the same worksheet that have the same page
fields. When I change one of the "pages", using the listbox, I often
forget to change the corresponding page on the other pivot table. I'm
wondering if there is a way to "link" these pivot tables so that when I
change one page field they will both automatically go to the same page.
Thanks for your help,
Nelson