How do I update linked objects in a protected Word document?

  • Thread starter Thread starter Lon
  • Start date Start date
L

Lon

I am using Word 2003, running XP Pro. I have a Word document that I have
protected, using "Protect Document", with Read-Only access, and with a few
exceptions. The document contains several tables that are in there as linked
objects. Since the main document is password protected and users can only
update designated fields, how do I allow users to update the linked
objects as well? I have updated the linked objectives, but the updates do
not appear in the primary document. Even after closing and opening the
document it won't update the objects. I also have update linked objects
before printing set and that doesn't work either.
 
I think this can be done with a macro that temporarily unprotects the
document, updates the links, and then reprotects the document. Ask in a VBA
newsgroup (such as microsoft.public.word.vba.general) for confirmation and
further assistance with this.
 
It shouldn't be necessary to unprotect the form in order to update the
links. Simply checking the calculate on exit check box of a form field
should cause the link to update when that field is exited. If it doesn't
then run the sample update macro at
http://www.gmayor.com/installing_macro.htm on exit from the form field to
force the update.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Thank you for your input. I looked for "calculate on exit" check box in
"Tools>Options and can't find where it is located so I can check it. Can you
point me to where it is located?

Thanks again,

Lon
 
Graham, I found the "check box" you are referring to, but, I am not creating
a "form" with text boxes from the "Form" toolbar. I am using Protect Document
in the "Tools" window, which doesn't give you any option to "calculate upon
exit". I have tried the Update Links before Printing" in Tools>Options, but
that doesn't seem to work either. It appears the only way I can update the
links is to stop the password protection, then update the linked objects,
then set the password again, unless I am missing another option. Changing my
document into a "Form" did not work for me since my document is from 50 to 60
pages in length, so I had to use the Protect Document option.
 
Tools > Protect document gives a variety of protection options. What
*exactly* are you doing and what are you trying to protect?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
This sounds really close to what I'm trying to accomplish, which is create a word document that is protected from editing, but will still link back to an excel file.

My doc is a 1 page quote sheet, where I need to have the numbers locked down.

I'm going to try the macro suggested, but I need it to automatically update on opening.

Any suggestions?

Rach
 
Back
Top