Hi sooz,

In Word, cell references are always absolute (equivalent to $A$1 etc in
Excel).

First off, you'll need to insert new *form* fields into the cells that
trigger the calculations. If you copy these from another row, the copies
lose any assigned bookmark names. If your *formula* fields refer to the
*form* field bookmarks, you'll need to make sure each copied form field is
given a new unique bookmark name.

If you copy *formula* fields using *cell* references from another row, all
you'll need to do to them is to update the row references.

If you copied *formula* fields using *form field bookmark* references from
another row, you'll need to update the bookmark references, so that they
point to the corresponding new bookmarks referred to in my second para
above.

Cheers


"sooz" wrote in message
...

Hiya,

I am updating a Word form template that somebody else has written.
It seems they've used formulas within the table.
They've got 4 columns - quantity, description, unit cost, extended
cost.
The formulas are used to calculate the extended cost, sub-total, gst
and total.
I need to add two extra rows in here, and I thought it would be simple
but it's not!
I've unprotected the template so I can edit it.
I've inserted 2 extra rows at the bottom (just before the sub-total)
and copied and pasted the cells from one of the lines above into the
two new ones.
The only problem is, it doesn't adjust the formulas like Excel does! I
have tried going in and adjusting the formulas myself by right-clicking
on the cell, going to edit field, clicking on Formula and then changing
the cell references to suit the new rows. But I get 'undefined
bookmark' errors!
I have no idea what to do... can anybody help?!

sooz


--
sooz