How to turn off Update Link notification in Excel - File content from many different sources

How to turn off Update Link notification in Excel
Instructions on how to fix 'This workbook contains links to one or more external sources that could be unsafe' error in Excel

A rather annoying phenomenon for Excel workers when having to process spreadsheets taken from many other data sources is the message Update link with the content The workbook contains one or more links that cannot be updated. This message will continuously display even when you turn it off, and requires users to update the complete link, even if the reference spreadsheet is no longer available.

Turning on or off the Update link notification on Excel will affect the content, possibly causing Excel to hang and lag, making it impossible to continue importing content. So how to turn off the Update link notification panel in Excel?

Instructions for turning off Update Link table in Excel

Step 1:

The Update link notification panel will look like the image below. Then we will click on the Update button to continue.

How to turn off Update Link notification in Excel - File content from many different sources Picture 1

Step 2:

Display the table as shown. There are 2 options here: Continue and Edit Links. If we click Continue, we will continue to enter content for the table as usual, but the message will still appear. So click on Edit Links .

How to turn off Update Link notification in Excel - File content from many different sources Picture 2

Additionally, if you accidentally turn off this interface, you can reopen it by clicking the Data tab on the interface and then selecting Edit Links to continue.

How to turn off Update Link notification in Excel - File content from many different sources Picture 3

Step 3:

A new dialog box appears with linked links in Excel. Click on the links that are no longer linked in the content and then click the Break Link button next to it to remove these links.

How to turn off Update Link notification in Excel - File content from many different sources Picture 4

When Excel asks again if you are sure you want to cancel these links, click on Break Links to agree.

How to turn off Update Link notification in Excel - File content from many different sources Picture 5

Step 4:

Continue to click the Startup Prompt button also in the Edit Link interface.

How to turn off Update Link notification in Excel - File content from many different sources Picture 6

Next, display the new interface and click on Don't display the alert and don't update automatic links to not display the Update link message again when processing the Excel document later.

How to turn off Update Link notification in Excel - File content from many different sources Picture 7

So you have completely turned off the Update link notification when working with Excel files linked to many other sources and spreadsheets. This message will display continuously even if the linked spreadsheet no longer exists. Please cancel the link and turn off link update notifications in Excel.

Wishing you success!

Isabella Humphrey

Update 11 August 2024

You should read it

May be interested

How to remove Windows 7 upgrade notice from Microsoft
you can continue to use windows 7, if you want to, but at the same time face lots of potential security risks.
How to create Hyperlink to link in Excel
how to create hyperlink to link in excel. you can create links from excel files to another excel file, a sheet is right there in the excel file, you can even create links to a website on the internet, or to an email address.
How to create Hyperlink to link spreadsheets in Excel
when creating hyperlink on excel, we can link data tables together or access a new spreadsheet file quickly.
How to insert a Word document into an Excel file
to be able to open word text files right in excel file, we can use the built-in feature to allow inserting data right on excel.
How to turn off the message to restart the Windows 10 computer after the update
after updating the windows 10 system, the computer will automatically show a reboot of the computer system, making users very uncomfortable. so how to turn off the message to restart the computer?
How to turn off auto formatting in Excel
when you enter some content in excel, it will be automatically formatted. this will sometimes affect the input content.
Tips for turning off suggestions in Excel, disabling the prediction feature in Excel simply
the content suggestion feature in excel helps quickly enter similar content into the spreadsheet. however, sometimes this feature can be inconvenient. in this article, we will show you how to turn off suggestions in excel.
How to turn off the notification center on Windows 10?
notification center (notification center) on windows 10 is quite useful. however, many users often don't care about this feature. in particular, the messages that appear frequently in the right corner of the screen not only make users feel uncomfortable but also cause your computer to be slow. so you can turn off the notification center to make your computer work faster.
Turn off turn on the character repeat function in Excel
in excel, when you enter content into a cell and then you enter the content below that cell with the same characters as the first character of the cell content above. the contents of the upper cell will be suggested to display in the lower box.
How to fix the error can not save Excel file
how to fix the error can not save excel file. in some cases, you can open a spreadsheet directly on outlook, or open a file as read only; you can edit the file, but when saving the file, excel will alert you with the following content: