Fix Excel Unable to Read a Linked XLS File When Closed
Question details
The user needs to fix an error where Excel fails to read external links from a closed source workbook, specifically when the source file is in the older XLS format.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Accessing linked data from a closed external workbook, which is often received automatically via email and saved to SharePoint using Power Automate.
- Observed behavior
- Excel displays an 'Unable to read file' error message when attempting to update links or access data from the closed XLS file.
Verify that you have the correct read permissions for the source file on your local drive or SharePoint, and ensure the file path has not recently changed.
Resave or Convert the Source XLS Workbook
Manually opening and resaving the source file updates its internal structure, resolving legacy format compatibility issues that prevent Excel from reading it while closed.
Older .xls files, especially those generated by third-party reporting tools, may lack the correct internal tags required for Excel to read them in a closed state. Resaving the file natively forces Excel to rewrite the file correctly.
Locate the problematic linked XLS file and open it directly in Microsoft Excel.
Click on the 'File' tab in the top-left corner of the ribbon and select 'Save As'.
Select 'Excel 97-2003 Workbook (*.xls)' to overwrite the existing file, or choose 'Excel Workbook (*.xlsx)' to upgrade the file to the modern standard for better compatibility.
Open your main workbook, navigate to Data > Edit Links, and update the source path to point to the newly saved file (especially if you changed the extension to .xlsx).

Automate File Conversion in Power Automate
If you receive the source file automatically via email, adding a conversion step in your workflow eliminates the need to manually resave the file every time.
Try WPS Office for Seamless Spreadsheet Compatibility
If you frequently encounter compatibility issues, legacy file errors, or 'Unable to read file' messages with older XLS files in Microsoft Excel, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet environment that easily handles both old and modern Excel formats without breaking external links.
- 1. Download the software: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the downloaded installer and follow the quick on-screen instructions to set up the suite.
- 3. Open legacy files seamlessly: Launch WPS Spreadsheets to open, edit, and link your older .xls files without encountering strict read-state errors.

Frequently Asked Questions
Why does Excel show 'Unable to read file' only when the source workbook is closed?
When a linked file is closed, Excel attempts to read the data directly from the disk without loading the file's full structure into memory. If the source file is an older .xls format (especially if generated by an automated third-party system), it may lack the specific internal structures Excel requires to read it passively.
How do I safely update or change my external links in Excel?
Go to the 'Data' tab on the Excel ribbon, click on 'Queries & Connections', and select 'Edit Links' (or simply 'Edit Links' in older versions). From the dialog box, you can choose 'Update Values' to refresh the data or 'Change Source' to point the link to a newly converted .xlsx file.
Can SharePoint or OneDrive syncing issues cause this link error?
Yes. If the linked file is hosted on SharePoint or OneDrive and your local sync client is paused, your session token has expired, or you lack sufficient permissions, Excel may fail to access the closed file and display a read error.




