| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I disable "Get Pivot Data" when working from pivot tables?
Excel 2003 does not allow me to work from a pivot table in the same way Excel
2000 did. When pointing and clicking to a cell in a pivot table, the formula is returned as "get pivot data" and actually goes to the pivot table data, rather than the cell that I have clicked. I am no longer able to copy and paste this. I would like to disable this function and return to the functionally that I had in version 2000. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I disable "Get Pivot Data" when working from pivot tables?
Try this:
Goto ToolsCustomizeCommands Category:Data Drag the GetPivotData Icon at the bottom of the list to to one of your toolbars. Double-click on the icon to toggle GetPivotData on and off Does that help? *********** Regards, Ron "Frustrated excel 2003 user" wrote: Excel 2003 does not allow me to work from a pivot table in the same way Excel 2000 did. When pointing and clicking to a cell in a pivot table, the formula is returned as "get pivot data" and actually goes to the pivot table data, rather than the cell that I have clicked. I am no longer able to copy and paste this. I would like to disable this function and return to the functionally that I had in version 2000. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Minor Clarificaton
Actually, the icon name is Generate GetPivotData and you click it (not
double-click) to toggle. *********** Regards, Ron "Ron Coderre" wrote: Try this: Goto ToolsCustomizeCommands Category:Data Drag the GetPivotData Icon at the bottom of the list to to one of your toolbars. Double-click on the icon to toggle GetPivotData on and off Does that help? *********** Regards, Ron "Frustrated excel 2003 user" wrote: Excel 2003 does not allow me to work from a pivot table in the same way Excel 2000 did. When pointing and clicking to a cell in a pivot table, the formula is returned as "get pivot data" and actually goes to the pivot table data, rather than the cell that I have clicked. I am no longer able to copy and paste this. I would like to disable this function and return to the functionally that I had in version 2000. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ho to Delete "Ghost" Pivot Tables | Excel Discussion (Misc queries) | |||
| Problems with updating category names in pivot tables | Excel Discussion (Misc queries) | |||
| Working with Pivot Tables | Excel Discussion (Misc queries) | |||
| Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
| How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Hybrid Mode
