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

Excel 2016 - Lesson 8: How to format numbers in Excel (Number Formats)
formatting numbers in excel not only makes your spreadsheet easier to read, but it also makes it easier to use. when you apply a number format, you are telling the spreadsheet exactly what type of value is stored in a cell.
Instructions for increasing or decreasing font size on Powerpoint
to answer readers' questions about how to increase or decrease font size on powerpoint, today tipsmake would like to introduce and send readers detailed instructions on how to increase or decrease font size on powerpoint application.
Instructions for quickly aligning Excel printed pages, printing to fit the paper, without losing columns
instructions for quickly aligning excel printed pages with just very simple operations. to adjust the page before printing, please follow tipsmake's instructions below
How to quickly fix text simplification errors in Word when copying from the internet
to no longer have letter reduction errors in word when copying from the internet, please follow tipsmake's instructions in the article below.
How to batch delete photos in Excel - No need to delete them manually
to batch delete images in an excel file, you can do it through the go to special tool or use vba. all images are quickly deleted after following a few simple steps, instead of manually deleting each image.
How to fix the error of not being able to print images in Word - Images are not displayed
errors of not being able to print images, or not displaying images on word, will make it difficult for users to print documents.