Loosing Hyperlinks

[canadapip]

Hello,

I've got a worksheet that is stored on a network. In the sheet is a bunch of listings of projects, all of which have hyperlinks to a .PDF file on the network. When the sheet is closed on reopened, the links seem to get lost. Does anyone have any idea on why this is happening and how to fix it?

Thanks!

 

[nbrcrunch]

how are the hyperlinks being created?

1. By right-clicking the cell and adding a link
2. Using the hyperlink() function.

If the first option, here is the proper way to do it:
http://www.techonthenet.com/excel/formulas/hyperlink.php

Here's another possibility:
http://www.geekstogo.com/forum/Excel-hyperlink-problem-t79349.html
(Partial quote from above: i figured out that the problem was that he had the excel file saved in a folder on a network drive, and had the files that he was linking to on the same drive, but had mapped another drive directly to the folder and the problem seemed to happen when he opened the file from the second mapped drive, i think this was causing problems)

More articles about hyperlink issues:
http://www.mrexcel.com/archive/Hyperlinks/index.html


btw, all the above was located by searching for "excel hyperlink" in Yahoo.

.

 

[canadapip]

Thanks for the help nbrcrunch. I'd tried googling a more complete phase and got nothing but ads or unrelated issues. I'll have to wait until Monday and try hopping on the network and seeing if I'm able to get it running!