Can’t open a website link from Excel 2010

Topic

New Reply

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

Reply | Quote

Replies

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

Reply | Quote

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_MachineSoftwareClasseshtmlfileshellopencommand

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

Reply | Quote

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.

Reply | Quote