Hyperlink problem.

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
 
J

Jacob Skaria

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

Top