Inserting Hyperlinks
I need to insert hyperlinks into excel aiming at movies on my HDD. (Don't
ask, its a favour for someone) Which works fine, until I save and re-open the excel file. It appears to be because excel shortens the path and therefore breaks the link. I have tried the Properties, Summary and Hyperlink base fix but find this doesn't work for me. The 'Cannot find specified file' error persists. I have also used =HYPERLINK function with no luck either. How can I stop exel shortening the path? Andrew |
Inserting Hyperlinks
Post an example of what you enter and what is is changed to.
This format: =HYPERLINK("file:///g:/temp/DSC_0002.JPG") may help. -- Gary''s Student - gsnu200773 "Andrew" wrote: I need to insert hyperlinks into excel aiming at movies on my HDD. (Don't ask, its a favour for someone) Which works fine, until I save and re-open the excel file. It appears to be because excel shortens the path and therefore breaks the link. I have tried the Properties, Summary and Hyperlink base fix but find this doesn't work for me. The 'Cannot find specified file' error persists. I have also used =HYPERLINK function with no luck either. How can I stop exel shortening the path? Andrew |
Inserting Hyperlinks
You may want to share the hyperlink that you tried and/or the actual formula you
used with the =hyperlink() worksheet function. For what it's worth, this works for me (with the drive, path, filename in A1): =hyperlink("file:////" & A1,"Click Me") Andrew wrote: I need to insert hyperlinks into excel aiming at movies on my HDD. (Don't ask, its a favour for someone) Which works fine, until I save and re-open the excel file. It appears to be because excel shortens the path and therefore breaks the link. I have tried the Properties, Summary and Hyperlink base fix but find this doesn't work for me. The 'Cannot find specified file' error persists. I have also used =HYPERLINK function with no luck either. How can I stop exel shortening the path? Andrew -- Dave Peterson |
Inserting Hyperlinks
=HYPERLINK("file:///c:/documents and settings/administrator/my
documents/movies/elephant.avi") Sorry, I now realise why it wouldn't work. I wasn't stating the file format at the end of the path name. Without .avi it wouldn't work, but with it, it works fine. Thank you for your help. It took your example to bring me to my senses. Andrew "Gary''s Student" wrote: Post an example of what you enter and what is is changed to. This format: =HYPERLINK("file:///g:/temp/DSC_0002.JPG") may help. -- Gary''s Student - gsnu200773 "Andrew" wrote: I need to insert hyperlinks into excel aiming at movies on my HDD. (Don't ask, its a favour for someone) Which works fine, until I save and re-open the excel file. It appears to be because excel shortens the path and therefore breaks the link. I have tried the Properties, Summary and Hyperlink base fix but find this doesn't work for me. The 'Cannot find specified file' error persists. I have also used =HYPERLINK function with no luck either. How can I stop exel shortening the path? Andrew |
All times are GMT +1. The time now is 02:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com