Office Apps Freezing

Fix Word 2016 Freezing When Selecting an Excel Mail Merge Source

John WilsonJohn Wilson Nov 20, 2026 869 views

Question details

The user needs to connect an Excel worksheet as a mail merge data source without Word 2016 freezing.

Fix Word 2016 Freezing When Selecting an Excel Mail Merge Source
Product
Microsoft Word 2016 and Microsoft Excel
Device & OS
Windows (version not provided)
Scenario
Selecting an Excel workbook as a mail merge recipient list in Word using a DDE connection.
Observed behavior
Word may stop responding when the Excel source is selected, and the data source confirmation setting may become unchecked after updates or application failures.
Before you start

Locate the Excel workbook you want to use and confirm which worksheet contains the recipient list. In Word, check whether the option to confirm file format conversion on open is enabled so you can choose a connection method.

Solution 1Recommended

Connect the Excel mail merge source using OLE DB

Use OLE DB instead of DDE when Word freezes while opening the Excel recipient list.

1
Enable connection confirmation

In Word, go to File > Options > Advanced. Under General, select Confirm file format conversion on open, then click OK.

2
Select the Excel workbook

Open the merge document and go to Mailings > Select Recipients > Use an Existing List. Browse to the Excel workbook and click Open.

3
Choose OLE DB

In the Confirm Data Source dialog, select OLE DB Database Files. If it is not visible, select Show All, then choose OLE DB Database Files and click OK.

4
Select the worksheet

In the table selection dialog, choose the worksheet containing the recipient list and click OK. Use Mailings > Edit Recipient List to check that the records appear.

Connect the Excel mail merge source using OLE DB
Check the confirmation setting again: If the Confirm Data Source dialog does not appear, revisit File > Options > Advanced > General and make sure Confirm file format conversion on open is still selected.
Free Microsoft Office alternative

Use WPS Office for Documents and Mail Merge Data

WPS Office is a free, lightweight alternative with a familiar interface for working with Word documents and Excel spreadsheets. Open compatible files in WPS to help make the move from Microsoft Office straightforward; it does not repair Word's DDE connection.

Work with Word-compatible DOCX documents and Excel-compatible XLSX spreadsheetsPrepare recipient data in spreadsheets for document workflowsUse familiar document and spreadsheet tools in a lightweight suiteGet started for free and move existing Office files into WPS
microsoft office alternative - wps office

Frequently Asked Questions

Why does Word 2016 freeze when I select an Excel mail merge source?

The DDE connection may be involved in the hang. Try selecting OLE DB Database Files in the Confirm Data Source dialog instead. If Word still freezes, check updates and Reliability Monitor for more information.

Where is OLE DB Database Files in the Confirm Data Source dialog?

After choosing the workbook through Mailings > Select Recipients > Use an Existing List, select Show All in the Confirm Data Source dialog to display additional connection methods, including OLE DB Database Files.

What if the Confirm Data Source dialog does not appear?

Go to File > Options > Advanced in Word. Under General, select Confirm file format conversion on open, click OK, and select the Excel workbook again.

How can I check whether Word stopped responding?

Search Windows for View reliability history, open it, and select the date of the freeze. Look for a WINWORD.EXE event, such as an AppHangB1 report.