| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink failed
After inserted a Hyperlink to another excel worksheet file successfully,
error message "Cannot open the specified file" appeared while OPEN Hyperlink, please help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hyperlink failed
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 ================================= "WilMong" wrote in message ... After inserted a Hyperlink to another excel worksheet file successfully, error message "Cannot open the specified file" appeared while OPEN Hyperlink, please help? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hyperlink failed
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" wrote in message ... 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 ================================= "WilMong" wrote in message ... After inserted a Hyperlink to another excel worksheet file successfully, error message "Cannot open the specified file" appeared while OPEN Hyperlink, please help? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hyperlink failed
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" wrote: 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" wrote in message ... 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 ================================= "WilMong" wrote in message ... After inserted a Hyperlink to another excel worksheet file successfully, error message "Cannot open the specified file" appeared while OPEN Hyperlink, please help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| answer to odd results when comparing hyperlink addresses | Links and Linking in Excel | |||
| Hyperlink won't open any other XLS file | Excel Discussion (Misc queries) | |||
| Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
| Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
| Removing hyperlink | Excel Discussion (Misc queries) | |||
Hybrid Mode
