You need to turn this feature off (or on) with the Generate GetPivotData
button. 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




"Poj" wrote:

I've just installed office 2003. I use piovt tables a lot. Before I could use
an existing pivot table in formulas outside the table itself with great ease.
But now, everytime I create a formula outside the pivot table all references
are absolute and is full of no use formulas (like Get.Pivotdata(...). Only
with a lot of work I can go around this new "feature" in excel 2003. Is there
a way to solve this?