create pivot table formula without the GETPIVOTDATA function

[ebergkes]

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]

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]

After posting I saw reference to your site and found the answer there - great
site. Thank you!

 

[Debra Dalgleish]

You're welcome!

After posting I saw reference to your site and found the answer there - great
site. Thank you!

: