I'm using the GETPIVOTDATA function in one sheet looking at a Pivot Table in
another sheet in the same workbook. My Pivot Table is a Named Range "MMA_TAC".
Oct-06 is the data Field (Formatted as text), RC and Include Flag are rows,
and Loc is a Column. All I can get is #REF!
=GETPIVOTDATA("Oct-06",MMA_TAC,"RC","1","Include Flag","Y","Loc","04")

I'm using Excel 2002 SP3
Thanks
--
Alan L