Create summary Formula field that automatically updates ucmlamb 14.07.2006 15:25:02 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.

Re: Create summary Formula field that automatically updates "Greg Maxey" <gmaxey[ at ]mvps.org> 14.07.2006 15:40:04 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: [Quoted Text] > 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.

Re: Create summary Formula field that automatically updates ucmlamb 14.07.2006 16:25:02 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: [Quoted Text] > 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. > >

Re: Create summary Formula field that automatically updates "Greg Maxey" <gmaxey[ at ]mvps.org> 14.07.2006 17:18:18 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. ucmlamb wrote: [Quoted Text] > 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. > > > >

Re: Create summary Formula field that automatically updates "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 15.07.2006 10:20:48 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" <gmaxey[ at ]mvps.org> wrote in message news:1152897498.027877.310010[ at ]35g2000cwc.googlegroups.com... [Quoted Text] > 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. > > > 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. >> > >> > >