Solved

Problems with Hyperlinks in Excel

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?
5 answers Last reply Best Answer
More about problems hyperlinks excel
  1. Best answer
    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.
  2. kenrivers said:
    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.
  3. 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.
  4. That worked well. We were giving it a little time to make sure the links held. Thanks!
  5. Best answer selected by jnkweaver.
Ask a new question

Read More

Office Excel Excel 2007 Apps