View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default linked 3 pivot table pages ?????

You can do that with programming. There are sample files he

http://www.contextures.com/excelfiles.html


Under PivotTables, look for:
'PT0016 - Change Page Fields With Cell Dropdown'
'PT0008 - Change Multiple Page Fields'
'PT0003 - Change Page Field'

shiro wrote:
I have three pivot tables in my workbook,in separate worksheet.
Their data come from the same source.The pivot table differential
is the layout,but all of them use the same field as the page,I want
if I select a page from one of them another two pivot tables will also
dispaly the same page.Is this possible.Thank's in advance.




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html