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.

--
Stefan Blom
Microsoft Word MVP



"Lon" <(E-Mail Removed)> wrote in message
news:ACC274AF-0289-4C5D-AE1D-(E-Mail Removed)...
>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.
>

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
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Stefan Blom wrote:
> 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.
>
>
> "Lon" <(E-Mail Removed)> wrote in message
> news:ACC274AF-0289-4C5D-AE1D-(E-Mail Removed)...
>> 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.

That's even better. :-)

--
Stefan Blom
Microsoft Word MVP



"Graham Mayor" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>
> Stefan Blom wrote:
>> 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.
>>
>>
>> "Lon" <(E-Mail Removed)> wrote in message
>> news:ACC274AF-0289-4C5D-AE1D-(E-Mail Removed)...
>>> 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.
>
>

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 Mayor" wrote:

> 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
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>
> Stefan Blom wrote:
> > 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.
> >
> >
> > "Lon" <(E-Mail Removed)> wrote in message
> > news:ACC274AF-0289-4C5D-AE1D-(E-Mail Removed)...
> >> 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.
>
>
>

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" wrote:

> 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
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>
> Stefan Blom wrote:
> > 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.
> >
> >
> > "Lon" <(E-Mail Removed)> wrote in message
> > news:ACC274AF-0289-4C5D-AE1D-(E-Mail Removed)...
> >> 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.
>
>
>

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
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Lon wrote:
> 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" wrote:
>
>> 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
>> Word MVP web site http://word.mvps.org
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>
>>
>> Stefan Blom wrote:
>>> 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.
>>>
>>>
>>> "Lon" <(E-Mail Removed)> wrote in message
>>> news:ACC274AF-0289-4C5D-AE1D-(E-Mail Removed)...
>>>> 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.

[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