Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jun 2002
    Durham, North Carolina, USA
    Thanked 1 Time in 1 Post
    Howdy folks,

    I'm helping a client automate a couple of templates. Some of the information to be entered (company name, site, etc.) is repetitive so I'd planned to use ASK fields to let them type it once and populate it throughout the document. However, I also planned to use form fields since nearly the entire template is boilerplate text. I've tried it a few times and it seems that the cross-references to the ASK field bookmark don't update if they're in the protected sections of the document.

    1. Am I on the wrong track? i.e. is there a better way to do this?
    2. If not, is there a way around this problem? Maybe protect the section after the the cross-refs have updated?

    Thanks in advance for your advice.


  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Super Moderator
    Join Date
    May 2002
    Canberra, Australian Capital Territory, Australia
    Thanked 188 Times in 172 Posts
    Hi Beej,

    AFAIK, the behaviour you're observing is normal. Have you considered using the document's DOCPROPERTY fields instead, and referencing those?

    Paul Edstein
    [MS MVP - Word]

  4. #3
    Super Moderator
    Join Date
    Jan 2001
    Melbourne, Victoria, Australia
    Thanked 143 Times in 136 Posts
    Since you are using form fields elsewhere, you might as well use these to do the same thing. If you use cross-references to a legacy form field for all the repeated data then you just need to tick the 'Calculate on Exit' option on that form field.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts