ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to turn off GetPivotData in MS Office 2007? (https://www.excelbanter.com/excel-discussion-misc-queries/239973-how-turn-off-getpivotdata-ms-office-2007-a.html)

Madelene

How to turn off GetPivotData in MS Office 2007?
 
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

How to turn off GetPivotData in MS Office 2007?
 
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



All times are GMT +1. The time now is 11:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com