Why Word Mail Merge Pulls Old Data Despite Refreshing the Excel Source

You refresh your Excel spreadsheet, save it, and run the mail merge in Word. But the merged documents still show old names, addresses, or numbers. This happens because Word does not automatically refresh its data connection to the Excel file after the source changes. This article explains the two main causes of this problem: Word’s cached connection to a specific Excel range and the default link behavior that locks the data at merge time. You will learn how to force Word to pull the current data and how to set up your Excel source so future merges always use the latest information.

Why Word Mail Merge Does Not Refresh Automatically

When you connect a Word mail merge to an Excel file, Word stores a snapshot of the connection settings. It records the file path, the worksheet name, and the specific cell range. If you later add rows or change data in Excel, Word still refers to the original range it captured. This is by design: Word treats the Excel source as a static database query at the moment of the merge. The connection does not poll Excel for changes unless you manually refresh it.

Word Locks to a Specific Cell Range

The most common cause of old data is that Word defaults to using the entire worksheet as the data source. When you select Sheet1 in the Select Table dialog, Word records the range as something like Sheet1$. This dollar sign indicates a reference to the entire worksheet. However, if you later delete rows or add rows at the bottom, Word may still reference a cached version of the range boundaries. More critically, if you opened the Excel file and Word saw 100 rows, it will only merge 100 rows even if the Excel file now has 120 rows. Word does not scan the worksheet again to count the new rows.

Named Ranges Solve the Static Range Problem

A named range in Excel is a dynamic or fixed label that Word can follow. If you define a named range that expands automatically when you add data, Word will read the current range each time you refresh. Without a named range, Word relies on its initial scan of the worksheet.

How to Force Word to Pull Current Excel Data

You have two reliable methods to refresh stale data. The first method reconnects the entire mail merge document to the Excel source. The second method refreshes the recipient list without breaking the connection. Use the first method if you changed the structure of the Excel data, such as adding or removing columns. Use the second method if you only changed values in existing rows or added new rows at the bottom of a named range.

Method 1: Reconnect the Excel Source

1. Open the mail merge document in Word
   Make sure no other program has the Excel file open. Close Excel if it is running.
2. Go to Mailings > Select Recipients > Use an Existing List
   Word displays the Select Data Source dialog.
3. Navigate to your Excel file and select it, then click Open
   Word shows the Select Table dialog. You see a list of worksheets and any named ranges.
4. Select the worksheet or named range that contains your updated data
   If you defined a named range in Excel, select that name. If you use a worksheet, select the sheet name that ends with a dollar sign.
5. Check the box “First row of data contains column headers” if it is unchecked
   This step ensures Word recognizes your header row.
6. Click OK
   Word reloads the data from the Excel file. The merge fields now reflect the current values.

Method 2: Refresh the Recipient List

1. Go to Mailings > Edit Recipient List
   Word opens the Mail Merge Recipients dialog.
2. In the Data Source section at the bottom, click Refresh
   Word re-reads the Excel file using the existing connection settings. The recipient list updates to show the current rows and values.
3. Click OK
   Word updates the merge fields in the document. Run a test merge to verify the data is correct.

If Word Still Shows Old Data After Refreshing

Word Cannot Find the Excel File at the Original Path

If you moved or renamed the Excel file after setting up the mail merge, Word cannot locate it. The Refresh button appears to do nothing because Word cannot open the file. Reconnect the source using Method 1 and navigate to the new location.

Excel File Is Open in Another Program

Word cannot read a file that is locked by another process. Close Excel, any other Office program that has the file open, or any file viewer that keeps a handle on the file. Then refresh the recipient list again.

Data Was Added Below the Original Range

If you added rows below row 100 and the original connection captured rows 1 to 100, Word will not see the new rows. Use a named range in Excel that expands automatically. To create a dynamic named range, use the OFFSET function or format the data as an Excel table using Ctrl+T. Then reconnect the mail merge to the table name or the named range.

Word Cached the Old Data in the Document

In rare cases, Word stores a copy of the data inside the document. Close the mail merge document completely. Reopen it and refresh the recipient list immediately. If the problem persists, create a new mail merge document from scratch and connect it to the Excel file.

Excel Table vs Named Range: Mail Merge Data Source Behavior

Item	Excel Table (Ctrl+T)	Named Range (Fixed)
Expands automatically when rows are added	Yes	No, unless defined with OFFSET
Word sees new rows without reconnecting	Yes, after refresh	No, unless range was defined to include extra rows
Requires reconnection after structural changes	No, table name remains valid	Yes, if the range address changes
Best for	Data that grows or shrinks regularly	Static datasets with a fixed number of rows

You can now force Word to pull the latest Excel data by reconnecting the source or refreshing the recipient list. To prevent this problem from recurring, convert your Excel data range to a table using Ctrl+T and name it. Then reconnect your mail merge to that table name. As a final tip, always close the Excel file before running the mail merge to avoid file-locking errors.