getpivotdata worksheet
 

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")

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")