Excel External Links Break After Converting XLS to XLSX: How to Fix Them

You converted your Excel files to .xlsx and now you're getting "We can't update some of the links in your workbook" every time you open the file. The data that used to pull from other workbooks is now showing old values — or worse, #REF! errors. Here's what's happening and how to fix it.

Why External Links Break During XLS to XLSX Conversion

External links in Excel store the exact file path including the extension. A formula that pulls data from another workbook looks like this inside the file:

='C:\Finance\[Budget-2025.xls]Summary'!$B$4

When you convert Budget-2025.xls to Budget-2025.xlsx, that stored path becomes wrong. Excel sees Budget-2025.xls, looks for it on disk, can't find it (because it's now Budget-2025.xlsx), and reports a broken link.

Excel doesn't automatically update these references when you rename or convert a file. It has no way to know that the .xls became an .xlsx — you have to tell it. External links are just one of many things that can go wrong during format conversion; our complete guide to legacy Excel migration covers the full list.

Step 1: Find All Broken External Links

First, understand the scope. Open the affected workbook and go to Data > Edit Links (in Excel 365 it may appear under Queries & Connections > Edit Links).

The Edit Links dialog shows every external workbook this file references. Look at the Status column:

• OK — link is still valid, source file found
• Error: Source Not Found — file has been moved, renamed, or converted
• Unknown — Excel hasn't checked yet; click Check Status

If Edit Links is grayed out, the file has no external links (the problem is something else — check named ranges or data validation lists).

Step 2: Update Source Paths

For each broken link in the Edit Links dialog:

1. Select the broken link entry
2. Click Change Source
3. Navigate to the .xlsx version of the source workbook and select it
4. Click OK — the Status should change to OK

Repeat for each broken link. Save the workbook.

Step 3: Fix Formula-Level References

The Edit Links dialog fixes the top-level link registry, but some workbooks also have the extension hardcoded in formulas. Check this with Find & Replace:

1. Press Ctrl+H to open Find & Replace
2. In "Find what": type .xls]
3. In "Replace with": type .xlsx]
4. Click Replace All

This bulk-updates any formula that explicitly references an .xls file. It won't break formulas pointing to .xlsx files (the search is specific to .xls], the closing bracket prevents it from matching .xlsx).

Step 4: Check Named Ranges

Named ranges can also hold external references. Open Formulas > Name Manager (Ctrl+F3) and scan the "Refers To" column for any paths ending in .xls]. Update them to point to the .xlsx source.

Step 5: Handle Links That Won't Update

Some links can't be updated through the normal flow — for example, links to workbooks that have been deleted or are no longer available. For these, you have two options:

Option A: Break the link (converts to static value)

In Edit Links, select the broken link and click Break Link. This replaces all formula references with the last-known values. The data becomes static — it won't update if the source changes — but it stops the error.

Option B: Rebuild the connection

If you have a new .xlsx source with the same structure, break the old link and then recreate the formula references pointing to the new file. More work, but keeps the data live.

Preventing This Problem in a Batch Migration

If you're converting multiple files that reference each other, order matters:

1. Map your dependencies first. Before converting anything, know which files link to which. A PowerShell scan or LegacyLeaps's free scan will surface this.
2. Convert source files before dependent files. Convert the files that others link to first. Then when you convert the dependent files, the .xlsx source already exists.
3. Keep both .xls and .xlsx versions during the transition. Don't delete the originals until all dependent files have been converted and tested.
4. Verify link status after each batch. Open each converted file, run Check Status in Edit Links, and confirm no errors before moving on.

When the Fix Doesn't Hold

If you fix the links today but they break again tomorrow, the problem is usually one of:

• Someone else on the network still has the old .xls files. If a colleague has the original .xls still open or saved in a personal folder, Excel may re-resolve the link to their local copy — then fail when their copy moves.
• Drive letter or UNC path inconsistency. User A maps the share as Z:\ while User B maps it as Y:\. The stored link works for one and not the other. Use UNC paths (\\server\share\...) instead of drive letters for shared workbooks.
• AutoRecover is saving old link state. Clear the AutoRecover temp files after fixing links — old versions can restore stale link data.

← Back to all posts