Enable Auto Hyperlink Excel

Posted on by admin

This Tutorial helps to How to Enable or Disable Automatic Hyperlinks in ExcelThanks friends for watching this video,Kindly Subscribe & Support Our Channel. The link has a typo; etc. The easiest way I know of to correct these problems is to open the main file (that is saying it cannot update links) In Excel 2007 you would click the Data tab and select Edit Links. This will bring up a list of all references to other workbooks. I have several sheets with columns that contain hyperlinks, and I do want the hyperlinks in there for others to be able to use (so just removing them all isn't an option), I just don't want Excel to open a browser or a linked file every time I click on a cell containing a hyperlink. If I want to follow the hyperlink in the cell, I am more than.

-->

Note

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

Introduction

This step-by-step article describes how to enable or to disable the display of a warning message every time that you click a hyperlink in a 2007 Microsoft Office program or in a Microsoft Office 2010 program.

More Information

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, see How to back up and restore the registry in Windows.

In 2007 Office and in Office 2010, when you click a hyperlink or an object that links to an executable file, you receive the following warning message:

This behavior occurs regardless of your security level settings.

Note

To locate your security level settings, point to Macro on the Tools menu, and then click Security.

Enable

Additionally, when you open either TIFF images or Microsoft Document Imaging (MDI) files, you receive the following warning message:

Enable Auto Hyperlink Excel

You receive this warning message even when you have already implemented the registry key that this article describes. This warning message comes from the HLINK.dll file when link navigation is handled. You can differentiate the 2007 Office or 2010 Office hyperlink warning message from the HLINK warning message by looking for quotation marks around the file path in the warning message. The 2007 Office or Office 2010 message contains quotation marks. The HLINK message does not contain quotation marks. 2007 Office and Office 2010 try to determine whether the file type itself is unsafe by checking the extension, the progid, the classid, and the MIME type of the document.

How to globally enable or disable hyperlink warnings

To have us enable hyperlink warnings for 2007 Office programs and for Office 2010 programs for you, go to the 'Here's an easy fix' section. If you prefer to enable the setting yourself, go to the 'Let me fix it myself' section.

Here's an easy fix

To fix this problem automatically, download and run 'Microsoft Easy Fix 20189',and then follow the steps in the easy fix wizard.

  • This wizard may be in English only. However, the automatic fix also works for other language versions of Windows.
  • If you're not on the computer that has the problem, save the easy fix solution to a flash drive or a CD, and then run it on the computer that has the problem.
Enable hyperlink warnings

Let me fix it myself

To enable or to disable the hyperlink warnings in 2007 Office programs and in Office 2010 programs when an https:// address, a notes:// address, or an ftp:// address is used, you must create a new registry subkey. To do this, follow these steps:

  1. Click Start, and then click Run.

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

    Note

    • You have to modify only one of these registry subkeys. You do not have to modify both.
    • If the Security subkey already exists, go directly to step 6 after you select the Security subkey.

  3. In Registry Editor, locate one of the following registry subkeys for 2007 Office: HKEY_CURRENT_USERSoftwareMicrosoftOffice12.0CommonOr, in Registry Editor, locate one of the following registry subkeys for Office 2010: HKEY_CURRENT_USERSoftwareMicrosoftOffice14.0Common

  4. Click the registry subkey, point to New on the Edit menu, and then click Key.

  5. Type Security, and then press Enter to name the key.

  6. On the Edit menu, point to New, and then click DWORD Value.

  7. Type DisableHyperlinkWarning, and then press Enter to name the entry.

  8. In the right pane, right-click DisableHyperlinkWarning, and then click Modify.

  9. In the Edit DWORD Value dialog box, click Decimal, and then type 1 or 0 under Value data.

    Note

    A value of 0 enables the hyperlink warning message. A value of 1 disables the hyperlink warning message.

  10. Click OK.

  11. Exit Registry Editor.

How to enable or disable hyperlink warnings per protocol

To disable the display of security warnings for a specific protocol, follow these steps:

  1. Click Start, click Run, type regedit, and then click OK.

  2. Locate the following registry subkey:

    HKEY_CURRENT_USERSoftwarePoliciesMicrosoftOfficexx.0CommonSecurityTrusted ProtocolsAll Applications

    Note In this subkey, replace 'xx.0' with 12.0 for Outlook 2007 and with 14.0 for Outlook 2010.

  3. Click the All Applications subkey.

  4. On the Edit menu, point to New, and then click Key.

  5. Type the name of the protocol that you want to exclude. For example, to disable the display of a security warning for the 'Notes:' protocol, type Notes:.

    Note Make sure that you include the colon (:) character.

  6. Press Enter.

  7. Exit Registry Editor.

If you still receive a warning message

After you disable warning messages, you may still receive a warning message from Microsoft Windows. If you continue to receive a warning message after you follow the steps in this article, use one of the following methods to resolve the issue.

Hyperlink

Note

Method 1 applies only to Windows XP and to earlier versions of Windows. For Windows Vista and for later versions of Windows, use method 2.

Method 1: Turn off the 'Confirm open after download' option for the file type that you are trying to open

  1. Double-click My Computer.
  2. On the Tools menu, click Folder Options.
  3. On the File Types tab, select the appropriate file name extension (for example, WMV) in the Registered File Types box, and then click Advanced.
  4. Click to clear the Confirm open after download check box, and then click OK.
  5. In the Folder Options dialog box, click Close.

Method 2: Modify the HKEY_CLASSES_ROOTCLSID>EditFlags registry subkey

Use this method if the warning message affects multiple computers.

To disable the warning message, follow these steps:

  1. Click Start, click Run, type regedit, and then click OK.

  2. Locate the following registry subkey:

    HKEY_CLASSES_ROOT<CLSID>EditFlags

    For example, if the file name extension is WMV, select HKEY_CLASSES_ROOTWMVFileEditFlags

  3. Click EditFlags, and then click Rename on the Edit menu.

  4. Type OldEditFlags, and then press ENTER.

  5. On the Edit menu, point to New, and then click DWORD value.

  6. Type EditFlags, and then press ENTER.

  7. On the Edit menu, click Modify.

  8. In the Edit DWORD Value dialog box, click Hexadecimal under Base.

  9. Type 10000, and then click OK.

To re-enable the warning message, follow these steps:

  1. Click Start, click Run, type regedit, and then click OK.

  2. Locate the following registry subkey:

    HKEY_CLASSES_ROOT<CLSID>EditFlags

  3. Click EditFlags, and then click Modify on the Edit menu.

  4. Type 0, and then click OK.

Note

Even after you follow these steps, you will receive the warning message if you open files in Office 2010 under Protected View.

Did this fix the problem?

Check whether the problem is fixed. If the problem is fixed, you are finished with this section. If the problem is not fixed, you can contact support.