Copying from a pivot table

  • Thread starter Thread starter Brian Clarke
  • Start date Start date
B

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?
 
Instead of pointing to cell -B21, try entering -B21 to complete the cell
formula
first, then copy it across.

Ivan Hung
 
Back
Top