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

Madelene wrote:
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


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com