Hyperlinks to Internet in Excel 2011 don't work

Discussion in 'Mac Basics and Help' started by margb, Apr 24, 2013.

  1. margb macrumors newbie

    Joined:
    Apr 24, 2013
    Location:
    Toronto, Ontario
    #1
    Hi - I'm preparing an Excel spreadsheet that has a detailed travel itinerary, and want to include hyperlinks to web pages of interest. There's no problem copying and pasting the full web address (via Command-C and Command-V) into the Hyperlink dialog, and the web address turns blue, is underlined, and looks fine - but when you click on it (before or after saving the workbook) you get this error message:

    "Unable to open http://thewebaddress. Cannot locate the Internet server or proxy server."

    Any suggestions as to what the problem might be?

    Thanks!
     
  2. RedCroissant Suspended

    Joined:
    Aug 13, 2011
    #2
    I think the problem is that you copied and pasted as opposed to using the Excel method of "inserting a hyperlink." That's the only thing that worked when I ran into this problem on my wife's iMac. If that doesn't work, make sure that excel allows incoming/outgoing internet connections. If either of those methods doesn't work, then I have no idea what else to advise you to do.
     
  3. margb thread starter macrumors newbie

    Joined:
    Apr 24, 2013
    Location:
    Toronto, Ontario
    #3
    Thank you

    Thanks for the suggestions, RedCroissant. I got one web address to work, once. That's progress!

    From what I can see, searching online, this is a continuing bug in Office software.

    Very much appreciate your response.
     
  4. RedCroissant Suspended

    Joined:
    Aug 13, 2011
    #4
    You're welcome, and for what it's worth, I highly recommend LibreOffice for productivity suite necessities over Office any day of the week. I use it on my G4 iBook and wouldn't even consider using MO at all. If you have time and the inclination, you should check it out. It's completely free of charge and works very well.
     
  5. tzgle macrumors newbie

    Joined:
    Oct 14, 2015
    #5
    The stupid workaround that I'm posting here in the hopes that it helps someone else is to use google's link obfuscation to your advantage:

    Search google for your link.
    Copy the google link to your desired page (this will start as "https://www.google.com/url?..." and contain a reference to your link) as the link in the HYPERLINK function.
    This google link should now automatically redirect to your desired page.
     

Share This Page