Hyperlink failed

W

WilMong

After inserted a Hyperlink to another excel worksheet file successfully,
error message "Cannot open the specified file" appeared while OPEN Hyperlink,
please help?
 
D

Daniel CHEN

You need to make sure that the path/file is correct.
--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
=================================
 
D

David McRitchie

If you still have a problem see some examples in
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
http://www.mvps.org/dmcritchie/excel/sheets.htm

There are object hyperlinks (Ctrl+K) which I think you are using since you
mentioned "insert" and there is the HYPERLINK Worksheet Function

If you still have a problem after checking those references, you would
have to post what you had, what it got changed to, specifically why
you know it doesn't work (the entire text of the message).

The message you refer to is at least similar to other messages such
as bad references in toolbar buttons, so also think if you moved any
files around (pathname problems like Yongiun mentionded)..
 
W

WilMong

Thanks Daniel & David on the guidance.
The error is on the file name. filename Job#123 with # symbol interpreted by
Hyperlink as Job-123 which error message appeared as "Cannot open the
specified file"...cheers

David McRitchie said:
If you still have a problem see some examples in
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
http://www.mvps.org/dmcritchie/excel/sheets.htm

There are object hyperlinks (Ctrl+K) which I think you are using since you
mentioned "insert" and there is the HYPERLINK Worksheet Function

If you still have a problem after checking those references, you would
have to post what you had, what it got changed to, specifically why
you know it doesn't work (the entire text of the message).

The message you refer to is at least similar to other messages such
as bad references in toolbar buttons, so also think if you moved any
files around (pathname problems like Yongiun mentionded)..

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Daniel CHEN said:
You need to make sure that the path/file is correct.
--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
=================================
Click to expand...
Click to expand...
 
Top