A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Updating Sum Field in Table



 
 
Thread Tools Display Modes
  #1  
Old September 16th, 2008, 08:38 PM posted to microsoft.public.word.tables
Mary Fetsch
external usenet poster
 
Posts: 68
Default 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  
Old September 17th, 2008, 09:10 AM posted to microsoft.public.word.tables
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default 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  
Old September 17th, 2008, 02:04 PM posted to microsoft.public.word.tables
Mary Fetsch
external usenet poster
 
Posts: 68
Default 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  
Old September 17th, 2008, 02:13 PM posted to microsoft.public.word.tables
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default 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  
Old September 17th, 2008, 02:37 PM posted to microsoft.public.word.tables
Mary Fetsch
external usenet poster
 
Posts: 68
Default 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  
Old September 17th, 2008, 02:52 PM posted to microsoft.public.word.tables
Graham Mayor
external usenet poster
 
Posts: 18,297
Default 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  
Old September 17th, 2008, 03:20 PM posted to microsoft.public.word.tables
Mary Fetsch
external usenet poster
 
Posts: 68
Default 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  
Old September 17th, 2008, 05:25 PM posted to microsoft.public.word.tables
Mary Fetsch
external usenet poster
 
Posts: 68
Default 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  
Old September 17th, 2008, 11:10 PM posted to microsoft.public.word.tables
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default 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  
Old September 18th, 2008, 01:42 PM posted to microsoft.public.word.tables
Mary Fetsch
external usenet poster
 
Posts: 68
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:42 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.