Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Create summary Formula field that automatically updates
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. |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Create summary Formula field that automatically updates
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. |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Create summary Formula field that automatically updates
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. |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Create summary Formula field that automatically updates
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. |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
Create summary Formula field that automatically updates
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to replicate results / create new field names | New Users | |||
Update field automatically | Tables | |||
Date/Time will not automatically update. | Microsoft Word Help | |||
Unable to get field formula to work | Page Layout | |||
How do I create a input text field and a input date field? | Page Layout |