Pivot Table #Name? error

[Guest]

I am using the GetPivotData function. When I use
=(GETPIVOTDATA(Total,Instance Number)) all is well.

However if I try to point the the sheel, I get the error.
=(GETPIVOTDATA(PartsRoll!Total,Instance Number))

What am I missing?

Thanks

 

[Roger Govier]

Hi Dave

Starting from your destination sheet, type = then navigate to the sheet with
the PT and point to the value required.

It will generate the formula for you.
It may well be something like
=(GETPIVOTDATA(Total,PartsRoll!Instance Number))

 

[Guest]

Thanks that was a lot easier than the way I was doing it