Document Editing Problems

Fix Calculation Error in Record 1 During a Word Mail Merge

Maira MehtabMaira Mehtab Nov 13, 2026 870 views

Question details

The user needs to diagnose a calculation error in the first record of a Word mail merge connected to Excel.

Fix Calculation Error in Record 1 During a Word Mail Merge
Product
Microsoft Word and Microsoft Excel
Device & OS
not provided
Scenario
A Word document is merged with an Excel data source that may contain data-validation drop-down lists.
Observed behavior
The merge completes, but Word displays “Calculation error in record 1” and creates an additional file containing the error.
Before you start

Identify the Excel worksheet used as the merge data source and locate the additional file created during the merge. Note which row supplies the first recipient record so you can inspect its values and formulas.

Solution 1Recommended

Test the Excel source without data validation

Use a test copy to check whether Excel data-validation rules are contributing to the error.

1
Create a test source

Open the source workbook in Excel and use File > Save As to save a copy for testing.

2
Clear validation in the copy

On the merge-data worksheet, select the cells used for recipient data. Go to Data > Data Validation, select Clear All, and click OK.

3
Reconnect and test the merge

In Word, go to Mailings > Select Recipients > Use an Existing List and select the test workbook and merge-data worksheet. Run the merge again from Mailings > Finish & Merge.

4
Compare the results

Check whether the error dialog or additional error file appears. If the error stops, inspect the original workbook’s validation rules and list sources; if it continues, check the merge fields and data.

Test the Excel source without data validation
Moving lists may not remove validation: Placing list values on a separate worksheet does not itself remove validation rules from the merge-data cells. Clear the rules in the test copy to isolate this factor.
Free Microsoft Office alternative

Create Documents and Manage Merge Data with WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with documents and spreadsheets. Its Microsoft Office format compatibility helps you move existing files into WPS, though it does not fix a Microsoft Word-specific merge error.

Work with document content and spreadsheet data in one office suiteOpen and edit Microsoft Word DOCX and Excel XLSX filesUse a familiar interface to ease migration from Microsoft OfficeGet a free, lightweight alternative for everyday office work
microsoft office alternative - wps office

Frequently Asked Questions

Can Excel drop-down lists cause a Word mail merge calculation error?

Data-validation lists are one possible factor, but they are not a confirmed cause in every case. Test a copy of the workbook after clearing validation from the merge-data cells through Data > Data Validation > Clear All.

Will moving the drop-down list values to another worksheet fix the error?

Not necessarily. Moving the list values does not remove validation rules from the cells that use them. Test without those rules first, then review the list sources if the error stops.

What should I check in the first merge record?

In Excel, inspect the first recipient row for formula errors and unexpected values in number or date fields. In Word, use Mailings > Preview Results to check how those values appear in the document.

What should I provide if the error continues?

Capture the error dialog and keep the additional file produced during the merge. Share those along with the affected document and data source for diagnosis, after removing confidential information.