Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic calculation as data is entered into table cells
I am trying to set up a table that will sum values as they
enetered into cells. I thought that if I inserted a formula into a cell that this would perform the calculation. The only thing I can get it to do is to perform the calculation once. If I change any of the values in the data cells the total does not change in the cell where the formula has been inserted. I have to renenterthe cell to get a new total if any of the original values are changed. Is ther any way of setting up a formula in a cell that will autimatically caluclate the result as values are added and/or changed? Would appreciate any suggestions. Gerry |
#2
|
|||
|
|||
Calculations (formulas) in Word are inserted as Fields which do not update
automatically. If that is what you want, the best recommendation IMHO is to insert an Excel Worksheet object rather tha using a Word Table. InsertObject Good Luck |:) "Gerry Duggan" wrote: I am trying to set up a table that will sum values as they enetered into cells. I thought that if I inserted a formula into a cell that this would perform the calculation. The only thing I can get it to do is to perform the calculation once. If I change any of the values in the data cells the total does not change in the cell where the formula has been inserted. I have to renenterthe cell to get a new total if any of the original values are changed. Is ther any way of setting up a formula in a cell that will autimatically caluclate the result as values are added and/or changed? Would appreciate any suggestions. Gerry |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
Data Mess | Microsoft Word Help | |||
Mail merge data source problem | Mailmerge | |||
Word Field Codes in Excel data file | Mailmerge | |||
Merge Data Source path | Mailmerge |