Fix Word Linked Document Data Errors in an Excel Mail Merge
Question details
The user needs to prevent data-link errors when a Word document references another Word document that uses an Excel mail-merge data source.

- Product
- Microsoft Word and Microsoft Excel
- Device & OS
- not provided
- Scenario
- A postcard document references a separate Word mail-merge template linked to an Excel data source.
- Observed behavior
- Word displays link and data-source warnings when switching between documents, and the source document may become locked.
Locate the original Word mail-merge template, the postcard document, and the Excel workbook used as the data source. Make sure the workbook is accessible and identify the worksheet or table containing the recipient data.
Keep the Source Word Document Open While Using the Postcard Document
Use this arrangement to reduce linked-document warnings in the reported mail-merge setup.
In Word, select File > Open and open the document containing the original mail-merge template.
Keep the source template open, then use File > Open to open the separate document containing the postcards that reference it.
In the source template, select Mailings and check whether the Excel recipient data is available. If Word prompts you to locate the data source, select the correct workbook.
If the connection is missing, select Mailings > Select Recipients > Use an Existing List, choose the Excel workbook, and select the worksheet or table containing the recipient data.
Switch to the postcard document while leaving the source template open, then check whether its linked content and mail-merge data are available.

Work With Word and Excel Files in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface for opening and editing common Word and Excel files. Its format compatibility can make moving everyday documents and spreadsheets easier, though it does not fix Microsoft Word's linked-object error.

Frequently Asked Questions
Why should I keep the original Word document open?
In the reported setup, leaving the original mail-merge template open while using the postcard document made the linked-document arrangement work reliably.
How do I reconnect the Excel recipient list?
In the source Word document, select Mailings > Select Recipients > Use an Existing List. Choose the Excel workbook, then select the worksheet or table containing the recipient data.
Will Office Online Repair fix this linked-document error?
Online Repair did not resolve the reported case, so it should not be treated as a confirmed fix. Try keeping the source document open and reconnecting the Excel data source instead.
Should I end WINWORD.EXE if the source document is locked?
Ending WINWORD.EXE temporarily released the lock in the reported case, but it can close Word and discard unsaved work. Use the source-document workaround rather than relying on it as a routine fix.




