Getpivot data dynamic reference

[Nicawette]

Hi all,

I am using the getpivotdata to retrieve data from a pivot table,
the formula contains references to cells $C$4,$D$4 for different items
of the fields of the pivot table, where the user can choose via a
dropdown menu the values.

=GETPIVOTDATA("Sum of Volume 1",'Summary 1'!$A$4,"Month",$C
$4,"Country",$D$4)

Would it be possible to do the same for the data field "Sum of Volume
1" and the pivot table name 'Summary 1'!$A$4 as I have different
pivot tables.

I tried the following formula for the pivot table name:
=GETPIVOTDATA("Sum of Volume 1","'"&G4&"'"&"!$A$4","Month",$C
$4,"Country",$D$4)
where G4="Sum of Volume 1"

but excel gives me #ref.

any idea?

thank you

 

[Herbert Seidenberg]

Excel 2007 PivotTable
GetPivotData with drop-down lists.
http://c0444202.cdn.cloudfiles.rackspacecloud.com/02_02_10b.xlsx

 

[goback]

Herbert Seidenberg wrote on 02/05/2010 12:59 ET

Excel 2007 PivotTabl
GetPivotData with drop-down lists
http://c0444202.cdn.cloudfiles.rackspacecloud.com/02_02_10b.xls

thanks for this reply! You saved my life (figuratevely speaking)! I've bee
searching for this solution for a few hours until I found your solution