[mkraft]

How can the results of formulas in WORD tables be updated, when not only the
input data referenced by the formulas changes, but rows &/or columns are
added or subtracted to the table containing the formula(s), thus changing the
cell locations referenced by the formula(s)?

I assume (fingers crossed) there is a way to do this?

Replies appreciated.

Example: Formula in cell G4 . . . =E4*F4. Then a row is added above, so
that G4 becomes G5. How, other than actually editing the formula each time
this happens, can the formula be made to continue working properly?

[Graham Mayor]

Unlike Excel where this sort of thing is handled transparently, Word tables
only hold what you put into them. You will either have to bookmark the items
you wish to calculate and then use eg
{={Bookmarkname1} * {BookmarkName2}} as the bookmark names will always apply
to the same content whatever you add (provided you don't destroy the
bookmarks in the process) or you could do all the mathematics in Excel and
paste a link from the Excel table into the Word document.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


mkraft wrote:
How can the results of formulas in WORD tables be updated, when not
only the input data referenced by the formulas changes, but rows &/or
columns are added or subtracted to the table containing the
formula(s), thus changing the cell locations referenced by the
formula(s)?

I assume (fingers crossed) there is a way to do this?

Replies appreciated.

Example: Formula in cell G4 . . . =E4*F4. Then a row is added
above, so that G4 becomes G5. How, other than actually editing the
formula each time this happens, can the formula be made to continue
working properly?

[mkraft]

"Graham Mayor" wrote:

You will either have to bookmark the items
you wish to calculate and then use eg
{={Bookmarkname1} * {BookmarkName2}} as the bookmark names will always apply
to the same content whatever you add

Thanks. Can the bookmarking you refer to be done from the 'Insert'
(Bookmark) dropdown menu, or is it necessary to use codes? If the latter,
can you suggest where I might find a good explanation of how to use them --
i.e., specifically the Bookmarkname codes?

[Graham Mayor]

You can use the insert bookmark command.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


mkraft wrote:
"Graham Mayor" wrote:

You will either have to bookmark the items
you wish to calculate and then use eg
{={Bookmarkname1} * {BookmarkName2}} as the bookmark names will
always apply to the same content whatever you add

Thanks. Can the bookmarking you refer to be done from the 'Insert'
(Bookmark) dropdown menu, or is it necessary to use codes? If the
latter, can you suggest where I might find a good explanation of how
to use them -- i.e., specifically the Bookmarkname codes?