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

Get FREE Advanced Excel Exercises with Solutions!

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.

how to disable automatic update of links in excel

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

='[Confidence-Interval.xlsx]Dataset'!$B$4:$C$14

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.

Using Advanced Option to Disable Automatic Update of Links in Excel

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.

value is changed due to automatic update of links in Excel

  • Go to the File tab.

  • Choose Options.

options selection

Afterward, the Excel Options dialog box will open up.

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

Excel options to disable automatic update of links

  • 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.

final result

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.

using Trust Center tab to disable automatic update of links in Excel

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.

trust center tab

Later, you will have the Trust Center wizard.

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

enabling Disable automatic update of Workbook Links

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.

change value

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

final result

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.

Using Edit Links Option to Disable Automatic Update of Links in Excel

Steps:

  • Go to the Data tab >> Edit Links.

edit links

Afterward, the Edit Links dialog box will appear.

  • Click on the Startup Prompt option.

startup prompt

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.

prevent changes by disabling automatic update of links

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.

Enable automatic update 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.

trust center tab

Later, you will have the Trust Center wizard.

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

click on Enable automatic update for all Workbook Links

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

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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Tanjima Hossain
Tanjima Hossain

TANJIMA HOSSAIN is a marine engineer who enjoys working with Excel and VBA programming. For her, programming is a handy, time-saving tool for managing data, files, and online tasks. She's skilled in Rhino3D, Maxsurf C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. She holds a B.Sc. in Naval Architecture & Marine Engineering from BUET and is now a content developer. In this role, she creates tech-focused content centred around Excel and VBA. Apart from... Read Full Bio

4 Comments
  1. I have tried all three methods to disable update link, but the Disable-update-link file is still updated whenever I change the value of Confidence-Interval.

    I am using Microsoft Office 365.

    • Hello, DONI!
      Thanks for sharing your problem with us!
      All the methods work properly for me. I am also using Microsoft Office 365.
      Can you please send me your excel file via email? ([email protected]).
      So that, I can solve your problem.

      Good Luck!

      Regards,
      Sabrina Ayon
      Author, ExcelDemy
      .

  2. I have tried all three options, and my file still updates automatically.

    The start up prompt setting has stayed on “don’t and don’t”, the Advanced “ask to update links” is unchecked, and Trust Center “disable auto update” is unchecked, but as soon as I hit enter in my source file, this file updates.

    And no, you will not be getting my file emailed to you. It is proprietory data that can not be shared outside of my organization. Plus, how could you review ONE of the two files, and not have BOTH to test with?

    • Reply Avatar photo
      Musiha Mahfuza Mukta Sep 19, 2023 at 11:38 AM

      Hey Anita,
      Sorry for the issues you are facing. If these methods don’t work, you can break the link to disable the updates. To break links, go to the Data tab >> select Edit Links >> select the link >> click on Break Link.

      I hope this will help you solve the problem. Here, you can try some more options like changing the name of the Source file. Also, you should change the location of the Source file. It will stop Excel from connecting the existing file with the Source file.
      Furthermore, if you don’t want to update your file, you can use the Copy-Paste(Value Only) feature for transferring data from a Source file.
      Regards
      Musiha|ExcelDemy

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo