Hyperlink problem.

  • Thread starter Thread starter WenyanCong
  • Start date Start date
W

WenyanCong

I created an excel file and insert a hyperlink that points to
"file:///C:\test.txt" without the quotes. It works fine if I don't move the
excel document. When I move the excel file to a flash drive or different
drive, eg. E drive. It gives me "The address to this site is not valid." and
I notice the hyperlink points to "file:///E:\test.txt" instead of the C path
I point it to. I tested this problem on several workstation and it all have
the same problem. Is there an setting that needs to be change? Thanks
 
Would suggsest to use the HYPERLINK() worksheet function as in below example

=HYPERLINK("c:\test.xls","Click me")

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

Similar Threads

Hyperlink does not work after moving workbook. 1
Why does hyperlink fail? 4
Bookmark in Hyperlink Question 1
Maintaining hyperlinks when I move Excel files to another location 1
Maintain hyperlink when moving excel files 1
Hyperlinks changed by Excel again! 5
Hyperlinks 6
Hyperlinks 1

Back
Top