Instructions on how to fix 'This workbook contains links to one or more external sources that could be unsafe' error in Excel

How to fix "This workbook contains links to one or more external sources that could be unsafe" error

When you open a file and this message appears, it means your file has corrupted links and Excel cannot update these links. To remove these links, please follow these steps.

Instructions on how to fix 'This workbook contains links to one or more external sources that could be unsafe' error in Excel Picture 1

Step 1 : First, click on Enable Content in the notification. At this time, the message We can't update some of the links in your workbook right now appears, select Edit Links.

Or you can also select the Data tab on the Ribbon toolbar.

Then select Edit Links in the Connections section .

Step 2: At this point, the Edit Links dialog box appears with a list of broken links in your file. Click to select the link you want to delete then click Break Link .

Step 3: A notification about data results that will be affected if you delete this link appears. You continue to click Break Links. Just like that, we can delete the faulty link. Continue to select the next faulty links and then Break Links until there are no more faulty links.

Step 4 : Next, click on Startup Prompt.

At this time, the Startup Prompt dialog box appears. 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. Finally, click OK to complete.

Thus, the above article has shown you how to fix the error "This workbook contains links to one or more external sources that could be unsafe" in Excel files. Hope this article will be useful to you in your work process. Good luck!

Excel

Samuel Daniel

Update 04 April 2024

You should read it

May be interested

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 use the Rate function in Excel to calculate loan interest rates is extremely simple
in this article, we will learn with readers about how to use the rate function to calculate loan interest rates in excel in the most detailed way.
Instructions on 2 simple ways to delete conditional rows in Excel
if you want to delete conditional rows in excel, you will have to spend a lot of time selecting and deleting in the data table. that's why this article will show you 2 ways to delete conditional rows in excel very quickly.
Tell you how to turn off security warnings in Excel in the simplest and most detailed way
protected view is an extremely useful feature in microsoft software, but not everyone knows how to use it. this article will guide you to turn off security warnings in excel quickly and simply.
How to delete PDF pages extremely quickly
in a soft document file, sometimes there are pages that you want to hide or delete. pdf is no exception. however, deleting pdf pages is not like other common document file types.
How to view multiple pages in Word at the same time
to easily view the content between multiple word document pages, instead of having to scroll through each page or continuously click to zoom in and out of word documents, users should use multiple pages mode to view multiple word pages at the same time. at the time.