Hyperlink Not Working In Excel

-->

Hyperlinks are not working in Outlook. 9/22/2021; 3 minutes to read; h; M; s; Applies to: Outlook 2003, Outlook 2007, Outlook 2010, Outlook 2013, Outlook 2016, Outlook 2019, Outlook for Microsoft 365; In this article. Original KB number: 310049. Assume that you set Internet Explorer as your default browser in Windows. You would need to correct the hyperlink address to the updated file name so that the file becomes detectable. Follow the steps below to edit the address. Step 1: Copy the address of the new file from the file's explorer. Step 2: Head to Excel. Step 3: Right-click on the hyperlink, and click 'Edit hyperlink' in the menu.

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:

Not

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.

Hyperlink Not Working In Excel Spreadsheet

Method 1: Reset Internet Explorer settings

Internet Explorer 11 and Internet Explorer 10

Warning

Hyperlink Not Working In Excel

Hyperlink Not Working In Excel 2010

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

Hyperlink not working in word
  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.

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

2007
  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.

Fanie has a workbook with two worksheets. In the first worksheet she created hyperlinks to the second worksheet. Those hyperlinks worked fine until Fanie saved and reopened the workbook. The second time the hyperlinks were all gray and would no longer work, and she's at a loss as to why this occurred.

There are a few things you can try here. First, you need to make sure that the problem isn't due to something you inadvertently did in your workbook. Check to make sure that you didn't rename the second worksheet—the one that is the target of the hyperlinks. When you create hyperlinks, each of them references the name of the worksheet you specify as the target. If you later rename the worksheet, then the hyperlinks may not work as expected. If this is the case, you will need to either change the name of the worksheet back to its original name, or you will need to recreate the hyperlinks to point to the renamed worksheet.

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.) Do this by following these steps:

Hyperlink

Links Not Working In Excel 2016

  1. Display the Excel Options dialog box. (In Excel 2007 click the Office button and then click Excel Options. In Excel 2010 and Excel 2013 display the File tab of the ribbon and then click Options.)
  2. At the left side of the dialog box click Advanced.
  3. Scroll through the available options until you see the General section. (See Figure 1.)
  4. Figure 1. The Advanced options of the Excel Options dialog box.

  5. Click on the Web Options button. Excel displays the Web Options dialog box.
  6. Make sure the Files tab is selected. (See Figure 2.)
  7. Figure 2. The Files tab of the Web Options dialog box.

  8. Clear the Update Links on Save check box.
  9. Click on OK to close the Web Options dialog box.
  10. Click on OK to close the Excel Options dialog box.

Finally, the problem may not even be related to Excel it is possible that the program is getting a bit confused if you changed your default browser after you originally created the hyperlinks—especially if you deleted whatever browser used to be your default. If you think this may be the root of the problem, the only thing you can do is to recreate the hyperlinks.

Comments are closed.