ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hyperlink Error (https://www.excelbanter.com/excel-discussion-misc-queries/189693-hyperlink-error.html)

HK2006

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?

Gary''s Student

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?


HK2006

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?


Gary''s Student

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