How to fix This workbook contains links to other data sources Excel

This workbook contains links to other data sources Excel-  How to turn off Update Link Excel Open File does not see data, his workbook contains links to other data sources Excel -You are using Excel normally, suddenly this message pops up and you open the File Excel and you can’t see the data anywhere, you are worried about losing important data.

 cach-tat-update-link-excel

 

How to fix This workbook contains links to other data sources Excel

This workbook contains links to other data sources Excel…..

Step 1:

You operate in Excel as follows:

Go to =>>> Data on the Menu Excel is using, select =>>> and go to Edit Links  as shown below

This-workbook-contains-links-to-other-data-sources-Excel

 

Step 2:

After clicking   Edit Links. it will show many files that are located there, click on the list of files and delete them.

In the    Edit Link interface. Please select the File displayed inside and select Break Link as shown below

 

cach-xoa-Edit-Links-trong-excel

This workbook contains links to other data sources Excel

 

After Clicking Startup Prompt… You tick the second line as shown below (Do not display warnings and do not  automatically update link ) select  =>>> Don’t display the alert and don’t update automatic links to not display Display the Update link message again when processing Excel documents later.

Không hiện thông báo

Thus, you have completely turned off the Update link Excel message (This workbook contains links to other data sources Excel ) when working with Excel files that are linked with many links of other sheets and spreadsheets. This message will persist even if the linked spreadsheet no longer exists.
Please unlink and turn off the update link notification on Excel.This workbook contains links to other data sources Excel to avoid confusion.

 

excell 2010
go to data\edit link\startup prompt select line 2 don’t display…..ok. save the file

Automatic update and no message

To suppress the message and to automatically update the links when you open a workbook in Excel, follow these steps:

  1. Select File > Options > Advanced.
  2. Under General, click to clear the Ask to update automatic links check box.

 Note

  • When the Ask to update automatic links check box is cleared, the links are automatically updated. Additionally, no message appears.
  • This option applies to the current user only and affects every workbook that the current user opens. Other users of the same workbooks are not affected.

Manual update and no message

If you are sharing this workbook with other people who will not have access to the sources of the updated links, you can turn off updating and the prompt for updating. To suppress the message and leave the links (not updated) until you choose to update them, follow these steps:

  1. In Excel, select Edit Links in the Queries & Connections group on the Data tab.

  2. Click Startup Prompt.

  3. Click the Don’t display the alert and don’t update automatic links option.

     Warning

    If you choose not to update the links and not to receive the message, users of the workbook will not know that the data is out of date. This choice affects all users of the workbook. However, this choice applies only to that particular workbook.

To update the links manually, follow these steps:

  1. Select Edit Links in the Queries & Connections group on the Data tab.
  2. Select Update Values.
  3. Select Close.

 

this workbook contains links to one or more external sources that could be unsafe how to fix,
excel 2016 this workbook contains links to one or more external sources that could be unsafe,
cch engagement this workbook contains links to one or more external sources that could be unsafe,
excel workbook contains links to external sources how to find,
this workbook contains links to external data sources that use dde that may be unsafe,
This workbook contains links to other data sources Excel 2010,
how to enable automatic update of links in excel 2007,
excel update links error

Most views