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???

Some people have said that if they change the hyperlink base
(file|properties|summary tab)
to something that is always available (C:\ for instance), it can help stop those
links from changing.

Maybe it'll work for you.

But that won't help fix the already messed up links.

I try to use the =hyperlink() worksheet function. I've never seen them do
anything bad.

masterbaker wrote:

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???

--

Dave Peterson

Thanks Dave, I used the Hyperlink formula and just had it reference a
hardcoded file name and location in a cell. That works just fine.

Thanks

"Dave Peterson" wrote:

Some people have said that if they change the hyperlink base
(file|properties|summary tab)
to something that is always available (C:\ for instance), it can help stop those
links from changing.

Maybe it'll work for you.

But that won't help fix the already messed up links.

I try to use the =hyperlink() worksheet function. I've never seen them do
anything bad.

masterbaker wrote:

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???

--

Dave Peterson