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


Joe S. wrote:
In the 2003 version attempts to calculate from the pivot table generates a
long fomula including an absolute referece - therefore you can't copy the
formula down the column. Is there a way to automatically use relatational
reference rather than absolute reference?--
Joe S.


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