#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hyperlink error hdtiggrrr Excel Discussion (Misc queries) 0 March 10th 08 08:42 PM
hyperlink error hdtiggrrr Excel Worksheet Functions 0 March 7th 08 05:34 PM
Error using hyperlink tsosmoulis Excel Discussion (Misc queries) 1 June 7th 06 10:18 AM
error in hyperlink desparate Excel Discussion (Misc queries) 2 February 20th 06 02:08 AM
error in hyperlink desparate Excel Discussion (Misc queries) 0 February 17th 06 07:11 AM


All times are GMT +1. The time now is 10:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"