Reply
 
Thread Tools Display Modes
  #1   Report Post  
Greg
 
Posts: n/a
Default Breakdown of "Calculate on Exit" function in protected documents with TOC

I got some website feedback last night concerning my tips page on
repeating data. The user was having no problem applying the {REF}
field method on new documents but it wouldn't work on several of his
existing documents. On further review the failures always occured in
documents containing a TOC.

I have reviewed some simple sample documents that he provided which are
easy to replicate. In every case regardless if the TOCs are in a
protected or unprotected section the expected behaviour of the
"Calculate on Exit" feature fails.

REF fields are not updated. Calculation formula fields are not
updated. Nothing.

If I unprotectdelete the TOC fieldreprotect then the expected
functionality of "calculate on exit" is restored.

I realize that on exit macros can be used as a work around, but does
anyone have an explanation or reference to a KB article explaining the
cause of this behavior?

Thanks.

  #2   Report Post  
Greg
 
Posts: n/a
Default

Here is a twist. If the REF or Formula field is located before the TOC
in the document then updates do occur with "calculate on exit." It
appears the TOC blocks processing of all fields following it in the
document.

Thoughts or ideas on why this is so?

  #3   Report Post  
Greg
 
Posts: n/a
Default

The answer provided via different route by Bill Coan is to lock the TOC
with CTRL+F11 prior to protecting the form.

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
VBA function results in fields Robert Mulroney Microsoft Word Help 3 July 5th 05 09:03 AM
Word Compare and Merge Document Function EricM Microsoft Word Help 2 March 28th 05 11:53 PM


All times are GMT +1. The time now is 08:01 PM.

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"