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.

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