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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GETPIVOTDATA in Excel 2007 2
GetPivotData Multiple Fields 6
Toggle for GetPivot Data in Office 2007 Excel 2
GETPIVOTDATA #REF! error XL2003/2010 1
getpivotdata 9
Average from the GETPIVOTDATA formula 1
Problem with getpivotdata function 1
Use cell_ref in place of an item in get pivot data function 2

Back
Top