linked 3 pivot table pages ?????

[shiro]

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]

You can do that with programming. There are sample files here:

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'