| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Updating Sum Field in Table
I have 5 rows in my table column. In the last cell I have the formula
"sum(F1:F4)". I know I can update the sum field by pressing F9, but is there a way to set it so it will update whenever a number is entered in one of the first 4 cells? |
|
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Updating Sum Field in Table
Hi Mary,
Only if your source cells are being updated by way of formfields and the: .. formfield properties are set to 'calculate on exit'; and .. document is protected for forms. -- Cheers macropod [MVP - Microsoft Word] "Mary Fetsch" wrote in message ... I have 5 rows in my table column. In the last cell I have the formula "sum(F1:F4)". I know I can update the sum field by pressing F9, but is there a way to set it so it will update whenever a number is entered in one of the first 4 cells? |
|
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Updating Sum Field in Table
Thanks for your response. I'm using Word 2007, and I don't see anywhere to
insert a formfield. I only way I saw to insert my sum was to click the down arrow next to Quick Parts (on the Insert tab) and choose Field. Then I clicked Formula and entered the sum, and there's no option to Calculate on Exit. Am I missing something? "macropod" wrote: Hi Mary, Only if your source cells are being updated by way of formfields and the: .. formfield properties are set to 'calculate on exit'; and .. document is protected for forms. -- Cheers macropod [MVP - Microsoft Word] "Mary Fetsch" wrote in message ... I have 5 rows in my table column. In the last cell I have the formula "sum(F1:F4)". I know I can update the sum field by pressing F9, but is there a way to set it so it will update whenever a number is entered in one of the first 4 cells? |
|
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Updating Sum Field in Table
Hi Mary,
Formfields are found under 'Legacy Tools' on the Controls Tab on the Developer Ribbon. After inserting a text formfield via the 'Legacy Tools' collection, you'd need to right-click the formfield to access its properties. -- Cheers macropod [MVP - Microsoft Word] "Mary Fetsch" wrote in message news  Thanks for your response. I'm using Word 2007, and I don't see anywhere to insert a formfield. I only way I saw to insert my sum was to click the down arrow next to Quick Parts (on the Insert tab) and choose Field. Then I clicked Formula and entered the sum, and there's no option to Calculate on Exit. Am I missing something? "macropod" wrote: Hi Mary, Only if your source cells are being updated by way of formfields and the: .. formfield properties are set to 'calculate on exit'; and .. document is protected for forms. -- Cheers macropod [MVP - Microsoft Word] "Mary Fetsch" wrote in message ... I have 5 rows in my table column. In the last cell I have the formula "sum(F1:F4)". I know I can update the sum field by pressing F9, but is there a way to set it so it will update whenever a number is entered in one of the first 4 cells? |
|
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Updating Sum Field in Table
Who in the world would know to look there? Typing "formfield" or "form
field" in Help sure doesn't take you there. You are a lifesaver! Thank God for the newsgroups and you! "macropod" wrote: Hi Mary, Formfields are found under 'Legacy Tools' on the Controls Tab on the Developer Ribbon. After inserting a text formfield via the 'Legacy Tools' collection, you'd need to right-click the formfield to access its properties. -- Cheers macropod [MVP - Microsoft Word] "Mary Fetsch" wrote in message news Thanks for your response. I'm using Word 2007, and I don't see anywhere to insert a formfield. I only way I saw to insert my sum was to click the down arrow next to Quick Parts (on the Insert tab) and choose Field. Then I clicked Formula and entered the sum, and there's no option to Calculate on Exit. Am I missing something? "macropod" wrote: Hi Mary, Only if your source cells are being updated by way of formfields and the: .. formfield properties are set to 'calculate on exit'; and .. document is protected for forms. -- Cheers macropod [MVP - Microsoft Word] "Mary Fetsch" wrote in message ... I have 5 rows in my table column. In the last cell I have the formula "sum(F1:F4)". I know I can update the sum field by pressing F9, but is there a way to set it so it will update whenever a number is entered in one of the first 4 cells? |
|
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Updating Sum Field in Table
See also http://gregmaxey.mvps.org/Classic%20Form%20Controls.htm
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Mary Fetsch wrote: Who in the world would know to look there? Typing "formfield" or "form field" in Help sure doesn't take you there. You are a lifesaver! Thank God for the newsgroups and you! "macropod" wrote: Hi Mary, Formfields are found under 'Legacy Tools' on the Controls Tab on the Developer Ribbon. After inserting a text formfield via the 'Legacy Tools' collection, you'd need to right-click the formfield to access its properties. -- Cheers macropod [MVP - Microsoft Word] "Mary Fetsch" wrote in message news Thanks for your response. I'm using Word 2007, and I don't see anywhere to insert a formfield. I only way I saw to insert my sum was to click the down arrow next to Quick Parts (on the Insert tab) and choose Field. Then I clicked Formula and entered the sum, and there's no option to Calculate on Exit. Am I missing something? "macropod" wrote: Hi Mary, Only if your source cells are being updated by way of formfields and the: .. formfield properties are set to 'calculate on exit'; and .. document is protected for forms. -- Cheers macropod [MVP - Microsoft Word] "Mary Fetsch" wrote in message ... I have 5 rows in my table column. In the last cell I have the formula "sum(F1:F4)". I know I can update the sum field by pressing F9, but is there a way to set it so it will update whenever a number is entered in one of the first 4 cells? |
|
#7
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Updating Sum Field in Table
Thanks so much!
"Graham Mayor" wrote: See also http://gregmaxey.mvps.org/Classic%20Form%20Controls.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Mary Fetsch wrote: Who in the world would know to look there? Typing "formfield" or "form field" in Help sure doesn't take you there. You are a lifesaver! Thank God for the newsgroups and you! "macropod" wrote: Hi Mary, Formfields are found under 'Legacy Tools' on the Controls Tab on the Developer Ribbon. After inserting a text formfield via the 'Legacy Tools' collection, you'd need to right-click the formfield to access its properties. -- Cheers macropod [MVP - Microsoft Word] "Mary Fetsch" wrote in message news
Thanks for your response. I'm using Word 2007, and I don't seeanywhere to insert a formfield. I only way I saw to insert my sum was to click the down arrow next to Quick Parts (on the Insert tab) and choose Field. Then I clicked Formula and entered the sum, and there's no option to Calculate on Exit. Am I missing something? "macropod" wrote: Hi Mary, Only if your source cells are being updated by way of formfields and the: .. formfield properties are set to 'calculate on exit'; and .. document is protected for forms. -- Cheers macropod [MVP - Microsoft Word] "Mary Fetsch" wrote in message ... I have 5 rows in my table column. In the last cell I have the formula "sum(F1:F4)". I know I can update the sum field by pressing F9, but is there a way to set it so it will update whenever a number is entered in one of the first 4 cells? |
|
#8
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Updating Sum Field in Table
It appears that the text form fields can be used only if the whole document
is protected. Is there a way to just protect these fields without protecting the whole document? "macropod" wrote: Hi Mary, Formfields are found under 'Legacy Tools' on the Controls Tab on the Developer Ribbon. After inserting a text formfield via the 'Legacy Tools' collection, you'd need to right-click the formfield to access its properties. -- Cheers macropod [MVP - Microsoft Word] "Mary Fetsch" wrote in message news Thanks for your response. I'm using Word 2007, and I don't see anywhere to insert a formfield. I only way I saw to insert my sum was to click the down arrow next to Quick Parts (on the Insert tab) and choose Field. Then I clicked Formula and entered the sum, and there's no option to Calculate on Exit. Am I missing something? "macropod" wrote: Hi Mary, Only if your source cells are being updated by way of formfields and the: .. formfield properties are set to 'calculate on exit'; and .. document is protected for forms. -- Cheers macropod [MVP - Microsoft Word] "Mary Fetsch" wrote in message ... I have 5 rows in my table column. In the last cell I have the formula "sum(F1:F4)". I know I can update the sum field by pressing F9, but is there a way to set it so it will update whenever a number is entered in one of the first 4 cells? |
|
#9
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Updating Sum Field in Table
Hi Mary,
You can use Section breaks before/after the Section(s) you want to protect, then protect only that/those Section(s) -- Cheers macropod [MVP - Microsoft Word] "Mary Fetsch" wrote in message ... It appears that the text form fields can be used only if the whole document is protected. Is there a way to just protect these fields without protecting the whole document? "macropod" wrote: Hi Mary, Formfields are found under 'Legacy Tools' on the Controls Tab on the Developer Ribbon. After inserting a text formfield via the 'Legacy Tools' collection, you'd need to right-click the formfield to access its properties. -- Cheers macropod [MVP - Microsoft Word] "Mary Fetsch" wrote in message news Thanks for your response. I'm using Word 2007, and I don't see anywhere to insert a formfield. I only way I saw to insert my sum was to click the down arrow next to Quick Parts (on the Insert tab) and choose Field. Then I clicked Formula and entered the sum, and there's no option to Calculate on Exit. Am I missing something? "macropod" wrote: Hi Mary, Only if your source cells are being updated by way of formfields and the: .. formfield properties are set to 'calculate on exit'; and .. document is protected for forms. -- Cheers macropod [MVP - Microsoft Word] "Mary Fetsch" wrote in message ... I have 5 rows in my table column. In the last cell I have the formula "sum(F1:F4)". I know I can update the sum field by pressing F9, but is there a way to set it so it will update whenever a number is entered in one of the first 4 cells? |
|
#10
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Updating Sum Field in Table
Thanks so much! You've been very helpful.
"macropod" wrote: Hi Mary, You can use Section breaks before/after the Section(s) you want to protect, then protect only that/those Section(s) -- Cheers macropod [MVP - Microsoft Word] "Mary Fetsch" wrote in message ... It appears that the text form fields can be used only if the whole document is protected. Is there a way to just protect these fields without protecting the whole document? "macropod" wrote: Hi Mary, Formfields are found under 'Legacy Tools' on the Controls Tab on the Developer Ribbon. After inserting a text formfield via the 'Legacy Tools' collection, you'd need to right-click the formfield to access its properties. -- Cheers macropod [MVP - Microsoft Word] "Mary Fetsch" wrote in message news
Thanks for your response. I'm using Word 2007, and I don't see anywhere toinsert a formfield. I only way I saw to insert my sum was to click the down arrow next to Quick Parts (on the Insert tab) and choose Field. Then I clicked Formula and entered the sum, and there's no option to Calculate on Exit. Am I missing something? "macropod" wrote: Hi Mary, Only if your source cells are being updated by way of formfields and the: .. formfield properties are set to 'calculate on exit'; and .. document is protected for forms. -- Cheers macropod [MVP - Microsoft Word] "Mary Fetsch" wrote in message ... I have 5 rows in my table column. In the last cell I have the formula "sum(F1:F4)". I know I can update the sum field by pressing F9, but is there a way to set it so it will update whenever a number is entered in one of the first 4 cells? |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PRINTDATE Field Not Updating | Microsoft Word Help | |||
| Field codes not updating | Microsoft Word Help | |||
| Field not updating in footer | Page Layout | |||
| Field Updating | Mailmerge | |||
| Updating a date field | Microsoft Word Help | |||
Linear Mode
