Reply
 
Thread Tools Display Modes
  #1   Report Post  
ChuckZ
 
Posts: n/a
Default how to make table formulas in word documents automatic?

I can create the table; put numeric data in the cells; put the formula in a
cell to add the data; but, if I change the data the formula will not
automatically readd the data. Is there an option I have to turn on?
  #2   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

Have you checked the "Calculate on exit" box in the Form Field Options for
each field that contributes to the calculation?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"ChuckZ" wrote in message
...
I can create the table; put numeric data in the cells; put the formula in

a
cell to add the data; but, if I change the data the formula will not
automatically readd the data. Is there an option I have to turn on?


  #3   Report Post  
ChuckZ
 
Posts: n/a
Default

So the answer is - can't be done automatically. The following note is right
from MS Word Help......

Note Microsoft Word table (table: One or more rows of cells commonly used
to display numbers and other items for quick reference and analysis. Items in
a table are organized into rows and columns.) calculations must be manually
recalculated. Consider using Microsoft Excel to perform complex calculations.


"Suzanne S. Barnhill" wrote:

Have you checked the "Calculate on exit" box in the Form Field Options for
each field that contributes to the calculation?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"ChuckZ" wrote in message
...
I can create the table; put numeric data in the cells; put the formula in

a
cell to add the data; but, if I change the data the formula will not
automatically readd the data. Is there an option I have to turn on?



  #4   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

Okay, you're not using form fields. I missed that. But "manually
recalculated" just means you need to press F9. You could easily write a
macro that would Ctrl+A, F9 (and this is already automatic when you print,
provided you have "Update fields" checked on the Print tab of Tools |
Options; in fact, switching to Print Preview will often do the job).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"ChuckZ" wrote in message
...
So the answer is - can't be done automatically. The following note is

right
from MS Word Help......

Note Microsoft Word table (table: One or more rows of cells commonly used
to display numbers and other items for quick reference and analysis. Items

in
a table are organized into rows and columns.) calculations must be

manually
recalculated. Consider using Microsoft Excel to perform complex

calculations.


"Suzanne S. Barnhill" wrote:

Have you checked the "Calculate on exit" box in the Form Field Options

for
each field that contributes to the calculation?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup so
all may benefit.

"ChuckZ" wrote in message
...
I can create the table; put numeric data in the cells; put the formula

in
a
cell to add the data; but, if I change the data the formula will not
automatically readd the data. Is there an option I have to turn on?




  #5   Report Post  
ChuckZ
 
Posts: n/a
Default

True enough. However, I have people that thinkpressing one extra key to
performa task that should be automatic is too 60's.... I went the way of the
MS Note... creatig an Excel spreadsheet that 'looks' just like the original
document and they are happy.

"Suzanne S. Barnhill" wrote:

Okay, you're not using form fields. I missed that. But "manually
recalculated" just means you need to press F9. You could easily write a
macro that would Ctrl+A, F9 (and this is already automatic when you print,
provided you have "Update fields" checked on the Print tab of Tools |
Options; in fact, switching to Print Preview will often do the job).


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
how can you create quickwords in MS Office Word 2003 Christine S Microsoft Word Help 4 February 8th 05 03:01 PM
How do I create & merge specific data base & master documents? maggiev New Users 2 January 12th 05 11:30 PM
How to change merge forms from Word Perfect to Microsoft Word dollfindance Microsoft Word Help 2 December 30th 04 03:35 PM
Word should allow me to import an already created table from Exce. thechief Tables 3 December 29th 04 10:39 PM
How do I convert a cd in word perfect to microsoft word greylady Microsoft Word Help 1 November 23rd 04 07:03 PM


All times are GMT +1. The time now is 09:38 PM.

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"