Security Warnings

There are lots of reasons you might see a Security Warning in the message bar when you open a workbook.
The two most common reasons are to tell you there are external links or there are macros.


Multiple Issues

When more than one security alerts needs to be displayed, then you will see the following prompt:

microsoft excel docs

External Links

This message appears when a workbook contains at least one external link.
Check your Excel Options > Advanced > General > Ask to update automatic links
Check your Trust Center > External Content > Prompt user on automatic update of Workbook Links

microsoft excel docs

File > Info Tab > Enable Content > Advanced Options

microsoft excel docs

Macros

This message appears when a workbook contains macros.
Check your Trust Center > Macro Settings > Disable all macros with notification

microsoft excel docs

File > Info Tab > Enable Content > Advanced Options

microsoft excel docs

Macros and ActiveX Controls

This message appears when a workbook contains macros AND ActiveX controls.

microsoft excel docs

Check your Trust Center > ActiveX Settings


microsoft excel docs

Data Connections


microsoft excel docs

Trust Center > External Content



Addins



Unsafe Locations


Trust Center > Protected View



WEBSERVICE Functions


microsoft excel docs



© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext