File Sharing Problems

How to Fix a Broken Excel-to-Access Linked Table After Renaming the Workbook

Amos Gikunda Oct 10, 2026 869 views

Question details

The user needs to restore the data connection between a Microsoft Access table and an Excel workbook after the Excel file's name has been changed.

How to Fix a Broken Excel-to-Access Linked Table After Renaming the Workbook

Product: Microsoft Access / Microsoft Excel
Device & OS: not provided
Scenario: An Excel workbook acting as a linked data source for an Access database was renamed, causing the data connection to break upon opening Access.
Observed behavior: Microsoft Access fails to automatically track the renamed Excel file, resulting in a broken linked table and an inability to view or query the spreadsheet data.

Before you start

Ensure you know the exact new file path and name of your renamed Excel workbook before attempting to restore the connection in your database.

Solution 1Recommended

Manually Relink the Renamed Excel Workbook

The most straightforward way to fix a broken link is to use the Linked Table Manager in Microsoft Access to point the table to the newly renamed file.

Because Access stores the absolute file path and name of external data sources in its connection string, any change to the file name will break the link. The built-in Linked Table Manager allows you to easily update this connection string without having to recreate the table.

Open Linked Table Manager

Open your Microsoft Access database. Go to the 'External Data' tab on the top ribbon and click on 'Linked Table Manager'.

Select the broken table

In the Linked Table Manager dialog box, locate and check the box next to the Excel table link that is currently broken. Make sure to check the box at the bottom that says 'Always prompt for new location' if available in your version.

Browse for the new file

Click 'OK' or 'Relink'. A File Explorer window will appear. Navigate to the folder containing your Excel workbook, select the renamed .xlsx file, and click 'Open' to successfully restore the connection.

Manually Relink the Renamed Excel Workbook

Link Restored: Once updated, you can query and access the spreadsheet data exactly as you did before the file was renamed.

Solution 2

Automate Relinking Using VBA and RefreshLink

For databases distributed to multiple users, you can use VBA code at startup to detect broken links and prompt the user to locate the renamed file automatically.

Free Microsoft Office alternative

Manage Your Spreadsheets Seamlessly with WPS Office

While Microsoft Access is required for specific database linking, you can effortlessly manage, rename, and edit all your underlying Excel workbooks using WPS Spreadsheets. WPS Office is a free, lightweight alternative that provides robust data handling and flawless compatibility without the heavy subscription costs.

1. Download the software: Visit the official WPS Office website and download the free installer for your operating system.
2. Install and launch: Run the quick installation process. Once completed, open WPS Office to access the Spreadsheets application.
3. Open your workbooks: Click 'Open' and select your existing .xlsx files. You can now edit your data with complete formatting retention.

100% compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsLightweight installation with blazing fast startup speedsFamiliar, easy-to-use tabbed interface for seamless migrationFree built-in advanced data analysis and pivot table features

Frequently Asked Questions

Why does Microsoft Access lose the link when an Excel file is renamed?

Access stores the exact file path and file name of the linked Excel workbook in its internal connection string. Because it relies on the local file system path, it does not dynamically track external changes like renaming or moving the file.

Can I prevent the link from breaking if I need to rename the file frequently?

If the file name changes constantly (e.g., daily reports with dates in the file name), it is better to import the data into a local Access table rather than linking it, or use a VBA script that automatically detects the newest file in a specific folder and updates the connection string accordingly.

How do I check which Excel file my Access table is currently linked to?

Open Microsoft Access, navigate to the 'External Data' tab, and click on 'Linked Table Manager'. Hover over or select your linked table to see the full file path and name it is currently attempting to connect to.

Document & File Issues