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

Thank you for your answer. I've checked the original table: it doesn't use
bookmarks - rather, it uses cell names like in Excel (A3, C3).

However, as per your suggestion I've tried using bookmarks (went and put
fields with bookmarks and "calculate on exit" checked oneverywhere) but it
didn't help - in protected mode fields/cell of the table still would not get
updated. In unprotected, I get calculation results only if I right-click and
select "Update Field" in the pop-up menu.

This drives me crazy!

"Charles Kenyon" wrote:

Often copies of formfields will lose their bookmark names. Not sure if this
happens when copying between documents. Make sure each of the formfields has
a bookmark name - and that it is the name used in the calculations.

In your formulae, make sure you are using the bookmark names rather than the
table cell references.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Anna Kezer" wrote in message
...
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?