How to turn off GetPivotData in MS Office 2007?

  • Thread starter Thread starter Madelene
  • Start date Start date
M

Madelene

Could someone pls share with me how to turn off this feature in MS Office
2007 so my formulas from a pivot table could be easy to understand?

Many thanks!

Madelene
 
Select any cell in a pivot table
On the ribbon, click the Options tab, under PivotTable Tools
At the far left, click Options, in the PivotTable group
Click Generate GetPivotData, to remove the check mark
 
Back
Top