Problems with Hyperlinks in Excel

[jnkweaver]

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?

 

[kenrivers]

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.

 

[jnkweaver]

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.

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

 

[kenrivers]

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

Hope that works. Let me know the end result.

 

[jnkweaver]

That worked well. We were giving it a little time to make sure the links held. Thanks!

 

[jnkweaver]

Best answer selected by jnkweaver.