Hi all,

Using Excel 2010

My GETPIVOTDATA() formula is returning a #REF! error.
Odd, because this works

=GETPIVOTDATA("PortionScore",$D$11,"Account","Total Revenue","SubCategory","Merchandise")

But when I change to this, I get the error :

=GETPIVOTDATA("PortionScore",'4L'!$D$11,"Account",$B3,"SubCategory",AF$3)

I have checked and rechecked the values in $B3 and AF$3 - they are definitely correct

What am I missing?
Thanks
w