How to convert GETPIVOTDATA to A1 reference style

[MPFraser7]

Is there a quick way to turn an automatically created GETPIVOTDATA function into a cell reference formula?

For instance, this:

=GETPIVOTDATA("Net Amount",'[FileName.xls]Month'!$A$3,"Unit","02","Group","A")

returns the same thing as

='[FileName.xls]Jul'!$C$10

I want to use the get pivot function to automate cell population, but once that is done, I want to convert them over to the shorter non-getpivotdata formula so it will work w/o having the file with the pivot table open.

Is there a short cut to do this instead of re-doing individual formulas?

Thanks!

 

[63falcondude]

I'm not sure how to change an existing formula without manually typing in the cell address.

For what it's worth, to prevent the GETPIVOTDATA reference in the future, select the PivotTable, Options, down arrow next to options, deselect Generate GetPivotData.