Working with linked documents

[Guest]

I use MS Office 2003 Pro on WinXP SP2. I want to be able to use an Excel
workbook as a source document template and a Word document template as the
destination, and I made all the links from the Template.doc to Template.xls.
This is for a large report (100+ pages), so I have about 500 links. For my
first attempt at a doing a new report using these templates, I made a copy of
each, renaming them Test.doc and Test.xls, and changed some of the data in
Test.xls. When I opened Test.doc, it asked me if I wanted to update the
links. I said yes, but it didn't update from Test.xls. I went to Edit|Links
and the Source Document is still Template.xls. It doesn't seem as though I am
able to change the source document without going into each individual entry.
I can highlight the list and click 'change source' and keep clicking until
they are all changed, but that is crazy!! I will end up with carpal finger

Is there a better way to accomplish this?

 

[Beth Melton]

You should be able to select the first link, hold Shift, and select
the last link to group them.

If that doesn't work then you can use Find/Replace for this:

- Press Alt + F9 to toggle the display of field codes
- Press F5 to open Find
- Click the Replace tab
- In Find What type: Template.xls
- In Replace with type: Test.xls
- Replace All
- Press Alt + F9 to toggle the field codes
- Press Ctrl + A to select the entire document
- Press F9 to update the links

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/