getpivotdata question

[largeselection]

Hi,

So I want to use a cell reference in a getpivotdata function but it keeps springing a #ref error.

The formula originally looked like:
=GETPIVOTDATA("2010 Vol $",PT!$A$3,"PERSON",A6,"AREA NAME",B6)

With A6 = to a person's name and B6 = to the area.

What I tried to do is change it to:
=GETPIVOTDATA(E1,PT!$A$3,"PERSON",A6,"AREA NAME",B6)

Where E1 = 2010 Vol $

I thought that would work, but it doesn't. Do I need to do an indirect thing?

THANKS

 

[GlennUK]

Like this:

=GETPIVOTDATA(""&E1&"",PT!$A$3,"PERSON",A6,"AREA NAME",B6)

 

[largeselection]

THANKS!

I tried =GETPIVOTDATA(" & E1 & ",PT!$A$3,"PERSON",A6,"AREA NAME",B6) at first and it didn't work, I guess I was missing that second set of quotation marks.

Thanks again!

 

[GlennUK]

My pleasure.