Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you permanently add colums in File-Open window | Microsoft Word Help | |||
How do I move data Colums within the data source of a mail merge | Microsoft Word Help | |||
Colums in different languages? | Microsoft Word Help | |||
Sort colums in a table | Tables | |||
summing numbers in a document | Microsoft Word Help |