View Single Post
  #5   Report Post  
Posted to microsoft.public.word.tables
Anna Kezer
 
Posts: n/a
Default Automatic update of calculation fields in a protected form

I just checked - every field with the "Calculate on exit" option has it
checked...

As I mentioned before, I just copied this table with calcultions from
another document - where it does work perfectly - into a new one. Copy-paste
- nothing else. However, updates/calculations do not work in the new document
anymore.
Making from scratch also does not work. Is there some global option for
updating/calculation I am not aware about?


"Suzanne S. Barnhill" wrote:

You described the document as a "protected form." This implies that there
are form fields. Every form field (Form Field Options) has the "Calculate on
exit" option. If your calculation field is based on the data entered in
other form fields, then the "Calculate on exit" property needs to be set in
each field that contributes to the calculation.

--
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.

"Anna Kezer" wrote in message
...
Thanks you for your answer - however, this does not work in this case (at
least, I couldn't put it to work):

1. There is no "Calculate on exit" field to check if one inserts the

formula
through Insert - Field... : when I right-click "Edit formula" on the

created
calculation field, "Field" dialog window opens with a list of Field Names

and
two buttons - Field Codes and Formula... - no "Calculate on exit"

checkbox.
Clicking on either of the buttons does not produce "Calculate on exit"
checkbox anywhere as well.

2. I did try to create a calculation field through insertion of a text
field, selecting "Calculation", entering a formula, and then marking
"Calculate on exit" - however, when I protect the document and a user has

no
access (cannot 'tab' through) to the calculation field, the field does not
get updated since no one enters or exits it...



"Suzanne S. Barnhill" wrote:

Make sure you have "Calculate on exit" checked in each of the form

fields
that contributes to the calculation.

--
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.

"Anna Kezer" Anna wrote in message
...
In Word 2003, I have a table with simple multiplication formulas,

which
should be automatically calculated once the document is protected and

a
user
puts numbers into respective cells. The problem is that this does work

in
one
document, but when I copy-paste the exact same table into another
document,
it stops working. Formulas are assigned to the cell through "Table -
Formula..." and are simple "=PRODUCT(a3,c3)" type.
In unprotected mode, I am able to manually trigger update by F9 or
right-clicking the cell and selecting "Update Field". But this of

course
does
not work for the protected/form mode.
Any ideas why would automatic update of calculation fields work in one
document and would not work in a new one, created by simple

copy/paste, no
properties changed?