getpivotdata worksheet

[Guest]

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

 

[Bernie Deitrick]

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