How to Turn Off GetPivotData for Excel Pivot Tables

How to Turn Off GetPivotData for Excel Pivot Tables

 

 

In this video you will learn how to turn the Generate GetPivotData feature on/off for pivot tables.  This feature creates the formulas with the GETPIVOTDATA function when we reference a cell inside a pivot table.    

 

Although GETPIVOTDATA formulas can be useful, they can also be annoying. Fortunately we can turn the feature on or off with a setting on the Options/Analyze tab of the Pivot Tables ribbon. I am also running my free training webinar on pivot tables. 

 

This is an hour long training on "The 5 Secrets to Understanding Pivot Tables". You will learn how pivot tables work to quickly summarize our data and create interactive reports and dashboards. I explain what the proper layout and formatting that is required for the source data, and we also take a look at Power Query.

 

Related Topics:

• Create a Distribution Chart Using PowerQuery and Pivot Tables 
• How to Remove or Replace Errors in Your Pivot Tables 
• Pivot Table Calculation Type Default to Sum Instead of Count 
• 3 Ways to Display (Multiple Items) in a Pivot Table Filter