Hyperlinks won't work when i save file to another location on my computer

I've created a spreadsheet of clients and info; i want each client name to link to their specific folder on my computer for easy referencing. I entered in all the links and they work just fine; however, when i tried to save the file to another location on my computer so it could be used by another employee (same terminal, etc, just in another folder) the hyperlinks stopped working. Does anyone know of a quick fix for this issue?

Thanks in advance for any suggestions!!

Take care,

Andrea

place the file in the same folder whether the file will be actually and then add hyperlink then it should work fine....

hi, and thank you both for your quick replies!


The original spreadsheet i created has hyperlinks that work just fine. they link to folders on the terminal server. However, when i saved the file in a new location (in order to give a co-worker easier access to it) the hyperlinks ceased to function. i did what you suggested Ford, and one thing i noticed is that there are a series of these \...\...\... in front of the link...i'm assuming they are referencing a drive location but not sure.

anyway, i don't know if there is a way to fix this issue or not; i just want the HL to work independent of where exactly the file is saved on the server. do you think that is possible?

thanks again for all your help!