Automatic Calculation of Table Formulas

  • Thread starter Thread starter Hal
  • Start date Start date
H

Hal

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?
 
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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Back
Top