Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Dec 2009
    Location
    NSW
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can't open a website link from Excel 2010

    I have a Excel 2010 spreadsheet in which I have several links to exchange rate websites. By just clicking on these links I can quickly check the current rate of exchange for a particular currency which I then enter manually. These links usually open the site from Excel without trouble. Recently I've not been able to do this. I get an Excel message telling me, "This operation has been cancelled due to restrictions in effect on the computer. Please contact your system administrator."

    I'm not aware of any changes I may have made that would cause this, although I have very recently changed from Firefox to IE9, but I can't imagine that this would cause the problem.

    Can anyone offer any help?

    Thanks

  2. #2
    Bronze Lounger
    Join Date
    Mar 2002
    Location
    Newcastle, UK
    Posts
    1,525
    Thanks
    32
    Thanked 180 Times in 174 Posts
    Can you access the link directly i.e. outside of Excel, from this computer??
    If you have restricted internet access then you won't be able to do it through Excel until the restrictions are removed.

    zeddy

  3. #3
    Super Moderator
    Join Date
    Jun 2011
    Location
    New England
    Posts
    2,915
    Thanks
    91
    Thanked 356 Times in 320 Posts
    Although this Microsoft Fixit article refers to Outlook, it's about the same error message in similar circumstances, so I believe it may be equally applicable to Excel:

    When you click a hyperlink in Microsoft Outlook, you may receive the following error message:
    This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator.

    After you upgrade to a newer version of Microsoft Internet Explorer the following registry key may either missing or corrupted:
    HKEY_Local_Machine\Software\Classes\htmlfile\shell \open\command

    To have us fix this problem for you, go to the "Fix it for me" section. If you would rather fix this problem yourself, go to the "Let me fix it myself" section.

    http://support.microsoft.com/kb/310049

    Bruce

  4. #4
    Lounger
    Join Date
    Dec 2009
    Location
    NSW
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can't open a website link from Excel 2010

    Thanks for your responses. After posting I eventually came across the Microsoft page and the Fixit. I used it and the problem was fixed. Thanks for your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •