I have two independent Pivot Tables. Pivot Table 1 and Pivot table 2
- with different data sources. There is a one field which is
identical in both Pivot Tables - Territory. The Territory is the page
field in both Pivot tables and includes same items. Can I change the
page field item in Pivot Table 1 by selecting an item in Pivot
Table's 2 page fields? I need to get the same Items in both Pivot
tables.

There's a sample file here where changing a page field in one pivot
table programmatically changes the same field in other pivot tables:

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

Under PivotTables, look for 'PT0008 - Change Multiple Page Fields'



Oleg wrote:
I have two independent Pivot Tables. Pivot Table 1 and Pivot table 2
- with different data sources. There is a one field which is
identical in both Pivot Tables - Territory. The Territory is the page
field in both Pivot tables and includes same items. Can I change the
page field item in Pivot Table 1 by selecting an item in Pivot
Table's 2 page fields? I need to get the same Items in both Pivot
tables.



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