Hyperlinks changing

Hi all,

So I don't know if this is the right place to ask but I noticed this does appear to be a forum for Excel questions, despite this being the 'Access' Programmers forums (whacky right!? :eek:)

Anyway, A colleague of mine has a form with about a bazillion hyperlinks, all of which were added by right click > add hyperlink, no =Hyperlink() method i'm afraid.

We're now encountering a problem because the document is saved on our network, but while the links work fine on her machine they are rewriting themselves whenever i try to open it! the same happens when she sends the document via email.

This is resulting in something like this:
She sees > > > http://file/\\servername\fdrive\folder1\docname.docx
I see - > > > http://file/c:\users\alexsalvadori\folder1\docname.docx

As you can see it's removing the FDrive reference and replacing it with my user documents!

I have searched online and found a few tips but can't seem to get any working, Can anyone tell me how to tell excel to just leave the links alone?

my colleague is using excel 2007 while I am on 2013, but i dont think that's why excel is changing it(?)

Please help :)

thanks in advance,
Alex S

Hyperlinks changing