getpivotdata

[Neil]

In Excel 2003, you refer to a cell on a pivot table it
defaults to a "getpivotdata" formula and as an absolute
cell reference. As a result you cannot copy a formula
containing that cell where you want to formula to refer
to the next cell in the pivot table range.

Has anyone run into this issue? Any workaround?

Thanks

 

[Ken Wright]

View / Toolbars / Pivot table / Square icon with small square in top left corner
and diagonal arrow from bottom right. Click it and it will turn off the
generate pivotdata feature.

 

[Debra Dalgleish]

There are instructions here to add the Generate GetPivotData button to
your toolbar. Use it to turn this feature on or off:

http://www.contextures.com/xlPivot06.html

 

[Terri]

Yes, I have. I usually copy and paste special values
right next to the pivot table - then continue building
your formulas based on those numbers.

Or otherwise, you can take the constants ( the $ signs
out )

Good luck