Security Warning: Automatic Update of Links Has Been Disabled

This article explains how you can overcome the message “Automatic update of links had been disabled”, that appears when you open a workbook:

Excel Links, Security Warning


Why Does it Appear?

This warning appears in excel workbooks that have external links. Basically this warning notifies the user that the workbook will be getting data from an external source. In order to allow the workbook to connect to the external source you will need to grant it permission. For more information about external links, please see the article below:

Granting Permission To a File:

In this method, the links will be granted permission for this file only. This message will still appear for other files. After opening the file click on the “Enable Content” button:

Links Security, Enable Content

Grant Permission to All Files (Not Recommended):

In this method you will grant permission for all files to connect to an external source without warning. Click on the file button on the top left side of the windows then click on options:

Excel Options
Note: If you are using excel 2007, click on the Excel logo on the top left then click on Options.

Choose the Trust Center tab, then click on the “Trust Center Settings” button:

Excel Trust Center
On the window that opens choose the External Content tab, then click on Enable automatic update for all workbook links (not recommended) radio button:

Enable All Links
See also:

If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website

2 thoughts on “Security Warning: Automatic Update of Links Has Been Disabled”

Leave a Reply

Your email address will not be published. Required fields are marked *