I want to use cell references in my GETPIVOTDATA function, but I get the #REF! error. My pivot table is being generated from data in a CUBE. When I select the cell I want in the pivot table, the formula returns this: =GETPIVOTDATA("[Measures].[Monthly End In Force Amt]",Data2!$A$4,"[Agency].[Manager]","[Agency].[Manager].[MGA].&[12]","[Product].[LOB]","[Product].[LOB].[Product Category].&[8]").

I'm able to replace the first part of the formula with "Monthly End In Force Amt". I'd like to replace "[Agency].[Manager].[MGA].&[12]" and "[Product].[LOB].[Product Category].&[8]" with cell references. The references to [12] and [8] are the 12th and 8th items listed for MGA and Product Category. I'd like to instead be able to have cells that have the name of those items. For example, say "JOHN DOE" is the 12th MGA. I'd like to have "JOHN DOE" in cell A3 and be able to reference A3 in my formula. When I do so, I get #REF!.

Please help.