GETPIVOTDATA -- How do I shut it OFF!

[besbaum]

We've upgraded to Excel2003, and when I use formulas that referenc
anything in a Pivot table it automatically uses a GETPIVOTDAT
formula.

How do I shut off that annoying feature? I want a plan +A1 reference
. .

It makes the formulas more of a reference to the pivot table itself, s
you can't just "copy them" and get a normal formula

 

[Debra Dalgleish]

There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off:

http://www.contextures.com/xlPivot06.html