Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Hal Hal is offline
external usenet poster
 
Posts: 27
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Formulas in a Table TJ Tables 4 August 29th 07 11:00 PM
How do I do an automatic calculation in table after is locked? Lyn Mailmerge 1 May 25th 06 05:51 AM
Automatic update of calculation fields in a protected form Anna Kezer Tables 8 January 28th 06 01:28 AM
Automatic calculation as data is entered into table cells Gerry Duggan Microsoft Word Help 1 February 23rd 05 11:57 PM
how to make table formulas in word documents automatic? ChuckZ Tables 4 February 19th 05 01:53 PM


All times are GMT +1. The time now is 11:02 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"