Reply
 
Thread Tools Display Modes
  #1   Report Post  
~KO
 
Posts: n/a
Default automatically calculate row above in table word 2000

I have a table using =sum(above) and have even tried =sum(b2:b11) to
automatically update the values. I have to lock and protect this form and
therefore do not have the option of Autosum, or F9. I need to have this cell
update itself as it is entered in the table.

I need to have this done in a couple hours. I'm hopeful someone reads this
soon and can help me!! thanks!

in my email address make sure you 'removethis' from my address - real
address is
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

Sorry I wasn't around. You need to double-click the data entry fields and
choose "calculate on exit".

****************
Anne Troy
www.piersontech.com
www.mrexcel.com


"~KO" wrote in message
...
I have a table using =sum(above) and have even tried =sum(b2:b11) to
automatically update the values. I have to lock and protect this form and
therefore do not have the option of Autosum, or F9. I need to have this

cell
update itself as it is entered in the table.

I need to have this done in a couple hours. I'm hopeful someone reads this
soon and can help me!! thanks!

in my email address make sure you 'removethis' from my address - real
address is



  #3   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

This assumes that the table contains form fields, which is not apparent from
the original post.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Anne Troy" wrote in message
...
Sorry I wasn't around. You need to double-click the data entry fields and
choose "calculate on exit".

****************
Anne Troy
www.piersontech.com
www.mrexcel.com


"~KO" wrote in message
...
I have a table using =sum(above) and have even tried =sum(b2:b11) to
automatically update the values. I have to lock and protect this form

and
therefore do not have the option of Autosum, or F9. I need to have this

cell
update itself as it is entered in the table.

I need to have this done in a couple hours. I'm hopeful someone reads

this
soon and can help me!! thanks!

in my email address make sure you 'removethis' from my address - real
address is




  #4   Report Post  
Andrea Jones
 
Posts: n/a
Default

As you're talking about protecting your document I presume you've got form
fields in your table cells which you want people to fill in and then add up.
The easiest way to do this successfully is to use a simple macro. Go to
Tools - Macros and create a macro called 'update' (or whatever you like).
Type the following under the macro procedu

Sub update()
ActiveDocument.FormFields("Total").Result =
Val(ActiveDocument.FormFields("Num1").Result) +
Val(ActiveDocument.FormFields("Num2").Result) +
Val(ActiveDocument.FormFields("Num3").Result)
End Sub

(My input boxes have bookmarks called Num1, Num2 and Num3 and the result
form field has the bookmark Total).

Save your macro and return to your form, set the 'On exit' box for every
input box (Num1, Num2, Num3) and the result box (Total) to run the macro
'update' (which should be available from the drop-down list if you've created
it successfully).

Protect your form, enter some values and you should get the right answer!

Andrea Jones

"~KO" wrote:

I have a table using =sum(above) and have even tried =sum(b2:b11) to
automatically update the values. I have to lock and protect this form and
therefore do not have the option of Autosum, or F9. I need to have this cell
update itself as it is entered in the table.

I need to have this done in a couple hours. I'm hopeful someone reads this
soon and can help me!! thanks!

in my email address make sure you 'removethis' from my address - real
address is

  #5   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

Whoops! Missed the reference to protecting the form!

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Suzanne S. Barnhill" wrote in message
...
This assumes that the table contains form fields, which is not apparent

from
the original post.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup

so
all may benefit.

"Anne Troy" wrote in message
...
Sorry I wasn't around. You need to double-click the data entry fields

and
choose "calculate on exit".

****************
Anne Troy
www.piersontech.com
www.mrexcel.com


"~KO" wrote in message
...
I have a table using =sum(above) and have even tried =sum(b2:b11) to
automatically update the values. I have to lock and protect this form

and
therefore do not have the option of Autosum, or F9. I need to have

this
cell
update itself as it is entered in the table.

I need to have this done in a couple hours. I'm hopeful someone reads

this
soon and can help me!! thanks!

in my email address make sure you 'removethis' from my address - real
address is





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
Convert Word 2003 documents to WordPerfect formate Carol Microsoft Word Help 6 March 9th 06 08:11 AM
how to convert wordperfect 5.0 floppy files to word pcoelho Microsoft Word Help 2 February 17th 05 07:55 PM
WP Delay Code - Word Equiv Mike G - Milw, WI Microsoft Word Help 6 January 10th 05 05:12 PM
How to change merge forms from Word Perfect to Microsoft Word dollfindance Microsoft Word Help 2 December 30th 04 04:35 PM
How do I convert a cd in word perfect to microsoft word greylady Microsoft Word Help 1 November 23rd 04 08:03 PM


All times are GMT +1. The time now is 12:45 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"