Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
R.P.McMurphy
 
Posts: n/a
Default Summing colums

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


  #2   Report Post  
Posted to microsoft.public.word.tables
Luc
 
Posts: n/a
Default Summing colums

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
"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



  #3   Report Post  
Posted to microsoft.public.word.tables
Luc
 
Posts: n/a
Default Summing colums

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



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

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





  #5   Report Post  
Posted to microsoft.public.word.tables
Luc
 
Posts: n/a
Default Summing colums

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









  #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









  #7   Report Post  
Posted to microsoft.public.word.tables
Luc
 
Posts: n/a
Default Summing colums

R.P.
My pleasure.
Luc
"R.P.McMurphy" schreef in bericht
...
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











Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you permanently add colums in File-Open window Mitch B Microsoft Word Help 0 October 18th 05 09:25 PM
How do I move data Colums within the data source of a mail merge hf Microsoft Word Help 1 July 5th 05 09:57 PM
Colums in different languages? TT templates Microsoft Word Help 1 July 4th 05 06:05 PM
Sort colums in a table judy Tables 2 December 21st 04 07:01 PM
summing numbers in a document Michael Preminger Microsoft Word Help 1 December 8th 04 02:22 PM


All times are GMT +1. The time now is 06:09 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"