Pivot Table #Name? error
 

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

Pivot Table #Name? error
 

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

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