I am trying to use the GetPivotdata function.
When I use a cell reference where the pivot table is located for the pivot table it works, but when I change to the pivot table name(exp"PivotTable1"), I get a reference error.
Can I use the Pivot table name, and if in the same sheet do I still need to use more than just the actual name of the table?
When I use a cell reference where the pivot table is located for the pivot table it works, but when I change to the pivot table name(exp"PivotTable1"), I get a reference error.
Can I use the Pivot table name, and if in the same sheet do I still need to use more than just the actual name of the table?