[Fix]: Excel Automatic Update of Links Has Been Disabled

This article shows how to turn off the security warning in excel saying automatic update of links has been disabled. It often occurs when a workbook contains external references to another workbook. Excel may also show the warning in case of any kind of linking of the workbook to any external source. Have a quick look through the article to see how to resolve the problem.

Fix: Excel Automatic Update of Links Has Been Disabled


Download Practice Workbook

You can download the practice workbook from the download button below.


What Is the ‘Excel Automatic Update of Links Has Been Disabled’ Issue?

Assume that you have a worksheet linked to another source workbook through a formula in cell B2. Excel will not show any security warning if the source workbook is open too.

  • But as soon as you close the source workbook, the formula in cell B2 changes instantly to show the path of the external reference as shown below.

  • Now close and reopen your workbook. Then excel will show the following security warning. This way excel wants to protect you from untrusted connections.

Excel Automatic Update of Links Has Been Disabled

  • You can click on the cross icon to remove the warning. But this will reappear every time you open the workbook.
  • Alternatively, you can click on Enable Content leading to the following warning instead whenever you reopen the workbook.


Step-by-Step Solution to ‘Excel Automatic Update of Links Has Been Disabled’ Issue

Now in this section, we will show how to solve this issue with quick steps.

Step-1: Go to the Advanced Tab of Excel Options

To fix this issue, press ALT+F+T to open Excel Options. Then go to the Advanced tab. Then uncheck Ask to update automatic links and hit the OK button.

Fix: Excel Automatic Update of Links Has Been Disabled

Read More: How to Update Hyperlink in Excel Automatically (2 Ways)


Step-2: Go to the Trust Center Tab

After that, if excel is still showing the warning then go to the Trust Center tab from the Excel Options window. And then click on Trust Center Settings.


Step-3: Go to External Content Tab

Now go to the External Content tab. Then uncheck the radio button to Enable automatic update for all Workbook Links (not recommended). You will find it in the section named Security Settings for Workbook Links. After that, click OK.

Fix: Excel Automatic Update of Links Has Been Disabled

  • Select OK one more time. The problem should be resolved by now.

Read More: Find External Links in Excel (6 Quick Methods)


Alternative Solution to ‘Excel Automatic Update of Links Has Been Disabled’ Issue

You can also disable the security alert using the Edit Links feature. Just follow the steps below.

📌 Steps:

  • First, select Data >> Edit Links as shown below.

  • Then click on Startup Prompt at the bottom-left corner in the Edit Links window.

  • After that, the Startup Prompt window will pop up. Select Don’t display the alert and update links and then click OK.

Fix: Excel Automatic Update of Links Has Been Disabled

  • You can open the external sources from here too. This will automatically remove the security alert.

  • You can break the links in your worksheet if you don’t need to update the data along with the source. Then select the particular link and click on Break Link as shown below.

  • Next, you will see the following error. Because breaking a link will convert the associated data to values only. After that, you won’t see the security alert anymore.

  • You may need to delete any defined range with external sources. Select Formulas >> Name Manager to see the defined names.

  • Now select the defined range and delete it if not needed.

Read More: [Fixed!] Break Links Not Working in Excel (7 Solutions)


Things to Remember

  • You may need to enable other security settings in Trust Center if required.
  • Data Validation, Conditional Formatting, PivotTable, and Power Query may also contain external links causing the security alert.

Conclusion

Now you know how to fix the security alert in excel showing automatic update of links has been disabled. Please let us know if this article has helped you to fix the issue. You can also use the comment section below for further queries or suggestions. Do visit our ExcelDemy blog to read more on excel. Stay with us and keep learning.


Related Articles

Md. Shamim Reza

Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo