HomeApplicationOffice information

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!

5 ★ | 1 Vote
Excel

You should read it

May be interested

  • How to delete links in ExcelHow to delete links in Excel
    how to delete links in excel. hyperlink in excel gives you quick access to web links, links to sheets in excel files or links to files on your computer.
  • Part 4: Hide Sheet, Sheet tab, Scroll Bar, WorkbookPart 4: Hide Sheet, Sheet tab, Scroll Bar, Workbook
    types of data hiding in excel - part 4: hide sheet, sheet tab, scroll bar, workbook
  • This is a way to prevent hackers from stealing your data when using public WifiThis is a way to prevent hackers from stealing your data when using public Wifi
    one advice is to be cautious when browsing the web. never let your curiosity be the cause of unworthy errors. on your browser, block and remove all tracking cookies. especially 'stay away' from unsafe and unknown sources (beware of free software), and stay away from 'suspicious' links sent to your email or links that appear on new feeds social networking sites.
  • What is Unsafe Rust?What is Unsafe Rust?
    unsafe rust gives you more control over memory. the article will give you everything you need to know about using unsafe rust and understand the risks of using it.
  • How to Add Links in ExcelHow to Add Links in Excel
    microsoft excel is a fully functional spreadsheet application that allows users to organize, store and analyze many different types of data. you can add links to websites, to other documents, or even to other cells and pages in the same spreadsheet when you need to refer to another source for additional information, backup, and support for your data. friend.
  • What is ### error in Excel? how to fix ### error in ExcelWhat is ### error in Excel? how to fix ### error in Excel
    ### in excel is an error that excel frequently encounters and appears in many different cases when we enter data in excel, functions in excel, enter formulas in excel or when displaying results.
  • How to Automatically Report on ExcelHow to Automatically Report on Excel
    today's tipsmake will guide you how to automatically report data on microsoft excel. this article also talks about how to query and create reports from external sources (mysql, postgres, oracle, etc.) right on your spreadsheet using the excel plug-in to link your spreadsheet to the source. that data. as for data stored on excel spreadsheets, we will use macro commands to create and export reports into many different file types with just one keystroke. luckily, excel has this feature built in, so you won't need to create your own algorithm.
  • Instructions on how to create Hyperlink in ExcelInstructions on how to create Hyperlink in Excel
    excel's hyperlink is responsible for inserting web page links in excel content. when people create spreadsheets and insert access links in excel content, we can access the website quickly.
  • How to create hyperlinks in excel is extremely usefulHow to create hyperlinks in excel is extremely useful
    create hyperlink in excel. this hyperlink button is extremely convenient, can create links to other sheets, emails, websites, or a newly created excel file.
  • How to delete links in Excel, delete hyperlinks in ExcelHow to delete links in Excel, delete hyperlinks in Excel
    what if you want to disable hyperlink links in excel? there are many ways for us to quickly find and delete links in excel.

Office information