Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink Help
I have used the Insert Hyperlink feature to create hyperlinks back to various
word documents from Excel. The hyperlinks seem to work great when I create them and even for a couple days after that. Then when I use them again I get the following error message 'Can not find the specified file' I can recreate the link but the same thing happens it works great for a couple days and then stops working. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink Help
The best way to protect hyperlinks is to use the:
=HYPERLINK() function. -- Gary''s Student - gsnu200749 "Erika" wrote: I have used the Insert Hyperlink feature to create hyperlinks back to various word documents from Excel. The hyperlinks seem to work great when I create them and even for a couple days after that. Then when I use them again I get the following error message 'Can not find the specified file' I can recreate the link but the same thing happens it works great for a couple days and then stops working. Any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink Help
I did try that method however I end up with the same results.
"Gary''s Student" wrote: The best way to protect hyperlinks is to use the: =HYPERLINK() function. -- Gary''s Student - gsnu200749 "Erika" wrote: I have used the Insert Hyperlink feature to create hyperlinks back to various word documents from Excel. The hyperlinks seem to work great when I create them and even for a couple days after that. Then when I use them again I get the following error message 'Can not find the specified file' I can recreate the link but the same thing happens it works great for a couple days and then stops working. Any ideas? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink Help
=HYPERLINK("file:///C:\Documents and
Settings\User\Desktop\Book2.xls#Sheet2!B9") Try this form. I have never found it to fail. -- Gary''s Student - gsnu200749 "Erika" wrote: I did try that method however I end up with the same results. "Gary''s Student" wrote: The best way to protect hyperlinks is to use the: =HYPERLINK() function. -- Gary''s Student - gsnu200749 "Erika" wrote: I have used the Insert Hyperlink feature to create hyperlinks back to various word documents from Excel. The hyperlinks seem to work great when I create them and even for a couple days after that. Then when I use them again I get the following error message 'Can not find the specified file' I can recreate the link but the same thing happens it works great for a couple days and then stops working. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Hyperlink from one sheet to the hyperlink on another | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) |