If you're using Insert|hyperlink, try changing the base address:

File|Properties|summary tab (near the bottom of the dialog)

(Point at the C:\ folder--it should be available for all users????)

But I've never had any trouble using the =hyperlink() worksheet formula.

=hyperlink("file:////c:\my documents\word\doc1.doc","Click Me")

Nicola wrote:

When I add a hyperlink i always add the hyperlink as the document is on
another shared drive. The link path keeps reverting to the format:

..\..\

and loses the link

Any ideas how I can keep the absolute path?
--
Nicola

--

Dave Peterson