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'


altah wrote:
I need to link the drop down list in a pivot table to a drop down box in
another worksheet in a workbook. Is there a way to do this?


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