If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 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? |
#8
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 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? |
Thread Tools | |
Display Modes | |
|
|