how to make table formulas in word documents automatic?

C

ChuckZ

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

Suzanne S. Barnhill

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

ChuckZ

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.
 
S

Suzanne S. Barnhill

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).
 
C

ChuckZ

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top