How to turn off GetPivotData in MS Office 2007?

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
 
D

Debra Dalgleish

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
 
Top