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

ebergkes wrote:
Previous to Excel 2003 I could use a pivot table result in a formula and copy
that formula as a relative reference. In Excel 2003 a GETPIVOTDATA fromula
is created and uses an absolute reference. Is there a way in Excel 2003 to
either make it arelative reference (without editing the formula) or revert to
the method used in all prior releases?


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