Fix Excel Linked Tables That Do Not Recognize Source Data After a Version Change
Question details
The user needs to restore data recognition and collection for Excel tables linked to original source tables after changing Excel versions.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Linked tables, external workbook references, or imported connections no longer return the expected source data after an Excel version change.
- Observed behavior
- Some tables do not recognize data from the original tables, and linked information is not collected or refreshed correctly.
Open both the source and destination workbooks, and make sure you have permission to access their current locations. Note the source workbook name, folder path, table names, and any named ranges used by the linked formulas or queries.
Update external workbook links and refresh all linked data
Use this when formulas or linked tables point to a source workbook that was moved, renamed, or changed during the Excel version upgrade.
Excel may retain an outdated external reference path after a version change. Updating the source location and refreshing all connections can restore linked table values.
Open the workbook that contains the linked tables or formulas that are not collecting data correctly.
On the Excel ribbon, select Data > Edit Links. Select the affected source workbook, then choose Change Source and browse to the current source workbook file.
In the Edit Links window, select Update Values. If Excel displays a security prompt, choose Enable Content or Update so the workbook can retrieve external data.
Select Data > Refresh All to refresh linked tables, queries, PivotTables, and external data connections.
Check the linked table cells and formulas. If values still do not appear, open the source workbook and confirm that the referenced worksheet, table, and columns still exist.
Check table names, named ranges, and structured references
Use this when the source workbook opens successfully but formulas or table references return errors, blanks, or incomplete data.
Repair Power Query or data connection settings
Use this when linked data is loaded through Power Query, a connection, or an import rather than ordinary workbook formulas.
Work with Linked Excel Tables in WPS Office Spreadsheets
If Microsoft Excel version changes continue to disrupt your workbook workflow, WPS Office provides a free, lightweight spreadsheet alternative with a familiar interface and straightforward migration for Excel files. Open your existing workbook in WPS Spreadsheets to review formulas, linked data, tables, and imported content without rebuilding your documents from scratch.
- 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the WPS Office home screen.
- 2. Open the Excel workbook: Select Open and choose the affected .xlsx or .xls workbook containing the linked tables.
- 3. Review table formulas and source references: Click affected cells and inspect the formula bar to verify workbook references, sheet names, table names, and column references.
- 4. Refresh or recalculate data: Use the Data tools for imported data as needed, then recalculate the workbook and confirm that linked table results are updated.
Frequently Asked Questions
Why do my Excel linked tables stop updating after I install a newer Excel version?
The newer installation may use a different trusted location, external-content setting, or workbook path. In the destination workbook, go to Data > Edit Links, update the source file if necessary, and select Update Values.
Where can I change the source file location for an Excel external link?
Open the workbook that receives the linked data, then select Data > Edit Links. Select the source workbook, choose Change Source, and select the current file location.
How do I refresh all tables and external data in Excel?
Select Data > Refresh All. This refreshes supported external links, Power Query outputs, PivotTables, and other workbook data connections.
What should I check if an Excel structured reference returns blank data?
Check that the source table still has the same Table Name, column headers, and source columns. Select the source table, open Table Design, and verify its name; then review the destination formula in the formula bar.
How can I fix a Power Query table that uses an old workbook path?
Select Data > Queries & Connections, right-click the affected query, and choose Edit. In Power Query Editor, select the Source step and update the file path or source selection, then choose Home > Close & Load.
