Microsoft Excel Security Warning: Automatic update of links has been disabled

Microsoft Excel has a feature called Link Sheet that you can use to link the data on your one workbook to another worksheet. These links automatically update when you change something on the linked workbook. But sometimes Excel may throw up an error banner, stating “Automatic update of links had been disabled“. This can also be an issue of denial of permission to external sources. You can easily make this problem go away in just a few steps.


ADVERTISEMENT

Workarounds –

1. Along with the error message, an additional option called “Enable Content” should appear.

Click “Enable Content” to proceed.

 

Enable Content Feature Min

 

Then, click “Continue” to update the data. Test if this solves the problem.

 

Continue Min

 

2. If there are any changes in the original resource (workbook or any other external links), you can go and check it first.

 

Fix 1 – Enable update links option

You just have to uncheck the update links option on the Excel page to override this message.

1. Open the Excel worksheet where you are seeing this banner.

2. Then, click on “File” and then, tap “Options“.

 

Options

 

3. This will open up the Excel Options page on your screen.

4. Here, head down to the “Advanced” pane.


ADVERTISEMENT

5. You can find many options here. So, navigate to find the When calculating this worksheets section.

6. Now, uncheck the “Update links to other documents” option.

7. Then, tap “OK” to save this change.

 

Update Links Uncheck Min

 

Now, it is recommended that you close and relaunch Excel.

Check if this removes the banner from Excel or not.

 

Fix 2 – Ask to update automatic links

You may choose not to update automatic links via Excel Options.

1. Open the spreadsheet, if it isn’t already opened.

2. Then, tap “File” and then, tap “Options“.

 

Options

 

The Excel Options page will open up.

4. Then, on the left-hand pane, tap Advanced” option.

5. Next, uncheck the “Ask to update automatic links” check box.

6. After this, click “OK” to save this modification.

 

Ask To Update Automatic Min

 

Now you should be back to the Excel worksheet. Check whether the banner is still there or not.

If it is still there, just save everything and close Excel. Then, relaunch it.

 

Fix 3 – Modify the External Content tab

You can take control of the external content like links on your excel worksheet.

1. On the Excel worksheet, tap “File” and click “Options” to open it.

 

Options

 

2. Then, click on the last option on the left-hand pane, “Trust Center“.

3. On the opposite side of the pane, tap “Trust Settings” to open it on your system.

 

Trust Center Settings Min

 

4. Next, head on to the “External Content” tab.

5. There, you will find the Security settings for Workbook Links tab.

Now, set this setting either to “Prompt user on automatic update for Workbook Links” or you can just disable it “Disable automatic update of Workbook Links” as well.

6. Then, tap “OK” to save the changes.

 

External Content Min

 

Now, coming back to the Options screen, tap “OK” to save it finally.

After this, you won’t see the banner again.

 

Fix 4 – Edit the links data

You can change the link settings in the data sheet so that it doesn’t throw up the error prompt.

1. Open the Excel sheet.

2. There, go to the “Data” settings on the menu bar.

3. There, click “Edit links” to open that settings.

 

Edit Links Min

 


ADVERTISEMENT


4. On the Edit Links prompt, tap “Startup Prompt…” to view the startup prompt.

 

Startup Prompt Min

 

5. Next, you have to set the When this workbook is opened, Excel can ask whether or not to update links to other workbook setting, you have to select the “Don’t display the alert and update links“.

6. Finally, tap “OK” to save this choice.


ADVERTISEMENT

 

Don't Display Ok Min

 

4. You can find all the links here. So, select the link and tap “Open Source” to open the link source on your system.

 

Open Soure Min

 

5. Next, select the link and tap “Break Link” to break the link to the original source.

 

Break Link Min

 

6. A warning message with the following message will appear –

Breaking links permanently converts formulae and external references to their existing values.

 

7. You can click “Break Links” to break the links.

 

Break Links Min

 

This way, you can break the links. There wouldn’t be any error messages or banners in Excel.

These fixes should have solved your problem for sure.

 

ADVERTISEMENT