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

besbaum wrote:
We've upgraded to Excel2003, and when I use formulas that reference
anything in a Pivot table it automatically uses a GETPIVOTDATA
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, so
you can't just "copy them" and get a normal formula.




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