Fix Calculation Error in Record 1 During a Word Mail Merge
Question details
The user needs to diagnose a calculation error in the first record of a Word mail merge connected to Excel.

- 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.
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.
Test the Excel source without data validation
Use a test copy to check whether Excel data-validation rules are contributing to the error.
Open the source workbook in Excel and use File > Save As to save a copy for testing.
On the merge-data worksheet, select the cells used for recipient data. Go to Data > Data Validation, select Clear All, and click OK.
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.
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.

Check the first record, merge fields, and file access
Use these checks if removing validation does not resolve the error or if the document contains calculations.
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.

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.




