My worksheet has a refence to a cell in a pivot chart. Instead of the
formula being R1C1 type it is referncing the formula within the refereced
cell...eg. it is returnig someting like =GETPIVOTDATA("[Measures].[Sys
Qty]",$A$15,"[Period Day]","[Period Day].[Q206].[JUL].[FW200622]") instead of
me simply wanting =j50. How do I do that?