Create summary Formula field that automatically updates

[ucmlamb]

I have a table and I would like to be able to calculate the sum of a column.
I added a Formula field but it requires that you manually update the field
for the calculation to take place. Is there a way to cause this "Total"
field to update automatically if any of the values in the column change -
similar to how it works in Excel.

 

[Greg Maxey]

No. Not with your current method.

You can a. embed an excel sheet or b. use formfields with calculate on
exit enabled in a protected form.

 

[ucmlamb]

Thanks for your help:
a. I tried inserting an Excel sheet but once imbedded it also requires a
manual update - unless I am doing something wrong.
b. I cannot find any documentation on how to create a formfield that does
calculations on other field/column values - can you help here? Also if I
convert the document to a form can I still use Mail Merge to create the form
and fill in other fields?

 

[Greg Maxey]

a. You must be doing something wrong. Did you use Insert>Object>Excel
Worksheet create new?

b. (Part I) See the series of articles here:
http://word.mvps.org/FAQs/TblsFldsFms/LinesInForms.htm

(Part II) Not sure. Mail merge is not a strong suit. You will
have to try or wait on anotther person to answer.

 

[Doug Robbins - Word MVP]

See the following Knowledgebase article:

WD2002: Text Form Fields Are Not Retained During Mail Merge

at

http://support.microsoft.com/kb/286841/en-us


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP