Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Automatic Calculation of Table Formulas
Is there a way to set Word so that a target cell automatically re-calculates
whenver any of the cells used in the formula is changes? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Automatic Calculation of Table Formulas
Only if the components of the formula are provided from the results of form
fields in a protected form and you have the calculate on exit check box properties of the fields checked. Otherwise you would have to force an update of the fields in the calculation. You can do that with a macro, such as that used as an example at http://www.gmayor.com/installing_macro.htm Alternatively you can insert an Excel table and have the full panoply of Excel functions available. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "Hal" wrote in message ... Is there a way to set Word so that a target cell automatically re-calculates whenver any of the cells used in the formula is changes? |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Automatic Calculation of Table Formulas
Only if the components of the formula are provided from the results of form
fields in a protected form and you have the calculate on exit check box properties of the fields checked. Otherwise you would have to force an update of the fields in the calculation. You can do that with a macro, such as that used as an example at http://www.gmayor.com/installing_macro.htm Alternatively you can insert an Excel table and have the full panoply of Excel functions available. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "Hal" wrote in message ... Is there a way to set Word so that a target cell automatically re-calculates whenver any of the cells used in the formula is changes? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Formulas in a Table | Tables | |||
How do I do an automatic calculation in table after is locked? | Mailmerge | |||
Automatic update of calculation fields in a protected form | Tables | |||
Automatic calculation as data is entered into table cells | Microsoft Word Help | |||
how to make table formulas in word documents automatic? | Tables |