Post an example of what you enter and what is is changed to.

This format:

=HYPERLINK("file:///g:/temp/DSC_0002.JPG")


may help.
--
Gary''s Student - gsnu200773


"Andrew" wrote:

I need to insert hyperlinks into excel aiming at movies on my HDD. (Don't
ask, its a favour for someone) Which works fine, until I save and re-open the
excel file. It appears to be because excel shortens the path and therefore
breaks the link.

I have tried the Properties, Summary and Hyperlink base fix but find this
doesn't work for me. The 'Cannot find specified file' error persists.

I have also used =HYPERLINK function with no luck either.

How can I stop exel shortening the path?

Andrew