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

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?