Remember the double quotes:

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


--
Gary''s Student - gsnu200789


"HK2006" wrote:

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?