How do I disable "Get Pivot Data" when working from pivot tables?

G

Guest

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.
 
G

Guest

Try this:
Goto Tools>Customize>Commands
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
 
G

Guest

Actually, the icon name is Generate GetPivotData and you click it (not
double-click) to toggle.

***********
Regards,
Ron
 

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

Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pre-configuring Pivot table "views" 4
Pivot table data source 1
Pivot Tables by Macro 2
disable get pivot table function 3
Pivot tables after Excel 97 2
Pivot Tables- SQL Alias' & Field Lists 1
Excel 2007 Pivot Tables compatible with 2003 3

Top