File Format & Compatibility

Fix Excel Unable to Read a Linked XLS File When Closed

John WilsonJohn Wilson Oct 7, 2026 871 views

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.

Fix Excel Unable to Read a Linked XLS File When Closed
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the source file

Locate the problematic linked XLS file and open it directly in Microsoft Excel.

2
Access the Save As menu

Click on the 'File' tab in the top-left corner of the ribbon and select 'Save As'.

3
Overwrite or convert the format

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.

4
Update your destination links

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).

Resave or Convert the Source XLS Workbook
Permanent Resolution: Upgrading older .xls files to the modern .xlsx format is the most reliable way to prevent recurring external link errors.
Free Microsoft Office alternative

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. 1. Download the software: Visit the official WPS Office website and download the free installation package for your operating system.
  2. 2. Install WPS Office: Run the downloaded installer and follow the quick on-screen instructions to set up the suite.
  3. 3. Open legacy files seamlessly: Launch WPS Spreadsheets to open, edit, and link your older .xls files without encountering strict read-state errors.
Highly compatible with Microsoft Excel formats including .xls, .xlsx, and .csvFree, lightweight, and opens large legacy workbooks quicklyFamiliar user interface with zero learning curve for regular Office usersReliable handling of external workbook links and complex formulas
microsoft office alternative - wps office

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.