Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn off XML Prompt when saving Excel files in Office 2007 to 2003 | Excel Discussion (Misc queries) | |||
Does anyone know how to turn off the GetPivotData function? | Excel Worksheet Functions | |||
Does anyone know how to turn off the GetPivotData function? | Excel Worksheet Functions | |||
How do I use turn GETPIVOTDATA function off? | Excel Worksheet Functions | |||
How do I turn OFF the GETPIVOTDATA function? | Excel Discussion (Misc queries) |