Remove 'GETPIVOTDATA'

Hi,

You would have to manually reset the references. It may be possible to parse the formulas in code to determine the correct reference but I suspect it would be time consuming to write such a code. Why do you want to convert them?

hi Keibri. what do you mean by displaying "normally"? the GETPIVOTDATA formula is normal like any other formulas. so what are you expecting it to display as?

i have uploaded a sample for you to see how GETPIVOTDATA works. in cell J4, i used GETPIVOTDATA to help me get the Amt of Company A. in cell K4, i referenced it to cell G4. both gives me the Amt of Company A. but both mean different things. the former will always give me the Amt of Company A, no matter how the Pivot changes. the latter will always give me the Amt inside cell G4.

select Year 2016 in the Slicer (blue button) and you will see the Amt shown differently. GETPIVOTDATA still gives me Amt for Company A.
and cell K4 shows me the Amt for cell G4 (which is now not for Company A).

so if "normally" means to refer to cell references, then no. if "normally is to see the numbers without the GETPIVOTDATA formula, then copy and paste values to the range (mine would be cell J4)