Hyperlink Not Working In Excel

If that is not the problem, you may want to turn off an option in Excel that causes the program to check hyperlinks whenever the workbook is saved. (There have been some reports that Excel disables the links a bit too early sometimes, which could be the behavior that Fanie is seeing.). Hyperlink not working in excel web access sharepoint 2010. Ask Question Asked 2 years. It does not works as a hyperlink in the Excel Web Access web part.

  1. Excel Spreadsheet Links Not Working
  2. Why Is My Hyperlink Not Working In Excel
  3. Excel Hyperlink Stopped Working
  4. Hyperlink Not Working In Word
-->

Original KB number: 310049

Symptoms

Assume that you set Internet Explorer as your default browser in Windows. When you select a hyperlink in Microsoft Outlook, you receive one of the following error messages, depending on your Outlook version:

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

Your organization's policies are preventing us from completing this action for you. For more info, please contact your help desk.

Resolution

To resolve this problem, follow these methods in order. Check whether the problem is resolved after each method.

Method 1: Reset Internet Explorer settings

Internet Explorer 11 and Internet Explorer 10

Warning

If you are using Windows 10, Windows 8.1 or Windows 8, proceed to method 2.

  1. Start Internet Explorer.

  2. Select Tools > Internet Options.

  3. Select Advanced > Reset.

  4. In the Reset Internet Explorer Settings window, select Delete personal settings > Reset.

  5. Select Close when it is completed.

  6. Close and restart Internet Explorer.

  7. Select Tools > Internet Options.

  8. Select Programs > Set programs.

  9. Select Set your default programs.

  10. In the Programs list, select Microsoft Outlook > Set this program as default.

  11. Scroll back up to the top of the default programs list and highlight Internet Explorer and select Set this program as default.

  12. Select OK, and close the Default Programs dialog box.

Internet Explorer 9

  1. Start Internet Explorer.

  2. Select Tools > Internet Options.

  3. Select Advanced > Reset.

  4. In the Reset Internet Explorer Settings window, select the Delete personal settings > Reset.

  5. Select Close when it is completed.

  6. Restart Internet Explorer.

  7. Select Tools > Internet Options.

  8. Select Programs > Set programs.

  9. Select Set your default programs.

  10. In the Programs list, select Microsoft Outlook > Set this program as default.

  11. Select OK, and then close the Default Programs dialog box.

  12. In the Internet Options dialog box, select the Programs tab, and then select Make default under Default web browser.

  13. Select OK.

Internet Explorer 8 and Internet Explorer 7

  1. Start Internet Explorer.
  2. On the Tools menu, select Internet Options.
  3. Select Advanced > Reset.
  4. Select Programs > Set programs.
  5. Select Set Default Programs.
  6. Select Microsoft Outlook > Set this program as default.
  7. Select OK, and then close the Default Programs dialog box.
  8. In the Internet Options dialog box, select the Programs tab, and then select Make default under Default web browser.
  9. Select OK.

Internet Explorer 6

  1. Start Internet Explorer.

  2. On the Tools menu, select Internet Options.

  3. Select Programs > Reset Web Settings.

  4. Under Internet programs, make sure that the correct email program is selected.

  5. Select the Internet Explorer should check to see whether it is the default browser check box.

  6. Select Apply > OK.

    Note

    You may receive the following message when Internet Explorer starts:
    Internet Explorer is not currently your default browser. Would you like to make it your default browser?

    If you receive this message, select Yes.

Method 2 - Export and import the registry key from another computer

This section is intended for advanced computer users. For help with advanced troubleshooting, ask your system administrator or contact Microsoft Support.

Hyperlink Not Working In Excel

Important

Follow the steps in this section carefully. Serious problems might occur if you modify the registry incorrectly. Before you modify it, back up the registry for restoration in case problems occur.

Note

Use this method only if the earlier instructions for each browser do not work to resolve this problem.

Step 1: Export the registry key from another computer

  1. On a computer that does not encounter this problem, select Start > Run.

  2. In the Open box, type regedit, and then select OK.

  3. Locate, and then select the registry subkey: HKEY_LOCAL_MACHINESoftwareClasseshtmlfileshellopencommand.

  4. On the File or Registry menu (depending on your operating system), select Export.

  5. Note the location where the file will be saved.

  6. Type a unique file name, and then select Save.

  7. Exit Registry Editor.

