When you try to reference a cell on the Pivot Table you might have experienced a magical formula appearing automatically which looks like something below.
Well, when I first discovered I had NO clue what was happening, and the interesting part when I try to perform calculations I never use hit the correct numbers.
Basically, you might have experienced the same as I had, that it always refer to the first records in your dataset and not relatively referencing.
What is the GETPIVOTDATA function?
In simple expression, this function returns data from a PivotTable by automatically generating the formula.
Sometimes we need to perform calculations referencing the values in PivotTable which can be done using the GETPIVOTDATA, but there is a simple trick here we can stop generating the GETPIVOTDATA function automatically.
Trick 01
Simple point the cell reference to the data without using the mouse cursor
That will not generate the GETPIVOTDATA function
Trick 02 – temporarily disable
How to Stop generating GETPIVOTDATA function in Excel for Mac and Windows
- Keep the cell on the Pivot Table
- PivotTable Analyze & Design Tab will be activated in the Excel Ribbon
- Select PivotTable Analyze > Option > Uncheck “Generate GetPivotData”
By unchecking you will stop generating automatic GETPIVOTDATA function and we will be able to reference the cell and do the calculation while referencing the cell to Pivot Table Data.
Download the practice file << CLICK HERE >>
Was the information helpful in this blog?
- If yes, hit that share button and show the excitement to the world.
- Subscribe to our free posts.
If no, please let us know what to improve.
Having trouble with any Office Apps. Feel free to ask and answer queries at our forums section.