Getpivotdata Function

[Takeadoe]

Good Afternoon - Can anyone help with a question regarding the
"GETPIVOTDATA" function. I would like to use the function in some 700
cells. However, as you can see in the example below, I would have to
manually change the values for both Year and County in each cell.
That's not an option. Is there a better way?

Very best,

Mike

=GETPIVOTDATA("PreTP",'Source Population Data'!$A$3,"Year",
2000,"COUNTY","Adams")

 

[David Heaton]

Good Afternoon - Can anyone help with a question regarding the
"GETPIVOTDATA" function.  I would like to use the function in some 700
cells.  However, as you can see in the example below, I would have to
manually change the values for both Year and County in each cell.
That's not an option.  Is there a better way?

Very best,

Mike

=GETPIVOTDATA("PreTP",'Source Population Data'!$A$3,"Year",
2000,"COUNTY","Adams")

Mike,

You can use cell references such as

=GETPIVOTDATA("PreTP",'Source Population Data'!$A$3,"Year",

A1,"COUNTY",B1)

hth

Regards

David

 

[Takeadoe]

Mike,

You can use cell references such as

=GETPIVOTDATA("PreTP",'Source Population Data'!$A$3,"Year",


hth

Regards

David

David - Thanks for the help. Unfortunately, it does not like A1, B1.
I'm running Excel 2003 if that matters.

Mike

 

[David Heaton]

David - Thanks for the help.  Unfortunately, it does not like A1, B1.
I'm running Excel 2003 if that matters.

Mike- Hide quoted text -

- Show quoted text -

Thats strange as i use this method all the time.

Does A1 and B1 contain 2000 and Adams respesctively ?

if so
Try this....
enter a formula that refers to DATA item in your pivot table (i.e
=G5)

The formula should change to a GETPIVOTDATA formula.

Once you have that replace one item at a time with your cell
reference.

If you are still having problems you can send me your file and i'll
look at it for you..

Regards

David