Pivot Table #Name? error
Thanks that was a lot easier than the way I was doing it
"Roger Govier" wrote:
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))
--
Regards
Roger Govier
"Dave" wrote in message
...
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
|