Excel – This Operation has been canceled due to restrictions in effect on this computer, Please contact your administrator

excelwindows-7

I am getting the error message "This Operation has been canceled due to restrictions in effect on this computer, Please contact your administrator" in Excel 2010 (win 7) when try to open a hyperlink to a pdf file located on a shared network drive. The file path on the hyperlink is correct. Did anybody else have this same issue and find a solution to it? It seems all the issues online involve a hyperlink to a www.

Best Solution

Found a solution. I ran cmd as admin and then ran the following commands:

REG ADD HKEY_CURRENT_USER\Software\Classes.htm /ve /d htmlfile /f

REG ADD HKEY_CURRENT_USER\Software\Classes.html /ve /d htmlfile /f

REG ADD HKEY_CURRENT_USER\Software\Classes.shtml /ve /d htmlfile /f

REG ADD HKEY_CURRENT_USER\Software\Classes.xht /ve /d htmlfile /f

REG ADD HKEY_CURRENT_USER\Software\Classes.xhtml /ve /d htmlfile /f

Related Question