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$10I 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?
For instance, this:=GETPIVOTDATA("Net Amount",'[FileName.xls]Month'!$A$3,"Unit","02","Group","A")returns the same thing as ='[FileName.xls]Jul'!$C$10I 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?
