Drop down list linking

[altah]

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]

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'