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