[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 wrote:
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.

[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" wrote:

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 wrote:
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]

a. You must be doing something wrong. Did you use InsertObjectExcel
Worksheet create new?

b. (Part I) See the series of articles he
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.


ucmlamb wrote:
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" wrote:

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 wrote:
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.

[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

"Greg Maxey" wrote in message
ups.com...
a. You must be doing something wrong. Did you use InsertObjectExcel
Worksheet create new?

b. (Part I) See the series of articles he
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.


ucmlamb wrote:
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" wrote:

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 wrote:
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.