How to Fix If Excel Automatic Update of Links Has Been Disabled

 

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

If you have a worksheet linked to another source workbook through a formula in cell B2, Excel will not show a security warning if the source workbook is also open.

  • However, 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. Excel will then show the following security warning. This is 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 it 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.


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

Step 1: Go to the Advanced Tab of Excel Options

  • Press ALT+F+T to open Excel Options.
  • Go to the Advanced tab.
  • Uncheck Ask to update automatic links and press OK.

Fix: Excel Automatic Update of Links Has Been Disabled

Read More: How to Update Hyperlink in Excel Automatically


Step 2: Go to the Trust Center Tab

  • If Excel is still showing the warning, go to the Trust Center tab from the Excel Options window and click on Trust Center Settings.


Step 3: Go to the External Content Tab

  • Go to the External Content tab.
  • 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.
  • Click OK.

Fix: Excel Automatic Update of Links Has Been Disabled

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


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

Steps:

  • Select Data >> Edit Links, as shown below.

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

  • The Startup Prompt window will pop up.
  • Select Don’t display the alert and update links
  • Click OK.

Fix: Excel Automatic Update of Links Has Been Disabled

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

  • If you don’t need to update the data and source, you can break the links in your worksheet.
  • Select the particular link and click on Break Link, as shown below.

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

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

  • Select the defined range and delete it if not needed.


Things to Remember

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

Download the Practice Workbook

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


Related Articles

<< Go Back To Update Excel Links | Linking in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Shamim Reza
Md. Shamim Reza

Md. Shamim Reza, a marine engineer with expertise in Excel and a fervent interest in VBA programming, sees programming as a time-saving tool for data manipulation, file handling, and internet interaction. His diverse skill set encompasses Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He holds a B.Sc in Naval Architecture & Marine Engineering from BUET and has transitioned into a content developer role, generating technical content focused on Excel and VBA. Beyond his professional pursuits,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo