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