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