'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Workbook Links That Stop Working After Reopening
Question details
The user needs to troubleshoot an issue where external workbook links break or stop updating after reopening the file, requiring manual reselecing of the source workbook.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Working with data connected across multiple Excel workbooks and attempting to retain functional data links after closing and reopening the files.
- Observed behavior
- The workbook links only function while both the source and destination files are open simultaneously. Once closed and reopened, the links break and require the source workbook to be selected again.
Ensure that both the source and destination workbooks are saved in the same secure, trusted location (such as a local drive) and avoid moving or renaming the files while troubleshooting.
Verify and Update Workbook Links Manually
Check the connection status of your external links and configure Excel to update them automatically upon opening.
Sometimes Excel loses the exact path to an external file, especially if it is stored on a network drive or synced cloud folder. Manually checking the link status and adjusting the startup prompt settings can resolve standard connection issues.
Navigate to the 'Data' tab on the Excel ribbon and click on 'Edit Links' in the Queries & Connections group.
Select the problematic source workbook in the list of links and click 'Check Status'. If it returns an Error, you will need to verify the file path.
Click 'Update Values' to force Excel to fetch the latest data from the source file without opening it.
Click the 'Startup Prompt' button at the bottom of the dialog box. Select 'Let users choose to display the alert or not' or 'Don't display the alert and update links' to ensure data refreshes.
Seek Specialized Support on Microsoft Learn
If workbook links persistently break due to software glitches or complex network setups, consult Excel experts for specialized troubleshooting.
Try WPS Office for Reliable Spreadsheet Linking
If Microsoft Excel continues to struggle with external workbook links, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet application (WPS Spreadsheet) that handles external data references seamlessly without complex subscription requirements or recurring bugs.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
- 2. Install the software: Run the installer and follow the on-screen instructions to set up WPS Office on your device.
- 3. Open your linked spreadsheets: Launch WPS Spreadsheet and open your existing Excel workbooks to instantly resume working with your linked data.
Frequently Asked Questions
Why do my Excel links only work when both workbooks are open?
This usually happens if the file path to the source workbook has changed, if the destination workbook doesn't have permission to access the background file, or due to a bug in how Excel caches network or cloud file paths.
How do I stop Excel from asking to update links every time I open a file?
Go to Data > Edit Links, click 'Startup Prompt', and select 'Don't display the alert and update links' so Excel refreshes the data automatically in the background.
Can I use WPS Spreadsheet as an alternative for linking external workbooks?
Yes, WPS Spreadsheet fully supports referencing cells from external workbooks and maintains high compatibility with Excel's .xlsx files and formula structures.
Does moving a file break external workbook links?
Yes, if you move or rename the source workbook without having the destination workbook open simultaneously, the absolute file path will break. You must use 'Edit Links' > 'Change Source' to repair it.
