I have a large Excel table with a lot of local file hyperlinks to PDF files. These links are clicked often, and every time a warning pops up:
Some files can contain viruses or otherwise be harmful to your computer. It is important to be certain that this file is from a trustworthy source.
Would you like to open this file?
This dialog is extremely annoying; is there a way to disable it?
What I've tried (none of it helped):
In Registry, add
DisableHyperlinkWarning REG_DWORD 0x00000001. I've tried it under following keys:
In Registry, enable trusted protocol via
HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\xx.0\Common\Security\Trusted Protocols\All Applications. No "Office" key exists under "Microsoft".
In Registry, go to
Computer\HKEY_CLASSES_ROOT\.pdf, and add key
EditFlags REG_DWORD 0x00010000
Windows Start button ➔ Internet Options ➔ Security ➔ Trusted Sites. It is impossible to add a
file://link to a local folder.
Excel ➔ Excel Options ➔ Trust Center ➔ Trusted Locations. Added folder under User Locations, restarted Excel, warning still pops up.
Excel version: "Microsoft Excel for Office 365 MSO (16.0.12527.21378) 64-bit"