I have two hyperlinks within my main file that open other excel files. One of
the links works fine 100% of the time, but the other doesn't work once I save
the file. The location of the one that works is in the same folder as my main
file, but the one that bonks is located in another location on my network.

When I click on the problem link it says that the address of this site is
not valid. When I edit the hyperlink the address at the bottom has changed
from what it should be to the correct location preceeded by
..../.../.../.../.../

When I correct the link to the right file it works fine, but as soon as I
save the file and try the link again it bonks!!

Why would this be happening and what can I do to correct this???