Hyperlink does not work after moving workbook.

W

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?
 
J

Jacob Skaria

Would suggest to use the HYPERLINK() function

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

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top