Link "page-by" drop-down in two pivot tables

[robotman]

Is it possible in Excel to select an item within a page-by in a pivot
table and have a subsequent pivot table with the same drop-down pull
the data for that selected item? For example, let's say I select CA
in a pivot table and the data come up. And I also have another pivot
table with State as the page-by. Is it possible to link the 2 tables
such that data for CA would pop up for the second one automatically?

Thanks.

 

[Debra Dalgleish]

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'