Hyperlink Error

H

HK2006

I apologize for asking the same question. I tried to do all the
recommendations from previous questions but my problem still exists.

In my excel worksheet, for a particular cell, I tried to create a hyperlink
to link a word document that I saved in a directory (e.g. c://). When I
click on the link, I got a message said "cannot open the specified file."

I have done it in both ways:
1) in the cell, I click on "insert" "hyperlink"; select "link to - existing
file" and "select the file" that I want to link.
2) in the cell, I typed in the formula instea - =hyperlink(file:////file
location)

I still get the same error message using both approaches. Any suggestions?
 
G

Gary''s Student

Remember the double quotes:

=HYPERLINK("file:///c:\a.xls","The a file")
 

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

Excel Hyperlink 0
Hyperlink .tif files 2
View Hyperlink in another cell 1
Activating hyperlinks 3
Hyperlink Copy Error 6
Create Hyperlink only if file exists 4
hidden Hyperlink 1
Hyperlink to folder on Save 1

Top