Questions

Problem hyperlinking in Excel

Tags:
+
0 Votes
Locked

Problem hyperlinking in Excel

dan.dempsey
I need to link to http://www.ibm.com/ibmlink/link2 from Excel. When I try to, I get the message "Unable to open http://www.ibm.com/ibmlink/link2. Cannot download the information you requested." Other links to the web, other workbooks, and other worksheets within the same workbook work fine.

Any ideas how to resolve? Thanks.
  • +
    0 Votes
    w2ktechman

    insert -- hyperlink ?

    +
    0 Votes

    Yes

    dan.dempsey

    There are several links throughout the workbook. Only this link does not work.

    +
    0 Votes
    w2ktechman

    that Excel would decide which links work or not.
    Is it a blocked domain?

    The link works here, so a few things to look at. First, in some programs recently I have noticed that links fail because, the program adds something to the link. Often an extra http:// or just extra // or changes from http to https. Sometimes just an extra space can cause it too
    check these first.

    Then, instead of inserting the hyperlink, try typing "click here", highlighting these words and then inserting a hyperlink.

    then, if they are correct

    +
    0 Votes
    dan.dempsey

    I neglected to tell you that the link works fine in IE. I just can't hyperlink to it from within Excel. Quite strange. Were you able to link to it from within Excel? If so, what version of Excel are you using? Your OS?

    +
    0 Votes
    w2ktechman

    so I was throwing out suggestions to try

    +
    0 Votes
    capris

    I use Excel 2003 and getting the same message with the link... however I noticed that when you open the link http://www.ibm.com/ibmlink/link2
    in IE, it redirects to an HTTPS web page... https://www-304.ibm.com/usrsrvc/account/userservices/jsp/login.jsp?persistPage=true

    If this is the right page you can do this... right click in the link in Excel go to Edit Hyperlink and change the address field to the web page to which its redirected... that works for me...

    +
    0 Votes
    dan.dempsey

    For some reason the site will say that I'm already logged in when I'm not. This is quite a bizarre problem. I have gone to other https sites from Excel with no problem. It might end up being an IBM issue. Thanks to everyone.

    +
    0 Votes
    andrew.brewster

    Looks like the first link is redirected to www-304.ibm.com and then again to the proper address when tried out in IE

    I wonder if Excel is able to cope with that redirection? The help in Excel says "Make sure the destination file is available The destination file for the hyperlink might have been deleted, moved, or renamed", whch kind of implies it can't cope with anything other than HTTP 200 status messages

    +
    0 Votes
    inblues

    Anyone can this solve? I'm facing same issue here.

  • +
    0 Votes
    w2ktechman

    insert -- hyperlink ?

    +
    0 Votes

    Yes

    dan.dempsey

    There are several links throughout the workbook. Only this link does not work.

    +
    0 Votes
    w2ktechman

    that Excel would decide which links work or not.
    Is it a blocked domain?

    The link works here, so a few things to look at. First, in some programs recently I have noticed that links fail because, the program adds something to the link. Often an extra http:// or just extra // or changes from http to https. Sometimes just an extra space can cause it too
    check these first.

    Then, instead of inserting the hyperlink, try typing "click here", highlighting these words and then inserting a hyperlink.

    then, if they are correct

    +
    0 Votes
    dan.dempsey

    I neglected to tell you that the link works fine in IE. I just can't hyperlink to it from within Excel. Quite strange. Were you able to link to it from within Excel? If so, what version of Excel are you using? Your OS?

    +
    0 Votes
    w2ktechman

    so I was throwing out suggestions to try

    +
    0 Votes
    capris

    I use Excel 2003 and getting the same message with the link... however I noticed that when you open the link http://www.ibm.com/ibmlink/link2
    in IE, it redirects to an HTTPS web page... https://www-304.ibm.com/usrsrvc/account/userservices/jsp/login.jsp?persistPage=true

    If this is the right page you can do this... right click in the link in Excel go to Edit Hyperlink and change the address field to the web page to which its redirected... that works for me...

    +
    0 Votes
    dan.dempsey

    For some reason the site will say that I'm already logged in when I'm not. This is quite a bizarre problem. I have gone to other https sites from Excel with no problem. It might end up being an IBM issue. Thanks to everyone.

    +
    0 Votes
    andrew.brewster

    Looks like the first link is redirected to www-304.ibm.com and then again to the proper address when tried out in IE

    I wonder if Excel is able to cope with that redirection? The help in Excel says "Make sure the destination file is available The destination file for the hyperlink might have been deleted, moved, or renamed", whch kind of implies it can't cope with anything other than HTTP 200 status messages

    +
    0 Votes
    inblues

    Anyone can this solve? I'm facing same issue here.