Sign in with
Sign up | Sign in
Your question
Solved

Problems with Hyperlinks in Excel

Last response: in Applications
Share
February 1, 2013 11:15:59 PM

I have a colleague at work that has an Excel 2007 spreadsheet (on Windows 7) with multiple hyperlinks to a network drive/folder where the data files are stored. It seems that randomly across multiple sheets about 20% of the hyperlinks are changed from the correct path to his C drive.

Any ideas on why?

Best solution

February 2, 2013 1:05:44 AM

Could be that Excel changes the path from absolute to relative when the file is saved. This http://www.excelbanter.com/showthread.php?t=229767 may help.
Share
Related resources
February 2, 2013 1:20:47 AM

jnkweaver said:
Thanks Ken we are going to try it out to see if it works.

Hope that works. Let me know the end result.
m
0
l
February 10, 2013 10:45:09 PM

That worked well. We were giving it a little time to make sure the links held. Thanks!
m
0
l
February 10, 2013 10:45:22 PM

Best answer selected by jnkweaver.
m
0
l
!