How to turn off Update Link notification in Excel - File content from many different sources
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!
You should read it
- 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
- Instructions to turn off iOS update notifications
- How to remove Windows 7 upgrade notice from Microsoft
- How to turn off the message to restart the Windows 10 computer after the update
- How to turn off the notification center on Windows 10?
- To turn off Privacy Warning on Excel
- How to create suggestions for Hyperlink in Excel
- How to turn off Link Preview in Safari iOS 13
- How to turn off, receive a friend's birthday notification on Zalo
- Instructions to turn off notifications on Zalo effectively
- How to link, link data between Excel files
May be interested
Excel 2016 - Lesson 8: How to format numbers in Excel (Number Formats)
Instructions for increasing or decreasing font size on Powerpoint
Instructions for quickly aligning Excel printed pages, printing to fit the paper, without losing columns
How to quickly fix text simplification errors in Word when copying from the internet
How to batch delete photos in Excel - No need to delete them manually
How to fix the error of not being able to print images in Word - Images are not displayed