HYPERLINK WARNING MESSAGES IN EXCEL CANNOT BE ACTIVATED.

Question

I have a new laptop and new MS office. I use alot of hyperlinking in my excel files and I want a MS warning message whenever I click on a pasted link cell. But the software just bypasses the warning messgage and opens the link. I have tried all ways to enable the warning message but to no avail. Including editing the Register Editor and MS Office Trust Centre. I also have another laptop and a desktop and the same excel files work as I wanted (with proper MS warning messages whenever I click on any link). I even brought my laptop to the service centre and they were unable to activate the warning messages for me. My last resort is to ask Microsft to settle this. Please donot tell me to go trust centre or Register Editor as I have done all that. I conclude its the MS Office version I am using and it is brand new updated.

Answer 1

On newer Office versions, the hyperlink warning behavior is controlled differently than on the older installations where the prompts still appear. The available controls are:

1. Global registry switch for hyperlink warnings
   • Check that the global setting is not disabling the warning:
     • Open regedit.
     • Go to: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common\Security
     • Verify the DisableHyperlinkWarning value:
       • 0 = warnings enabled
       • 1 = warnings disabled
     • If the value exists and is 1, change it to 0.
2. Protocol‑specific trust configuration
   • If the protocols used in the hyperlinks (for example, https://) are configured as trusted, Excel will not show warnings.
   • Check:
     • HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\16.0\Common\Security\Trusted Protocols\All Applications
   • Under All Applications, each subkey name is a protocol (for example, https: or notes:). Any protocol listed here is treated as trusted and will not trigger warnings.
   • To restore warnings for a protocol, delete its key under All Applications.
3. HLINK/CLSID‑based warning behavior
   • If the standard Office hyperlink warning has been disabled but a separate Windows/HLINK warning is still desired, the EditFlags value for the file type’s CLSID can be used:
     • In regedit, go to HKEY_CLASSES_ROOT\<CLSID> for the file type (for example, HKEY_CLASSES_ROOT\WMVFile for .wmv).
     • Rename any existing EditFlags to OldEditFlags.
     • Create a new DWORD (32‑bit) value named EditFlags.
     • Set it to Hexadecimal 10000 to suppress the HLINK warning, or to 0 to re‑enable it.
   • This affects the Windows‑level warning, not the Office‑specific one, but if the new machine has different EditFlags values than the older devices, the behavior will differ.
4. Trust Center options (only for Office 2013/2010)
   • For Office 2013 and 2010, the setting Check Microsoft Office documents that are from or link to suspicious Web sites under File → Options → Trust Center → Trust Center Settings → Privacy Options controls alerts about suspicious links.
   • The documentation notes that this option is not available in versions of Microsoft Office newer than 2013, which explains why the same UI‑based control is missing or behaves differently on a newer Office build.

Given that:

• Older devices show warnings for the same files, and
• Newer Office versions remove or change some Trust Center controls,

the difference in behavior is expected between the old and new Office versions. On the new laptop, hyperlink warnings can only be influenced via the registry paths above. If DisableHyperlinkWarning is already 0 and no protocols are listed under Trusted Protocols\All Applications, the newer Office build will open standard http/https links without the legacy warning prompt, and this behavior cannot be reverted through supported settings beyond those registry keys.

---

References:

• Enable or disable hyperlink warning messages in Office applications
• Enable or disable security alerts about links and files from suspicious websites
• Block or unblock external content in Office documents