When you link to data in a pivot table, you may see a GETPIVOTDATA formula, instead of a simple cell reference.
To turn this feature off, follow the instructions in this short video.
For written instructions, please see Turn Off GetPivotData Formulas for Excel Pivot Tables.
________________