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

In this article, I’ll show you three excellent methods on how to fix Excel automatic update of links has Been disabled in Excel. Furthermore, these strategies will allow you to solve the problem that brought you here. However, you will learn some important Excel features and functions in this post that will come in handy for any Excel job.


📁 Download Excel File

Download your free worksheet from here.


Automatic Update of Links Has Been Disabled Issue in Excel

If you open a worksheet and see the warning “Automatic update of links had been disabled,” this article will show you how to disable the feature. Excel files with hyperlinks to outside sources display this warning. It will alert the user when the worksheet will retrieve that data itself. You must provide the workbook access to the external source before it can make the connection.

Let’s presume that cell D6 to D9 of your worksheet has a formula that, when executed, opens another workbook. Opening the original workbook in Excel won’t cause a Security Alert to appear.

Dataset for excel automatic update of links has been disabled

Once the source workbook is closed, however, the formula in cells D6 to D9  immediately updates to reflect the external reference’s new location, as illustrated below:

Get out of your worksheet and then return to the worksheet. Once that happens, the following security alert will appear in Excel. Excel intends to shield you from potentially dangerous connections by doing so.

excel automatic update of links has been disabled

To dismiss the alert, simply click the “cross icon” button. However, when accessing the spreadsheet, this will continue to be the case. In exchange for this warning, you can always select Enable Content to bypass it the next time you access the workbook.

Please read the article below for further information regarding external links.


Learn to Enable Automatic Update of Links in Excel with These 2 Ways

Below you’ll find a total of 3 simple ways to quickly and easily fix how to disable Excel’s automatic update of links.

method

1. Using Advance Tab Option

Firstly we will try to solve this problem using the Advance tab option. The technique is described step by step for lessening your difficulties.

⬇️⬇️ STEPS ⬇️⬇️

  • Go to the Advance option from the file tab. You can do this by clicking the keyboard shortcut:

ALT+F+T

  • Then uncheck the option “Ask to update automatic links” from the general tab. Later click OK.

Selecting Advance tab for Fixing excel automatic update of links has been disabled

  • Then go to the tab “Trust Center” and select “Trust Center Settings”.

Selecting Trust Centre for fixing excel automatic update of links has been disabled

  • Following that go to the “External Content” tab and unselect the “Enable automatic update for all Workbook Links (not recommended)” option from the “Security Settings for Workbook Links” lists. Then check the option OK.
  • Again click on OK.

fixing Trust Center setting

  • You can access the links to external sources. The actions will disable security warnings.

By using this technique, you can disable the automatic update of the link.

method

2. Using Edit Links Option

And now we will use the Edit link feature to solve our task. The approach is explained one by one below.

⬇️⬇️ STEPS ⬇️⬇️

  • First, go to the Data tab.
  • Secondly, select the Edit Links
  • Following that, select the “Startup Prompt” option as shown.
  • Later select the option “Don’t display the alert and update links” and select the option OK.

Data Tab preview

  • You can access the links to external sources. The actions will disable security warnings.
  • If you don’t need to keep your worksheet up-to-date with the source, you can select Break Line. Then, choose the link in question and follow the steps under “Break Link” to severe it.

Selecting Break Link

  • The following mistake will then appear on your screen.
    Since disabling a connection reduces all linked information to numeric values. As of that point forward, the screen will no longer display a security warning.

  • You may need to delete any defined range with external sources
  • Select “Name Manager” from the “Formulas tab”. So that you can check the defined data.

Selecting Formula tab

  • Select the specified range now, and if necessary, delete it.

Picking range for fixing excel automatic update of links has been disabled

Thus you can disable the automatic update of the link.

📕 Read More: 5 Handy Ways to Convert Text to Hyperlink in Excel


📄 Important Notes

🖊️  Verify that you’ve employed Absolute Reference when the situation requires. To get an absolute cell reference, press F4.

🖊️  Always look for ways that are easy to use in different situations.

🖊️  Every time you try to use shortcuts on the keyboard.


📝 Takeaways from This Article

📌  You will be able to solve the issue of disabling the automatic updates of links using the Advanced Tab option.

📌  Moreover, You will be able to solve the issue of disabling the automatic update of links using the Edit Link Option option.


Conclusion

First and foremost, I hope you were able to apply the principles I taught in this Excel lesson. We will learn how to fix Excel automatic update of links has Been disabled in Excel. As you can see, there are numerous ways to accomplish this. However, choose the strategy that will suit best in your situation. Most essential, if you become confused in any of the processes, I recommend repeating them. After reviewing the Excel file in the practice workbook that I’ve shared above, practice on your own since practice makes perfect. Above all, I sincerely hope you can put it to good use. Please share your thoughts in the comments section about how you felt throughout the article and what we should change or add to make things better for you. However, if you have any Excel-related issues, please leave them in the comments section. The Excelden team is available to answer your inquiries at any time. Finally, keep reading to educate yourself. Please visit our website ExcelDen.com for further Excel-related articles.


Related Articles

(Visited 40 times, 1 visits today)
Md Shamse Tabrej

Md Shamse Tabrej

Hi, I'm Shamse Tabrej. I'm an admirer of Excel who enjoys sharing and solving problems in Excel. I make an effort to investigate all of the choices so that I may point readers toward the most viable solutions. Both the globe and its problems are boundless. Let's assist one another in developing. Reader questions and suggestions are most welcome. 

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo