Hyperlinks Blocked

[goldbam]

Hyperlinks have worked fine for as long as I have had Excel 2010. Now none work. I use them on two places within a sheet, from one sheet to another and from a sheet to the internet. The error message I receive is: "This operation has been canceled due to restrictions in effect on this computer. Please contact your system administrator."

How do I fix this?

 

[Jerry Sullivan]

Hi and Welcome to the Board,

For the link to the internet, try following that link outside of Excel to determine whether that is an Excel problem or something else.
Right-click on that link to copy its Address then paste it in your browser.

Is the link "from one sheet to another" within the same workbook or to a different workbook?
Please post that hyperlink's address here to see if that yields a clue.

 

[goldbam]

Hi and Welcome to the Board,

For the link to the internet, try following that link outside of Excel to determine whether that is an Excel problem or something else.
Right-click on that link to copy its Address then paste it in your browser.

Is the link "from one sheet to another" within the same workbook or to a different workbook?
Please post that hyperlink's address here to see if that yields a clue.

As I said in my first post, I have links within a sheet, from one sheet to another and to several websites. None will work any more but all did ever since I installed Excel 2010.
Thanks for helping.
Goldbam

 

[Jerry Sullivan]

Did you try pasting one of the website links directly into a browser?
Whether or not that works will narrow down the possible reasons that it isn't working from Excel.

Please post an example link from one sheet to another as it will help us diagnose the problem.

 

[goldbam]

Did you try pasting one of the website links directly into a browser? YES and it worked perfectly.
Whether or not that works will narrow down the possible reasons that it isn't working from Excel.

Please post an example link from one sheet to another as it will help us diagnose the problem.

I don't really understand what I am to do. When I examined a hyperlink designed to move from one tab to another, it showed the structure of all the tabs with the one I chose highlighted and the cell I designated as the end location was shown. I'm not sure what else you are looking for.

 

[Jerry Sullivan]

I was asking you to paste the actual link address, thinking that might have been corrupted or be invalid.

Doing a quick web search on that error message, it appears this is a somewhat common problem related to that way the default browser is set up. See if you are able to use on of the fixes in these linked articles.

Microsoft Outlook: Error “This operation has been canceled due to restrictions in effect on this computer. Please contact your system administrator.”

This operation has been cancelled due to restrictions - Slipstick Systems

This operation has been canceled due to restrictions in effect on this computer. Please contact your system administrator.

Note some of the articles are addressing problems reported in Outlook, however other threads report having the same problem in Outlook and Excel. So hopefully the same fix will address your Excel problem.

 

[goldbam]

Thank you so much. The third reference using Microsoft Fix it 50388 removed the problem. It did make Internet Explorer my default browser but all the hyperlink problems in Excel 2010, both internal to the spreadsheet and external to a browser URL are now working. I truly appreciate this help. I will attempt to return either to Firefox or Chrome as my default browser and reply only if I run into troubles.

 

[Jerry Sullivan]

Glad to here that. Thanks for following up on the result.

 

[abrqzpam]

Hi, MrExcel MVP..

I cannot open any program in my computer (windows XP), this msg always shows "Restrictions. This operation has been cancelled due to restrictions in effect on this computer.Please contact your system administrator.”.. Desktop icons, taskbar icons are gone, even programs in start menu doesn't work.. the control panel is gone, shutdown/restart/buttons, and even the Run doesn't work.. please help..

 

[abrqzpam]

Hi, MrExcel MVP..

I cannot open any program in my computer (windows XP), this msg always shows "Restrictions.This operation has been cancelled due to restrictions in effect on this computer.Please contact your system administrator.”.. Desktop icons, taskbar icons are gone, even programs in start menu doesn't work.. the control panel is gone, shutdown/restart/buttons, and even the Run doesn't work.. please help..