When you update the source data in an Excel spreadsheet or a database, Word mail merge documents often fail to refresh calculated fields like totals, averages, or IF formulas. This happens because Word stores the last merged values in the document and does not automatically recalculate formulas when the source changes. This article explains why calculated fields remain static and provides three reliable methods to force Word to update them on every merge or after a data change.
Key Takeaways: Refreshing Calculated Fields in Word Mail Merge
- Ctrl+A then F9: Selects all merged fields and recalculates them after a data source update.
- Alt+F9 then Ctrl+A then F9: Toggles field code display, selects all fields, and updates them when nested formulas are involved.
- Mail Merge > Finish & Merge > Edit Individual Documents: Creates a fresh merged document that reads the latest source data and recalculates all fields.
Why Calculated Fields Do Not Update Automatically in Mail Merge
Word mail merge is not a live link to the source data. When you complete a merge, Word copies the current values from each source record into the document as static text. Calculated fields, such as those created with the = (Formula) field or nested inside an IF field, are evaluated only at the moment the merge runs. If you later change a number in the Excel source, the merged document still shows the old calculation result.
Word calculated fields use the = field code, which performs arithmetic on merge fields like { MERGEFIELD Sales }. For example, { = { MERGEFIELD Price } { MERGEFIELD Qty } } multiplies two fields. Word evaluates this formula once during the merge and stores the numeric result. Subsequent changes to the source data do not trigger a recalculation because the formula reference is not dynamic.
Another common cause is the Update Fields setting in Word. By default, Word does not update fields when opening a document unless you enable the option File > Options > Display > Update fields before printing. Even with that setting, calculated fields inside a mail merge document may not refresh until you manually force an update.
How to Force Word to Recalculate Mail Merge Fields After Source Data Changes
Use the method that matches your current workflow. Method 1 works when you already have the merged document open. Method 2 is best for documents with complex nested fields. Method 3 is the most reliable approach because it creates a fresh merge from scratch.
Method 1: Select All Fields and Press F9
- Open the merged document
Open the Word document that contains the mail merge results with the stale calculated fields. This can be the main mail merge document or the individual merged output. - Select the entire document
Press Ctrl+A to select all text and fields in the document. Word highlights the entire content. - Update all fields
Press F9. Word updates every selected field, including calculated fields that use the = field code. The formula re-evaluates using the current values from the linked source data. - Verify the recalculation
Check a few calculated values against the source data to confirm the update worked. If the values remain unchanged, the source data link may be broken. Reconnect the data source by going to Mailings > Select Recipients > Use an Existing List and re-selecting the file.
Method 2: Toggle Field Codes, Select All, Then Update
- Display field codes
Press Alt+F9. Word switches from showing field results to showing the underlying field codes, such as { = { MERGEFIELD Price } { MERGEFIELD Qty } }. - Select all content
Press Ctrl+A to select the entire document. This ensures every field code is included. - Update fields
Press F9. Word evaluates each selected field code using the current source data. - Return to field results
Press Alt+F9 again to toggle back to showing the calculated results. Check that the numbers have updated.
Method 3: Re-run the Mail Merge to Create a Fresh Document
- Open the main mail merge document
Open the .docx file that contains the mail merge fields and the linked data source. Do not open the previous merged output. - Refresh the data source
Go to Mailings > Edit Recipient List. Click Refresh to load the latest values from the source file. Click OK to close the dialog. - Complete the merge again
Click Finish & Merge > Edit Individual Documents. In the dialog, select All and click OK. Word creates a new document with recalculated fields based on the updated source data. - Save the new document
Save the newly created merged document with a different name to avoid overwriting the previous version. All calculated fields now reflect the current source data.
If Calculated Fields Still Do Not Update
Word Shows the Same Calculated Value After Pressing F9
The most common reason is that the field is locked. Select the field, right-click it, and check if Lock Field or Lock Result is enabled. If locked, right-click again and choose Unlock Field. Then press F9 to update.
Calculated Field Shows an Error Like !Unexpected End of Formula
This indicates a syntax problem in the field code. Press Alt+F9 to view the code. Ensure that every opening curly brace { has a matching closing brace }. Also check that merge field names inside the formula exactly match the column headers in the data source, with no extra spaces.
Source Data Changes Are Not Reflected in the Merge
Word may be using a cached copy of the data. In the mail merge main document, go to Mailings > Edit Recipient List and click Refresh. If the source file has been moved or renamed, click Use an Existing List and navigate to the correct file. After reconnecting, run the merge again using Method 3.
Manual Update vs Re-Merge: Which Method to Use
| Item | Select All + F9 (Method 1) | Re-run Merge (Method 3) |
|---|---|---|
| When to use | You already have the merged document open and only need a quick refresh | The source data changed significantly or fields are still stale after F9 |
| Data source link | Uses the existing link; may not refresh cached values | Forces a fresh read of the source file |
| Nested fields | Works for simple formulas; may miss nested fields if Alt+F9 is not used first | Recalculates all fields including nested ones |
| Document merging | No new document created; edits to the current document are preserved | Creates a new document; previous edits are lost |
You can now update stale calculated fields in Word mail merge documents by selecting all content and pressing F9, toggling field codes before updating, or re-running the entire merge. For the most reliable results, use Method 3 whenever the source data changes. As an advanced tip, consider using a DATABASE field instead of a standard merge field if you need live recalculation, though this requires more complex setup and is not supported in Word Online.