Data Import & Export

Update Excel External Links Without Opening the Source Workbook

Huma Ashraf ChHuma Ashraf Ch Nov 18, 2026 869 views

Question details

The user wants to update Excel links to a source workbook without opening that workbook.

Can Excel Update External Links Without Opening the Source Workbook?
Product
Microsoft Excel
Device & OS
not provided
Scenario
A destination workbook contains external links to values in another workbook that is closed.
Observed behavior
Excel can retrieve saved values from a closed source workbook, but it may open the source invisibly in the background during an update.
Before you start

Confirm that the source workbook is saved and accessible at the path used by the external links. Menu names can vary by Excel version; newer versions may show Workbook Links instead of Edit Links.

Solution 1Recommended

Update links to a closed workbook from Excel

Use Excel's link controls to refresh saved values without manually opening the source workbook.

Excel may access or open the source workbook invisibly while updating. There is no standard setting that guarantees the source will not be opened in the background.

1
Open the destination workbook

Open the Excel workbook that contains the external links, leaving the source workbook closed.

2
Find the links

Go to Data > Edit Links, or Data > Workbook Links in versions that use the newer pane.

3
Update the values

Select the source workbook and choose Update Values, or use the available refresh control in the Workbook Links pane.

4
Review the startup prompt

In Edit Links, choose Startup Prompt to review whether Excel asks about updating links when the destination workbook opens. The available choices depend on your Excel version and settings.

Update links to a closed workbook from Excel
Background access: Controlling the update prompt does not prevent Excel from accessing or opening the source in the background. A custom macro or a different data connection may offer another workflow, but neither guarantees that the source file will not be accessed.
Free Microsoft Office alternative

Work with linked spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility for a seamless move between office suites. It does not change how Microsoft Excel handles background link updates.

Work with spreadsheets that reference data in other workbooksOpen and edit Microsoft Excel formats such as XLSX and XLSUse a familiar interface that makes switching office suites easierAccess a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Can Excel update links when the source workbook is closed?

Yes. Excel can often retrieve saved values from a closed source workbook. In the destination workbook, go to Data > Edit Links or Data > Workbook Links and use the update or refresh control.

Can I stop Excel from opening the source invisibly?

There is no standard Excel setting that guarantees the source workbook will not be opened in the background during a link update.

How do I change the link update prompt?

In versions with Edit Links, go to Data > Edit Links > Startup Prompt and review the available options. Your Excel version and security settings may affect the choices.

Why might an external link fail to update?

The source file may have moved, be unavailable, or have an inaccessible path. Check the source listed under Data > Edit Links or Data > Workbook Links and confirm that the file is accessible.