getpivotdata worksheet
Change the reference B13 to reference B13 on the sheet with the pivottable:
'Pivot Table sheet'!$B$13
So your formula becomes:
=GETPIVOTDATA("Sales",'Pivot Table sheet'!$B$13,"Month","Apr","Name","Richard")
HTH,
Bernie
MS Excel MVP
"Brussels1200" wrote in message
...
I would like to use the getpivotdata formula in a sheet that does not
contains the pivot Table (the pivot table is on another sheet in the same
file), how can I do this??
my sheet name is MARCH
=GETPIVOTDATA("Sales",B13,"Month","Apr","Name","Ri chard")
|