Step 2: Import the registry key

  1. Copy the exported registry key to the desktop on the problem computer.

  2. Double-click the .reg file.

    You may receive the following message:

    Windows 10, Windows 8.1, and Windows 8

    Adding information can unintentionally change or delete values and cause components to stop working correctly. If you do not trust the source of this information in C:Users<yourlogon>Desktopregkey.reg, do not add it to the registry.

    Windows 7

    Are you sure you want to add the information in drive: location file was copied tofile name.reg to the registry?

  3. Select Yes > OK.

Step 3: Verify that the String (Default) value of the HKEY_CLASSES_ROOT .html key is htmlfile

  1. Select Start > Run.

  2. In the Open box, type regedit, and then select OK.

  3. Locate, and then select the registry subkey: HKEY_CLASSES_ROOT .html.

  4. Make sure that the value of the String (Default) is 'htmlfile'. If it's not htmlfile, right-click (Default), select Modify, input htmlfile in the Value data box, and then select OK.

  5. Exit Registry Editor.

-->

Note

Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.

Symptoms

When you create a hyperlink in an Office document and then select the link, you may receive one of these error messages:

Unable to open <URL>. Cannot locate the Internet server or proxy server.

Unable to open <URL>. Cannot open the specified file.

<URL> = the hyperlink you inserted.

Note

The hyperlink does work if you type it directly in the browser, or in the Open box of the Run dialog box (select Start, and then select Run).

Cause

This problem occurs when the following conditions are true:

  • You are using Microsoft Internet Explorer:

    • As a proxy server -or-
    • With a firewall that doesn't allow HTTP requests to be placed on your local network

  • Internet Explorer isn't your default browser.

  • The ForceShellExecute registry key isn't present in the following location, or isn't set to 1:

    • For 32-bit versions of office installed on 64-bit operating systems:

      HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoftOffice9.0CommonInternet

    • For 32-bit versions of Office installed on 32-bit operating systems, or 64-bit versions of Office installed on 64-bit operating systems:

      HKEY_LOCAL_MACHINESoftwareMicrosoftOffice9.0CommonInternet

    Note

    The registry path doesn't depend on your Office version.

Workaround

Important

This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, select the following article number to view the article in the Microsoft Knowledge Base:

322756 How to back up and restore the registry in Windows

Add the Internet Subkey to the registry and set the Value data

To work around this issue, either add the ForceShellExecute subkey, if it is not present, and set the Value data, or if it is present, set the Value data of the ForceShellExecute subkey.

  1. Quit any programs that are running.

  2. Select Start, and then select Run. Type regedit in the Open box, and then select OK.

  3. In Registry Editor, browse to one of the following subkeys (create the keys if they do not exist):

    • For a 32-bit version of Office on a 64-bit version of Windows:

      HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoftOffice9.0CommonInternet

    • For a 32-bit version of Office on a 32-bit version of Windows:

      HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice9.0CommonInternet

    • For a 64-bit version of Office on a 64-bit version of Windows:

      HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice9.0CommonInternet

  4. Make sure the Internet subkey is selected. On the Edit menu, point to New, and then select DWORD Value. Add the following registry value:

    Value Name: ForceShellExecute

  5. Double-click ForceShellExecute, and then set the Value data to 1. Select OK.

  6. On the Registry menu, select Exit.

Did this fix the problem?

Check whether the problem is fixed. If the problem is fixed, you're finished with this section. If the problem isn't fixed, contact support.

More Information

A hyperlink may not go to a Microsoft Word document or a Microsoft Excel worksheet after you use this workaround.

Office uses the Urlmon.dll file to handle all Internet transitions.

In this case, the Urlmon.dll file sends a request to get a file via http:// through the proxy server. The proxy server sees that the request came from Internet Explorer, based upon the HTTP User Agent field of the http://request. It then gives an error 403, basically saying 'Access Denied.'

The Urlmon.dll file gets this and simply returns the error message mentioned earlier. The error means that the request failed, but it never states why it failed.

The workaround is to use a ShellExecute() on the URL. This allows the operating system to start the URL on the default browser. If the default browser isn't restricted by the proxy server, the proper page is displayed.