Excel Hyperlinks
 

number one when my users do insert hyperlink and browse to a network
drive using excel outlook etc... it puts the unc path in to the server
where the file is located is there away to make it use the drive
letter in all cases? Also is there an easy way to chang the existing
links over after the fact maybe to use the hyperlink function in excel
or whatever. reason to use the drive letter is there is a replicated
site (our second office) with its own server where the files are
stored that is going to have huge challenges very shortly if i can't
do this. Thanks in advance for any and all help!!!