How to Disable Automatic Update of Links in Excel – 3 Methods

The following dataset is in the workbook Confidence-Interval.xlsx and is the source file.

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

Method 1 – Using the Advanced Options to Disable the Automatic Update of Links in Excel

In a new sheet of the Disable update link.xlsx workbook, values are linked to the source worksheet Dataset in Confidence-Interval.xlsx.

Steps:

Check the result of changing any value in the source worksheet: Confidence-Interval.xlsx.

• Change the weight value in C4 from 95 to 100.

The change is also displayed in Disable update link.xlsx.

• Go to the File tab.

• Choose Options.

In the Excel Options dialog box:

• Go to the Advanced tab >> uncheck Update links to other documents  >> click OK.

• You can change values in the source dataset,

and values won’t change in the Disable update link.xlsx workbook.

Method 2 – Utilizing the Trust Center Tab

Values are linked from an external workbook Confidence-Interval.xlsx to the new workbook Disable update link.xlsx.

Steps:

• Go to the File tab.

• Choose Options.

In the Excel Options dialog box:

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

In the Trust Center wizard:

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

In the Excel Options dialog box:

• Click OK.

You can change values in your source workbook,

and 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 the Edit Links Option to Disable Automatic Update of Links in Excel

In a new sheet of Disable update link.xlsx workbook, values are linked to the source worksheet Dataset in Confidence-Interval.xlsx.

Steps:

• Go to the Data tab >> Edit Links.

In the Edit Links dialog box:

• Click Startup Prompt.

In the Startup Prompt wizard:

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

In the Edit Links dialog box:

• Click Close.

You can change values in your source workbook,

and 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

Steps:

• Go to the File tab.

• Choose Options.

In the Excel Options dialog box:

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

In the Trust Center wizard:

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

In  the Excel Options dialog box:

• Click OK.

You can change values in your source workbook,

and the change will be displayed in the new workbook Disable update link.xlsx.

Download Practice Workbook

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