Well, the short answer is that word processing programs are for processing
words, spreadsheets are for processing numbers
But it isn't that the
"twain" can't meet:
One option: Instead of the Insert Table feature use the Insert Microsoft
Excel Worksheet feature. The button is right next to the Insert Table button
on the Standard toolbar. I'd do the entire table in the Exel object,
including the formatting. The finished product will look just like a Word
table, but with all the capabilities of an Excel file *without* the hassle
of bookmarks, EQ fields, manual updating, etc. If any changes need to be
made just dbl-click the object & use Excel's features to do them. You can
also resize as necessary to display the appropriate number of columns &
rows.
Another possibility: Go directly into Excel, create the content there, then
copy & paste into the doc. You'll get a Word table with no fields or
bookmarks, but updating calculations based on changes in the values won't be
possible. If updates are at all likely, use Edit Paste Special MS Office
Excel Worksheet Object instead & treat as in the first option above.
--
HTH |:)
Bob Jones
[MVP] Office:Mac
"Bettina" wrote in message
...
I have inserted bookmarks in the cells in my table (one column).
x = a1
x = a2
x = a3
x = a4
x =a 5
x Subtotal cell ? I have tried using a formula: -- insert field, formula.
What is the calculation for adding the cells above. The help menu only
shows
a calculation to add 2 cells instead of a column of cells.
I then have two more cells below the subtotal cell:
x
x
x Total cell. What is the field formula for adding the subtotal and the
two
cells below?
I am using bookmarks because I have a subtotal and 2 cells below to equal
a
total.
PS - Why doesn't Word have any templates with the formula's. It seems that
formula's are primarily done in excel.
Thank you very much!
Bettina