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?

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

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Brian Clarke" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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

"Brian Clarke" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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?

Many thanks, that seems to do it.

"Max" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Try Debra's page for a way to turn the "feature" off:
> http://www.contextures.com/xlPivot06.html
>
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "Brian Clarke" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>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?
>>
>>
>>
>
>

welcome, Brian
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Brian Clarke" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Many thanks, that seems to do it.