I am creating some templates with data from an Access database in Excel Pivot tables. I currently hard coded the values in each iteration in the Excel macros. For example, in workbook Build Templates Residential.xls, an instruction in the macro goes to workbook Master Org.xls and populates according to the instruction below:


Sheets("GraphData").Select
ActiveSheet.PivotTables("Graph").PivotFields("Org").CurrentPage = _
"Residential"

I repeat this instruction as many as 25 times for the different values in each macro.

I would like to populate the values in the pivot table dropdown from the values in a pivot table in another spreadsheet.