I don't think you want the link source to look like \\information.xls

I think you really want it to be referencing the directory containing
the document containing the link. \\ will not do that.

.\information.xls
would do what you want, if Word allows it.

As far as Excel is concerned, formula links to workbooks in the same
directory, or a sub-directory thereof, are held as relative links so
you would not need to do anything.

I bow to Macropod's knowledge of Word for how to handle such links in
Word.


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup