How can formula output be updated when rows &/or columns are added

[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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[mkraft]

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>