Calculations in a Protected Form

  • Thread starter Harold A. Weigle
  • Start date
H

Harold A. Weigle

I created a "protected form" (actually a full
document). Included in the form are tables with the last
entry in each table being a "calculated" value [e.g., =Sum
(Above)]. If I include a Table of Contents in the
document, the "calculated" values no longer work (i.e.,
they remain 0).

I am using Microsoft Word 2002 (10.2627.2625) on Windows
2000.
 
C

Cindy Meister -WordMVP-

Hi Harold,

Tables of Contents simply don't function well in
forms-protected documents. They don't use the same update
mechanism "behind the scenes", so they tend to block
automatic field updating.

What you can do is force the updates using a macro. This
works, for example:
ActiveDocument.Fields.Update

or, you can force the update of a specific range (table,
table row, bookmark, etc.)
I created a "protected form" (actually a full
document). Included in the form are tables with the last
entry in each table being a "calculated" value [e.g., =Sum
(Above)]. If I include a Table of Contents in the
document, the "calculated" values no longer work (i.e.,
they remain 0).
Click to expand...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:)
 
G

Guest

Hi Cindy,

Your solution works like a charm. Thank You.
-----Original Message-----
Hi Harold,

Tables of Contents simply don't function well in
forms-protected documents. They don't use the same update
mechanism "behind the scenes", so they tend to block
automatic field updating.

What you can do is force the updates using a macro. This
works, for example:
ActiveDocument.Fields.Update

or, you can force the update of a specific range (table,
table row, bookmark, etc.)
I created a "protected form" (actually a full
document). Included in the form are tables with the last
entry in each table being a "calculated" value [e.g., =Sum
(Above)]. If I include a Table of Contents in the
document, the "calculated" values no longer work (i.e.,
they remain 0).
Click to expand...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e- mail
:)

.
Click to expand...
 
Top