How to Disable Automatic Update of Links in Excel (3 Easy Ways)

If you are looking for ways to disable the automatic update of links in Excel, then this article will serve this purpose. Sometimes the source articles are updated and then by updating links we can update the main file easily. So, let’s start with our main article to know more about this task.

How to Disable Automatic Update of Links in Excel: 3 Ways

Here, we have the following dataset in the workbook Confidence-Interval.xlsx and it is our source file. Using this file as a link we will copy the values from this sheet to another sheet.

In a new worksheet, Disable update link.xlsx, we have entered the following formula in cell B4.

For the Microsoft Excel 365 version, you can only press ENTER to get the following result. However, for other versions, you have to press CTRL+SHIFT+ENTER.

In this new sheet, we will show the ways of disabling the automatic updates of links for any change in the source worksheet.

Method-1: Using Advanced Option to Disable Automatic Update of Links in Excel

Here, in a new sheet of Disable update link.xlsx workbook, we have linked up the values from the source worksheet Dataset of Excel file Confidence-Interval.xlsx.

Steps:

Firstly, we can check the result of changing any value in the source worksheet of the Excel file Confidence-Interval.xlsx.

• Change the weight value of cell C4 from 95 to 100.

Then, we can see that the change has appeared on the workbook Disable update link.xlsx also.

• Go to the File tab.

• Choose Options.

Afterward, the Excel Options dialog box will open up.

• Go to the Advanced tab >> deselect/unclick Update links to other documents option >> click OK.

• Now, you can change any value from the source dataset like changing the weight value of cell C4 from 100 to 95.

As a result, the corresponding value of cell C4 will not be changed in the Disable update link.xlsx workbook.

Read More: [Fixed!] Excel Update Links Manually Greyed Out

Method-2: Utilizing Trust Center Tab

Here, we have linked up the values from an external workbook Confidence-Interval.xlsx in the new workbook Disable update link.xlsx. By using the Trust Center tab we can prevent the automatic updating of links.

Steps:

• Go to the File tab.

• Choose Options.

Afterward, the Excel Options dialog box will open up.

• Go to the Trust Center tab >> click Trust Center Settings.

Later, you will have the Trust Center wizard.

• Go to External Content >> click on Disable automatic update of Workbook Links >> press OK.

In this way, you will be taken to the Excel Options dialog box again.

• Click on OK.

Now, you can change any value of your source workbook.

• Change the weight value of cell C4 from 95 to 100.

But, in return, there will be no change in the new workbook Disable update link.xlsx.

Read More: How to Update Hyperlink in Excel Automatically

Method-3: Using Edit Links Option to Disable Automatic Update of Links in Excel

Here, in a new sheet of Disable update link.xlsx workbook, we have linked up the values from the source worksheet Dataset of Excel file Confidence-Interval.xlsx. By using the Edit Links option we will be able to cancel any automatic updating of links in the new article.

Steps:

• Go to the Data tab >> Edit Links.

Afterward, the Edit Links dialog box will appear.

• Click on the Startup Prompt option.

Then, the Startup Prompt wizard will pop up.

• Click on the Don’t display the alert and don’t update automatic links option.
• Press OK.

In this way, you will be taken to the Edit Links dialog box again.

• Press Close.

Now, you can change any value of your source workbook.

• Change the weight value of cell C4 from 95 to 100.

But, in return, there will be no change in the new workbook Disable update link.xlsx.

Read More: [Fix]: Excel Automatic Update of Links Has Been Disabled

How to Enable Automatic Update of Links in Excel

Here, we have linked up the values from an external workbook Confidence-Interval.xlsx in the new workbook Disable update link.xlsx. By using the Trust Center tab we can enable the automatic updating of links.

Steps:

• Go to the File tab.

• Choose Options.

Afterward, the Excel Options dialog box will open up.

• Go to the Trust Center tab >> click Trust Center Settings.

Later, you will have the Trust Center wizard.

• Go to External Content >> click on Enable automatic update for all Workbook Links >> press OK.

In this way, you will be taken to the Excel Options dialog box again.

• Click on OK.

Now, you can change any value of your source workbook.

• Change the weight value of cell C4 from 95 to 100.

Eventually, in return, the change will appear in the new workbook Disable update link.xlsx.

Download Pracrice Workbooks

Conclusion

In this article, we tried to show the ways to disable the automatic update of links in Excel. Hope you will find it useful. If you have any suggestions or questions, feel free to share them in the comment section.

Related Articles

• How to Update Links Without Opening File in Excel
• [Fixed!] Excel Links Not Updating Unless Source Is Open

<< Go Back To Update Excel Links | Linking in Excel | Learn Excel