Pivot tables Excel 2003 absolute references
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?
|