Copying from a pivot table

[Brian Clarke]

I have a pivot table with data from cell B9 to cell S33. I want to add a few
lines at the bottom (not as part of the pivot table), which subtract the
figures in some of the rows to give a net total.

I have just moved from XL2000 to XL2003, and this has caused a problem.
Previously if say I wanted to subtract the figure in row 21, I could simply
enter "-B21" in cell B38 and copy the formula across as far as column S. Now
I can't do this because XL automatically uses the GETPIVOTDATA function,
which does not adjust relatively as I copy it across.

I can get what I want by first copying the whole table to another location,
but surely there is a simpler way of doing this?

 

[Max]

Try Debra's page for a way to turn the "feature" off:
http://www.contextures.com/xlPivot06.html

 

[Ivan Hung]

Instead of pointing to cell -B21, try entering -B21 to complete the cell
formula
first, then copy it across.

Ivan Hung

 

[Brian Clarke]

Many thanks, that seems to do it.

Try Debra's page for a way to turn the "feature" off:
http://www.contextures.com/xlPivot06.html

 

[Max]

welcome, Brian