Thread: Summing colums
View Single Post
  #6   Report Post  
Posted to microsoft.public.word.tables
R.P.McMurphy
 
Posts: n/a
Default Summing colums

Great! Thanks for that Luc.

Steve

"Luc" wrote in message
...
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" schreef in bericht
...
ok, so how do I change it to a form?

thanks!

Steve

"Luc" wrote in message
...
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" schreef in bericht
...
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