Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlink
Help - My hyperlinks no longer work. I have a large excel file (4 Mg) with
many hyperlinks to images that worked (opend the image). Now they don't - and say "cannot open file". I tried to insert a new link in the old file and it does not work. when I create a new excel file - it works. I am on a LAN - have mapped drive - and the images are in a subdirectory "images" right below the excel file I'm a type A - and it is really buging me!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlink
On 8 Feb, 14:10, RCB wrote:
Help - My hyperlinks no longer work. I have a large excel file (4 Mg) with many hyperlinks to images that worked (opend the image). Now they don't - and say "cannot open file". I tried to insert a new link in the old file and it does not work. when I create a new excel file - it works. I am on a LAN - have mapped drive - and the images are in a subdirectory "images" right below the excel file I'm a type A - and it is really buging me!!! Hello. Have you moved the spreadsheet and/or image folder recently? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlink
I think my helpless desk changed out network drives about 2 days ago - and
this is about when my trouble started - but I can find no diference in it's network name "RCB" wrote: Help - My hyperlinks no longer work. I have a large excel file (4 Mg) with many hyperlinks to images that worked (opend the image). Now they don't - and say "cannot open file". I tried to insert a new link in the old file and it does not work. when I create a new excel file - it works. I am on a LAN - have mapped drive - and the images are in a subdirectory "images" right below the excel file I'm a type A - and it is really buging me!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlink
If you look at the hyperlink via Insert|Hyperlink, does the hyperlink address
still point to the correct location? RCB wrote: I think my helpless desk changed out network drives about 2 days ago - and this is about when my trouble started - but I can find no diference in it's network name "RCB" wrote: Help - My hyperlinks no longer work. I have a large excel file (4 Mg) with many hyperlinks to images that worked (opend the image). Now they don't - and say "cannot open file". I tried to insert a new link in the old file and it does not work. when I create a new excel file - it works. I am on a LAN - have mapped drive - and the images are in a subdirectory "images" right below the excel file I'm a type A - and it is really buging me!!! -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlink
Dave and pa_broon74
thanks much it seems that while the LAN address has not changed - it has something to do with the "hyperlink base:" address on the "File / Properties" I think I can get it to work - if I knew how to set it to the directory the excel file is in - like: file:///\\FL-FS4\DS$\Defense\Services\FMS Forms\LBO all I really need is to set it to the the directory the main excel file - as the images file are in a subdirectory under it - and it seems that is there a guide to understand these "///" or "\\"?? and to answer the question - NO the link is not pointing to the correct directory anymore THANKS, bob "Dave Peterson" wrote: If you look at the hyperlink via Insert|Hyperlink, does the hyperlink address still point to the correct location? RCB wrote: I think my helpless desk changed out network drives about 2 days ago - and this is about when my trouble started - but I can find no diference in it's network name "RCB" wrote: Help - My hyperlinks no longer work. I have a large excel file (4 Mg) with many hyperlinks to images that worked (opend the image). Now they don't - and say "cannot open file". I tried to insert a new link in the old file and it does not work. when I create a new excel file - it works. I am on a LAN - have mapped drive - and the images are in a subdirectory "images" right below the excel file I'm a type A - and it is really buging me!!! -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlink
First, I've found the links to be very forgiving when using \ or / -- so much so
that I don't think it matters. (But I generally use the slash.) Second, you should be able to change the location in that insert|hyperlink dialog. If you have lots to do... Take a look at David McRitchie's site: http://www.mvps.org/dmcritchie/excel/buildtoc.htm look for: Fix Hyperlinks (#FixHyperlinks) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm ======= Personally, I have much better luck when I use the worksheet function: =hyperlink(). I can put the folder name in a cell (hidden???) and refer to it in my formula: =hyperlink("file:////" & $a$1 & B1, "Click me") if B1 contains the name of the file. Then when the folder gets moved/renamed, I can just change one cell--$a$1. RCB wrote: Dave and pa_broon74 thanks much it seems that while the LAN address has not changed - it has something to do with the "hyperlink base:" address on the "File / Properties" I think I can get it to work - if I knew how to set it to the directory the excel file is in - like: file:///\\FL-FS4\DS$\Defense\Services\FMS Forms\LBO all I really need is to set it to the the directory the main excel file - as the images file are in a subdirectory under it - and it seems that is there a guide to understand these "///" or "\\"?? and to answer the question - NO the link is not pointing to the correct directory anymore THANKS, bob "Dave Peterson" wrote: If you look at the hyperlink via Insert|Hyperlink, does the hyperlink address still point to the correct location? RCB wrote: I think my helpless desk changed out network drives about 2 days ago - and this is about when my trouble started - but I can find no diference in it's network name "RCB" wrote: Help - My hyperlinks no longer work. I have a large excel file (4 Mg) with many hyperlinks to images that worked (opend the image). Now they don't - and say "cannot open file". I tried to insert a new link in the old file and it does not work. when I create a new excel file - it works. I am on a LAN - have mapped drive - and the images are in a subdirectory "images" right below the excel file I'm a type A - and it is really buging me!!! -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlink
Dave and pa_broon74
Thanks so much this should do it - I am on the right track now The help file on hyperlinks seems to useless and and my google experience on the world wide waste was also time ill spent even if i have to redo the links - at least I can get new ones to work - they were not working before Ill check out the ref - maybe I can automate the fix it's great to know I'm on my way to getting it Done - so thanks again bob "Dave Peterson" wrote: First, I've found the links to be very forgiving when using \ or / -- so much so that I don't think it matters. (But I generally use the slash.) Second, you should be able to change the location in that insert|hyperlink dialog. If you have lots to do... Take a look at David McRitchie's site: http://www.mvps.org/dmcritchie/excel/buildtoc.htm look for: Fix Hyperlinks (#FixHyperlinks) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm ======= Personally, I have much better luck when I use the worksheet function: =hyperlink(). I can put the folder name in a cell (hidden???) and refer to it in my formula: =hyperlink("file:////" & $a$1 & B1, "Click me") if B1 contains the name of the file. Then when the folder gets moved/renamed, I can just change one cell--$a$1. RCB wrote: Dave and pa_broon74 thanks much it seems that while the LAN address has not changed - it has something to do with the "hyperlink base:" address on the "File / Properties" I think I can get it to work - if I knew how to set it to the directory the excel file is in - like: file:///\\FL-FS4\DS$\Defense\Services\FMS Forms\LBO all I really need is to set it to the the directory the main excel file - as the images file are in a subdirectory under it - and it seems that is there a guide to understand these "///" or "\\"?? and to answer the question - NO the link is not pointing to the correct directory anymore THANKS, bob "Dave Peterson" wrote: If you look at the hyperlink via Insert|Hyperlink, does the hyperlink address still point to the correct location? RCB wrote: I think my helpless desk changed out network drives about 2 days ago - and this is about when my trouble started - but I can find no diference in it's network name "RCB" wrote: Help - My hyperlinks no longer work. I have a large excel file (4 Mg) with many hyperlinks to images that worked (opend the image). Now they don't - and say "cannot open file". I tried to insert a new link in the old file and it does not work. when I create a new excel file - it works. I am on a LAN - have mapped drive - and the images are in a subdirectory "images" right below the excel file I'm a type A - and it is really buging me!!! -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"paste special" a hyperlink to another worksheet... | Excel Worksheet Functions | |||
sort excel spreadsheet with hyperlink | Excel Discussion (Misc queries) | |||
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 |