If you receive an Excel workbook with a Pivot Table in it and try to use the cells in a formula, you’ve probably seen the GetPivotData reference. GetPivotData has some very good uses, but it can be frustrating if you just want to refer to particular values in a range of cells in a Pivot Table.
With your cursor in the Pivot Table, click the Pivot Table Tools Options contextual tab. You’ll find an Options button on the far left. Click on the dropdown arrow to its right. You’ll find an option to turn off the Generate GetPivotData tool.
- Tip Card: Business Management Daily's Favorite Keyboard Shortcuts
- When should I use VLookUp? When is it better to use Index and Match?
- Resolving text-to-columns with line breaks in Excel
- Do others sometimes accidentally delete the Excel formulas you spent hours creating?
- Go beyond Excel filtering with advanced techniques