Update Excel External Links Without Opening the Source Workbook
Question details
The user wants to update Excel links to a source workbook without opening that 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.
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.
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.
Open the Excel workbook that contains the external links, leaving the source workbook closed.
Go to Data > Edit Links, or Data > Workbook Links in versions that use the newer pane.
Select the source workbook and choose Update Values, or use the available refresh control in the Workbook Links pane.
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.

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.

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.




