Hi,

Im using GETPIVOTDATA(data_field,pivot_table,field1,item1,f ield2,item2,...)

and it works just fine until I try and reference a cell for
"data_field,pivot_table".

If I type the name of the data_field into the formula it works fine when
referenceing a cell I get #REF!

I might ad that anywhere else in the formula I am able to reference cell


for example

This works
=GETPIVOTDATA("New Subscribers",$A$3,E1,I$4+1,"WeekDay",$G9)

This doesnt
=GETPIVOTDATA(E3,$A$3,E1,I$4+1,"WeekDay",$G9) where cell E3 contanins the
text : New Subscribers