Hyperlink does not work after moving workbook.

[WenyanCong]

If I create a new workbook on my desktop and insert a hyperlink that points
to "C:\test.txt". If I save the workbook and re-open it, the link still works
fine but if i move the newly created workbook to a different directory or
partition(eg. H drive), the hyperlink inside the workbook is broken. it now
points to "H:\test.txt" instead of the C drive. is there any way to fix this
small little problem?

 

[Jacob Skaria]

Would suggest to use the HYPERLINK() function

=HYPERLINK("c:\test.txt","test.txt")

If this post helps click Yes