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

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" <Brussels1200@discussions.microsoft.com> wrote in message
news:DEA37211-4C51-4EA5-9D6F-3F17B8B521E0@microsoft.com...
>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")