G Guest Jan 12, 2007 #1 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?
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?
D Debra Dalgleish Jan 13, 2007 #2 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'
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'
