GetPivotData function - how to disable

[Viggo]

With the introduction of the 2002 version Excel changes
how it handles reference to a cell in a pivot table. Now
(2002 and 2003) Excel uses GetPivotData() instad of
simple using traditional cell reference. Is it possible
to turn this "feature" off?

 

[Debra Dalgleish]

You can choose Tools>Customize, and from the Data category on the
Commands tab, add the Generate GetPivotData command to one of your
toolbars. Use this button to toggle the feature on and off.

Or, you can type an equal sign, and type the cell reference, instead of
clicking on the cell to reference it.

 

[Viggo]

Brilliant, thanks a million!

-----Original Message-----
You can choose Tools>Customize, and from the Data category on the
Commands tab, add the Generate GetPivotData command to one of your
toolbars. Use this button to toggle the feature on and off.

Or, you can type an equal sign, and type the cell reference, instead of
clicking on the cell to reference it.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.