Troubleshooting for “Excel Hyperlinks not working” doesn’t involve much time but there is a possibility that what you get is not as expected, meaning the hyperlinks are not repaired. Stellar Repair for Excel lets you perform Hyperlink repair, scan and save the result in all new Excel file, without interfering with worksheet properties. The HYPERLINK function creates a shortcut that jumps to another location in the current workbook, or opens a document stored on a network server, an intranet, or the Internet. When you click a cell that contains a HYPERLINK function, Excel jumps to the location listed, or opens the document you specified. Hi, It turns out that when opening or creating links in iWork on a Mac, the spaces in any hyperlink are converted to%20. I found that opening an excel document with an index sheet for all the other sheets that was created on a Windows platform would be broken when opened on a Mac as all the spaces in names in hyperlinks would be changed and therefor broken. After a recent Word 2016 for MAC update, my new hyperlinks are not carrying through into PDF. The old links work as well as always; the new links are underlined, blue, but do not go anywhere. My latest update is 180410. I have the latest version of Acrobat Reader. Last edited by bchilds6@aim.com; at 05:30 AM. I am having the same issue. I downgraded from Acrobat DC to Acrobat XI and now have the issue that links are not included in my PDF. Have tried all of the above, used the toolbar, made the setting, went through all compliance: I got it to work for regular text hyperlinks, but if I attach hyperlinks to an image in excel, NADA.
-->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 Microsoft Office 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 Microsoft Office applications, 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.
Additionally, when you open either TIFF images or Microsoft Document Imaging (MDI) files, you receive the following warning message:
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 Microsoft Office hyperlink warning message from the HLINK warning message by looking for quotation marks around the file path in the warning message. The Microsoft Office message contains quotation marks. The HLINK message does not contain quotation marks. Microsoft Office tries 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 enable or to disable the hyperlink warnings in Microsoft Office 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:
Click Start, and then click Run.
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.
Locate and then select the following registry subkey (if the subkey does not exist, create it manually):HKEY_CURRENT_USERSoftwareMicrosoftOfficexx.0Common
Note In this subkey, replace 'xx.0' with 12.0 for Office 2007, 14.0 for Office 2010, 15.0 for Office 2013, and 16.0 for Office 2016 and later.
Click the registry subkey, point to New on the Edit menu, and then click Key.
Type Security, and then press Enter to name the key.
On the Edit menu, point to New, and then click DWORD Value.
Type DisableHyperlinkWarning, and then press Enter to name the entry.
In the right pane, right-click DisableHyperlinkWarning, and then click Modify.
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.
Click OK.
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:
Click Start, click Run, type regedit, and then click OK.
Locate the following registry subkey:
HKEY_CURRENT_USERSoftwarePoliciesMicrosoftOfficexx.0CommonSecurityTrusted ProtocolsAll Applications
Note In this subkey, replace 'xx.0' with 12.0 for Office 2007, 14.0 for Office 2010, 15.0 for Office 2013, and 16.0 for Office 2016 and later.
Click the All Applications subkey.
On the Edit menu, point to New, and then click Key.
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.
Press Enter.
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.
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
- Double-click My Computer.
- On the Tools menu, click Folder Options.
- On the File Types tab, select the appropriate file name extension (for example, WMV) in the Registered File Types box, and then click Advanced.
- Click to clear the Confirm open after download check box, and then click OK.
- In the Folder Options dialog box, click Close.
Method 2: Modify the HKEY_CLASSES_ROOT<CLSID>EditFlags registry subkey
Use this method if the warning message affects multiple computers.
To disable the warning message, follow these steps:
Why Are My Excel Hyperlinks Not Working
Click Start, click Run, type regedit, and then click OK.
Locate the following registry subkey:
HKEY_CLASSES_ROOT<CLSID>EditFlags
For example, if the file name extension is WMV, select HKEY_CLASSES_ROOTWMVFileEditFlags
Click EditFlags, and then click Rename on the Edit menu.
Type OldEditFlags, and then press ENTER.
On the Edit menu, point to New, and then click DWORD value.
Type EditFlags, and then press ENTER.
On the Edit menu, click Modify.
In the Edit DWORD Value dialog box, click Hexadecimal under Base.
Type 10000, and then click OK.
Excel Links Stopped Working
To re-enable the warning message, follow these steps:
Click Start, click Run, type regedit, and then click OK.
Locate the following registry subkey:
HKEY_CLASSES_ROOT<CLSID>EditFlags
Click EditFlags, and then click Modify on the Edit menu.
Type 0, and then click OK.
Note
Even after you follow these steps, you will receive the warning message if you open files under Protected View.
Did this fix the problem?
Excel 2016 Hyperlinks Not Working
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.