Summing colums

[R.P.McMurphy]

Hi all, I have a nice word .doc with a table in that I need to sum columns.
I can use the tables, format set up and it works, but doesn't instantly
change when any of the numbers in the cells above change like it does on
excel. is there anyway I can get word to recalculate the totals when
changes have been made?

Thanks!

Steve

 

[Luc]

R.P.
You will have to do it manually, select your table, hit F9 and everything
will be recalculated. But that I guess is what you are already doing.
Luc

 

[Luc]

R.P.,
Just realized, if you transform the document into a form the values in the
table could be FormFields. A FormField can be calculated on exit
with the checkbox Calculate on exit. This would recalculate all fields
and formulas when the user leaves field after typing a new value.
Don't know if it will help but there it goes.
Luc

 

[R.P.McMurphy]

ok, so how do I change it to a form?

thanks!

Steve

 

[Luc]

R.P.,
Activate the forms taskbar, in every cell with a number, click on the first
button that looks like ab|, which inserts a text form field, click on the
options button (fourth from the left) and format your number, at the bottom
of the dialog you will find the checkbox calculate on exit. Repeat the whole
process for the other cells. For your totals you can use a calculation form
field, it is the last item in the first list. You should type something like
= SUM (above). As the last step protect your form by clicking on the last
button of the taskbar, it looks like a little lock.
Be aware that this will only work if you protect the form, the user will
only be able to use the form fields and will not be able to modify other
text.
I am using the Dutch version here, so sorry if the wording is not 100%
correct.
Good luck
Luc

 

[R.P.McMurphy]

Great! Thanks for that Luc.

Steve

R.P.,
Activate the forms taskbar, in every cell with a number, click on the
first button that looks like ab|, which inserts a text form field, click
on the options button (fourth from the left) and format your number, at
the bottom of the dialog you will find the checkbox calculate on exit.
Repeat the whole process for the other cells. For your totals you can use
a calculation form field, it is the last item in the first list. You
should type something like = SUM (above). As the last step protect your
form by clicking on the last button of the taskbar, it looks like a little
lock.
Be aware that this will only work if you protect the form, the user will
only be able to use the form fields and will not be able to modify other
text.
I am using the Dutch version here, so sorry if the wording is not 100%
correct.
Good luck
Luc

 

[Luc]

R.P.
My pleasure.
Luc

Great! Thanks for that Luc.

Steve