Office Apps Freezing

Fix Word Mail Merge Freezing with Large Excel Workbooks

WPS Content Manager Sep 25, 2026 870 views

Question details

The user is experiencing severe lag and freezing in Word during the Finish & Merge step when using a large Excel workbook as the data source.

How to Fix Word Mail Merge Freezing with Large Excel Workbooks

Product: Microsoft Word
Device & OS: not provided
Scenario: Performing a mail merge using prepopulated Word templates linked to a complex Excel database containing formulas, hyperlinks, and linked files.
Observed behavior: The mail merge process becomes extremely slow and stops responding completely at the Finish & Merge stage, regardless of whether it is accessed through a VPN or the local office network.

Before you start

Ensure your computer has sufficient memory available by closing any unneeded background applications to allocate maximum system resources to the mail merge process.

Solution 1Recommended

Simplify and Optimize the Excel Data Source

Reduce the complexity of the Excel workbook to prevent memory overloads during the merge process.

Large workbooks with complex formulas, hyperlinks, and external data connections require substantial processing power. Stripping these elements out of the data source often resolves the freezing issue.

Create a copy of the workbook

Locate your original Excel workbook in File Explorer, copy it, and paste it to create a safe duplicate for editing.

Remove unnecessary data

Open the copied workbook and delete any worksheets, columns, or rows that are not strictly required for the mail merge.

Convert formulas to values

Select all the data, copy it, and right-click to paste it as 'Values' (using the 123 paste icon) to remove heavy calculations and external linked files.

Test the mail merge

Open your Word template, go to the Mailings tab, click 'Select Recipients', link to this new simplified Excel file, and attempt the 'Finish & Merge' process again.

Optimization Tip: Saving the simplified Excel file in the older .xls format or as a CSV (Comma Separated Values) file can sometimes further improve merge speeds.

Solution 2

Recreate the Mail Merge Main Document

Start fresh with a newly connected document to clear any corrupted background links or cached connections.

Solution 3

Repair Microsoft Office and Verify Network Settings

Use the built-in repair tool to fix software glitches and rule out network access issues.

Perform Smooth Mail Merges with WPS Office

If your current word processor continues to freeze when handling large datasets, try WPS Office. WPS Writer features a highly optimized Mail Merge function that easily processes large Excel files, complex tables, and heavy data sources without freezing or lagging.

1. Open your template: Launch WPS Writer and open your existing prepopulated Word template (.docx).
2. Access Mail Merge: Navigate to the 'References' tab on the top ribbon and click on 'Mail Merge'.
3. Connect your large workbook: Click 'Open Data Source' and select your large Excel workbook (.xlsx) to establish the connection instantly.
4. Execute the merge: Click 'Merge to New Document' or 'Merge to Printer' to process your large dataset smoothly and without freezing.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formatsLightweight engine optimized for large datasets and complex worksheetsFamiliar user interface for seamless and quick migrationCompletely free to download and use

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Word mail merge freeze specifically at 'Finish & Merge'?

The 'Finish & Merge' step is when the word processor actively pulls and processes all the data from the connected source to generate the final pages. If the connected Excel workbook contains complex formulas, numerous worksheets, or external file links, the sudden spike in memory usage can overwhelm the software, causing it to freeze.

Can I speed up a mail merge with a large Excel file?

Yes. The most effective way to speed up the process is to copy the raw data you need from your Excel workbook and paste it as 'Values' into a new, simplified spreadsheet. Using this simplified file as your data source eliminates calculation lag during the merge.

Does saving the Word template as a new file fix mail merge freezing?

Often, yes. The background data links between the template and the data source can become corrupted or bogged down by cached data. By creating a new document, reconnecting the Excel data source via the Mailings tab, and saving it as a new file, you force the application to establish a clean, uncorrupted connection.

Office App Problems