[Fixed] This Operation Has Been Cancelled Due To Restrictions… Excel Error

Does your Excel is frequently showing “This operation has been cancelled due to restrictions in effect on this computer” error?

Mainly this is happening when you are making tap on the hyperlink within the Excel program for opening up the link in your browser.

If you are the primary administrators of your system then you must be thinking why I am getting this specific error. As in that case there is no reason for the restriction of hyperlinks opening inside the Microsoft programs on any of the PC.

Don’t take too much stress even if can’t fixed it off.  As in my today’s post I am going to reveal the main reason behind getting this operation has been cancelled due to restrictions Excel error.

Besides that I will also share some best fixes to resolve “operation has been cancelled due to restrictions in effect on this computer” error.

So let’s get started with the short intro about this error!

What’s The Issue?

“This operation has been cancelled due to restrictions in effect on this computer” Outlook, Word or Excel error usually encountered when the user tries to open the HTML link present in that specific program.

Here is the complete error message declaration:

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

This operation has been cancelled due to restrictions in effect on this computer

After doing lots more research about the main reasons behind the occurrence of this error following points are outlined:

  • Due to the setting of default Internet browser in your system
  • When the file handlers and it’s associate components are not perfectly registered
  • Some file may get corrupted inside Windows Registry.

How To Fix This Operation Has Been Cancelled Due To Restrictions In Effect On This Computer Error?

1# Reset Internet Explorer’s settings

2# Import The Fresh Registration(.reg) Files Through Different PC

3# Download The Microsoft Fix It

4# Switch To Another Office Program

5# Change HTML Association In Registry

Trick 1# Reset Internet Explorer’s settings

The very first solution that you must try to fix operation has been cancelled due to restrictions in effect on this computer error is by resetting the Internet Explorer’s settings. Follow down the steps to do this:

  • Press Windows + R key altogether. In the opened Run window type inetcpl.cpl and then tap to the OK button.

Reset Internet Explorer settings

  • Now on your screen internet properties window will get open up. In which you need to switch to advanced tab.
  • Within the advanced tab go to the reset internet explorer settings and hit the Reset…

Reset Internet Explorer settings 1

  • Now in the opened window of reset internet explorer settings select the option Delete personal settings and tap to the Reset button.

Reset Internet Explorer settings 2

  • Hit the close option.
  • Again press the window + R key and when the run window gets opened just type the inetcpl.cpl and hit the OK button.
  • Now in the opened window of internet properties switch to the Programs tab.
  • Go to the internet program section and hit the set programs tab.

Reset Internet Explorer settings 3

  • You need to hit the Set your default programs option.
  • From the programs list choose Microsoft Excel and tap to Set this program as default.
  • Move in the upward direction and make tap over the internet explorer and hit the Set this program as default option. At last hit the OK button.
  • Just close the Internet Explorer window to check whether the problem is fixed or not.

Trick 2# Import The Fresh Registration(.reg) Files Through Different PC

Disclaimer:

Before trying up this solution, make a system restore point. If something wrong happens in future then at least you have the option to restore.

So follow down the steps to create restore point.

  • Open some other PC in which you are not getting this operation has been cancelled due to restrictions in effect on this computer excel error.
  • Now on that PC press the “Windows R” This will open the Run window.
  • In that window type “regedit” text and hit the enter.
  • In the left pane section, search for the below given directory:

HKEY_Local_Machine\Software\Classes\htmlfile\shell\open\

  • With the open option there is a Command subkey.
  • Hit the File/Registry option present on the toolbar top.
  • Make a tap over the Export option.
  • Save your .reg file (registration file) by assigning some suitable name.
  • Now copy this.reg file on some secondary storage device like USB flash drive. After that paste it on your affected PC.
  • Make a double-click on the registration (.reg) file once it get copied on the affected PC for merging it with PC’s registry. After that apply the changes by tapping to the yes option.

Trick 3# Download The Microsoft Fix It

If you are not a pro in PC especially of the registry section then it is highly recommended to download the Microsoft Fix It.

This fix by Microsoft is specifically designed to resolve operation has been cancelled due to restrictions in effect on this computer Excel error. So, that it is highly suggested to download the Microsoft Fix It which is a utility designed by the Microsoft for fixing up this issue.

Click here to download the most suited version of Microsoft Fix It as per the Windows OS you are been using.

Trick 4# Switch To Another Office Program

As the problem is mainly with the Office program so it’s better to switch to some other alternatives which work without any issue.

Outlook users can you Thunderbird; whereas, Office Applications user; can make use of Apache Open Office.

These suggested software alternatives are completely free of cost and has almost every feature which is present in MS Office programs. There is no such compatibility issue so you can easily work with the files that were created in Office apps.

Trick 5# Change HTML Association In Registry

  • Open the Registry Editor and perform the following task:
  • Press the “Windows” + “R” keys together. This will open the RUN window.
  • In the run window box you have to type:  regedit
  • Hit the Enter tab.
  • In the left pane, you have to hit the “+” sign and then search for this subkey:

HKEY_CURRENT_USER\Software\Classes\.html

  • Make a double-clicking the (Default) String which is present in the right pane section and set its value data as htmlfile.
  • Execute the same task and assign Default string Value as htmlfile :
    • HKEY_CURRENT_USER\Software\Classes\.htm
    • HKEY_CURRENT_USER\Software\Classes\.shtml
    • HKEY_CURRENT_USER\Software\Classes\.xhtml
    • HKEY_CURRENT_USER\Software\Classes\.xht

Change HTML association in registry

  • Shut down the Registry editor and then restart the PC.
  • Try opening the hyperlinks.

Wrap Up:

Do try the given fixes of this tutorial to get rid of this annoying error message:

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

As all the listed fixes are well tried and tested one. But before making any changes in the registry option don’t forget to make backup of all your Excel data.

Besides this if you are facing Excel file corruption issue then try our expert’s recommended solution i.e Excel repair tool. As it is the most proficient tool to resolve any kind of Excel corruption errors and issue. Not only this, the tool is also very efficient one to restore images, formulas, charts, tables, chart sheets, sorts, filters, cell comments.

That’s all….good luck with the fixes.



Margret Arthur is an entrepreneur & content marketing expert. She writes tech blogs and expertise on MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in easy to understand language is very impressive. When not writing, she loves unplanned travels.