GETPIVOTDATA USING THE PIVOT Table name

[Joe C]

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?

 

[Norie]

As far as I know you can't use the name. I suppose you could name a range in the PivotTable and use that.

 

[Joe C]

Just tried the named range and that works.