![]() |
Hyperlink Error
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? |
Hyperlink Error
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? |
Hyperlink Error
I still couldn't get it to work.
"Gary''s Student" wrote: 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? |
Hyperlink Error
Post EXACTLY what you tried.
-- Gary''s Student - gsnu200789 "HK2006" wrote: I still couldn't get it to work. "Gary''s Student" wrote: 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? |
All times are GMT +1. The time now is 03:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com