File Sharing Problems

Fix Word Linked Document Data Errors in an Excel Mail Merge

Adam DavisAdam Davis Nov 22, 2026 868 views

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.

Fix Word Linked Document Data Errors in an Excel Mail Merge
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the source template

In Word, select File > Open and open the document containing the original mail-merge template.

2
Open the postcard document

Keep the source template open, then use File > Open to open the separate document containing the postcards that reference it.

3
Check the data connection

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.

4
Reconnect Excel if needed

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.

5
Return to the postcards

Switch to the postcard document while leaving the source template open, then check whether its linked content and mail-merge data are available.

Keep the Source Word Document Open While Using the Postcard Document
Reported workaround: Keeping the first document open worked reliably in the reported setup, although the Excel data source sometimes needed to be reconnected. Online Repair did not resolve that case.
Free Microsoft Office alternative

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.

Open and edit Microsoft Word DOCX documents and Excel XLSX workbooksWork with mail-merge documents and spreadsheet data in one office suiteUse a familiar interface for everyday document and spreadsheet tasksMove common Office files to a free, lightweight alternative
QA img-9

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.