05-10-2021

Hyperlinks Not Working In Excel 2016

Use the Microsoft Fix it tool. Luckily for us, Microsoft guys are aware of the 'hyperlinks in. By Jay Stephens on 9th December, 2016. With your help I realized the Https address was getting an error, so I logged out of my account on the page I was trying to link which returned me to Http. In Excel, the link works with Http prefix, but not Https.

-->

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

Hyperlinks not working in excel 2016 pdf

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

Method 1: Reset Internet Explorer settings

Hyperlinks Not Working In Excel 2016

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.

Hyperlinks Not Working In Excel 2016

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.

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.

Link

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.

Dan has a shared workbook into which he needs to insert a hyperlink. However, as long as the workbook is shared, the hyperlink features in Excel are not available. Dan wonders if there is a way to insert hyperlinks into shared workbooks.

The short answer is no, there is not. When you choose to share a workbook, some options in Excel are simply not available any more; inserting hyperlinks is one of those options that is removed once the workbook is shared.

If you absolutely must add the hyperlink to the workbook, the only option is to unshare the workbook, add the hyperlink, and then again share the workbook. You'll no longer be able to add any more hyperlinks, but the one you added while the workbook was unshared will work just fine.

There is one caveat in taking this approach to adding the hyperlink—you need to be careful that you don't unshare the workbook if you have the Track Changes feature of Excel turned on. In the process of unsharing the workbook, Excel will turn off the tracking and discard the change history. If this is important to you, the only option is to make sure that you add the hyperlinks before sharing the workbook and first turning on Track Changes.