Hi,

I have a problem with using the Microsoft Linked objects from within MS Word referencing source data from various MS Excel work books where link paths are broken when the file is either moved or resaved. Perhaps one of you have had similar experiences and could help to resolve my situation.

My scenario works like this:

- I create a MS Word reporting document
- I reference many graphs and tables from MS Excel by using the Paste Special option
- The MS Excel objects are linked, allowing automatic updates and immediate roundtrip editing

This is how I intended the setup to function.

But I am finding that when I move either of the files, the links then break, turning the MS Excel embedded objects into images. Their reference to the source MS Excel file is broken.

Also if I move the files together to another directory, again the links are broken.

Is there an automated process where I can repair these links in such circumstances?

Or

Is there an option in MS Word where I can use relative link paths to MS Excel objects instead of the absolute link paths that it seems to use?

Your comments appreciated.

I am using Excel and Word 2002.

Thanks.