This article explains how you can overcome the message “Automatic update of links had been disabled”, that appears when you open a workbook:
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:
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:
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:
On the window that opens choose the External Content tab, then click on Enable automatic update for all workbook links (not recommended) radio button:
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 www.software-solutions-online.com