Document Editing Problems

How to Fix Word Mail Merge Using Old Excel Data Instead of New Spreadsheet

Maira Mehtab Sep 20, 2026 869 views

Question details

The user is experiencing an issue where a copied Word mail merge document continues to pull data from an older Excel workbook, even after being connected to a new spreadsheet.

Product: Microsoft Word
Device & OS: not provided
Scenario: Copying a previously merged letter and connecting it to a new Excel data source for a new mail merge task.
Observed behavior: The mail merge document ignores the newly connected spreadsheet and continues to display data from the old Excel workbook.

Before you start

Before troubleshooting, ensure that both your Word document and the new Excel spreadsheet are saved in the same local folder and that the Excel file is fully closed before attempting the mail merge.

Solution 1Recommended

Properly Disconnect and Reconnect the Data Source

The most reliable way to force Word to recognize the new Excel data is to completely remove the old connection before attaching the new spreadsheet.

When you copy an existing mail merge document, Word often caches the previous OLE DB connection. Simply selecting a new list might not overwrite this cache. You must convert the document to a normal Word document first.

Open the Document

Open the copied Word document that is experiencing the data issue.

Change Document Type

Navigate to the 'Mailings' tab on the ribbon, click 'Start Mail Merge', and select 'Normal Word Document'. This disconnects the current data source.

Save and Reopen

Save the document, close Microsoft Word completely, and then reopen the document.

Connect New Spreadsheet

Go back to the 'Mailings' tab, click 'Select Recipients', choose 'Use an Existing List', and browse to select your new Excel spreadsheet.

Tip: Always ensure your new Excel spreadsheet has a clear header row and no blank rows at the top to prevent data reading errors.

Solution 2

Verify File Compatibility and Office Versions

Compatibility issues between different versions of Word and Excel can cause data source caching problems.

Free Microsoft Office alternative

Try WPS Office for Seamless Mail Merge Operations

If Microsoft Word continues to struggle with caching old Excel data, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with a built-in Mail Merge feature that works flawlessly with your existing spreadsheets.

1. Download and Install: Get WPS Office Free from the official website and install it on your device.
2. Open Your Documents: Open your existing Word (.docx) and Excel (.xlsx) files directly in WPS Office.
3. Start Mail Merge: Use the Mailings tab in WPS Writer to securely link your spreadsheet without the hassle of residual data caching.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Intuitive Mail Merge feature without persistent data caching bugs.Free, lightweight, and uses minimal system resources.Familiar user interface requiring zero learning curve for Office users.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Word keep using the old Excel data in my mail merge?

Word often caches the OLE DB connection path when a document is copied. If the new connection isn't properly refreshed, Word defaults to the cached data source stored in the document's background.

Can I use a copied Word document for a new mail merge?

Yes, but you must manually disconnect the old data source by changing the document type to a 'Normal Word Document' before linking the new Excel file. This clears out the old file references.

Does it matter if my Excel file is open while doing a mail merge?

Yes, having the Excel file open can sometimes lock the data source or prevent Word from fetching the most updated data. It is highly recommended to save and close the Excel file before linking it in Word.

How do I check which Excel file is currently linked to my Word document?

Go to the 'Mailings' tab, click on 'Edit Recipient List', and look at the 'Data Source' box at the bottom of the dialog window. This displays the exact file name and path currently connected to your document.

Document & File Issues