Pivot Table #Name? error

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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))
 
Back
Top