Blog

How to Turn Off GetPivotData Formula in Pivot Table

How to Turn Off GetPivotData Formula in Pivot Table


While working in the pivot table we will get disturbed by the GetPivotData Formula in the Pivot table while writing the formula based on the pivot table it will give the same result in the all cells


And here we have the option to turn off the GetPivotData formula option by making uncheck in the option of the GetPivotData Formula option in the Microsoft Excel

Step-1

click on the options
Step-2


and uncheck the option in Use GetPivotData Function for Pivot Table References under working with formulas

Video Link: Watch Video

Phone : +91 8606648045
Email : info@excelskillcorner.com
Excel Skill Corner
Kerala, India.