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

[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.

 

[Stefan Blom]

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.

 

[Graham Mayor]

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Stefan Blom]

That's even better.

 

[Lon]

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

 

[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.

 

[Graham Mayor]

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Scooter25]

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