Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can you create quickwords in MS Office Word 2003 | Microsoft Word Help | |||
How do I create & merge specific data base & master documents? | New Users | |||
How to change merge forms from Word Perfect to Microsoft Word | Microsoft Word Help | |||
Word should allow me to import an already created table from Exce. | Tables | |||
How do I convert a cd in word perfect to microsoft word | Microsoft Word Help |