If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I create a formula where a cell is automatically shaded ? | Rafi2288 | Worksheet Functions | 1 | April 21st, 2006 03:14 AM |
enable a field if a given field is checked off- otherwise- don't w | babs | Using Forms | 9 | April 18th, 2006 03:36 PM |
Formula Problem - interrupted by #VALUE! in other cells!? | Ted | Worksheet Functions | 17 | November 25th, 2005 05:18 PM |
How do I create a field in a template that automatically puts in . | David Goodwin | General Discussion | 1 | April 26th, 2005 09:39 PM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |