SharePoint Document Issues

Fix Word Mail Merge Not Updating Excel Data in SharePoint

Algirdas JasaitisAlgirdas Jasaitis Nov 14, 2026 869 views

Question details

Update a Word mail merge using an Excel recipient list stored in SharePoint.

Fix Word Mail Merge Not Updating Excel Data in SharePoint
Product
Microsoft Word, Excel, and SharePoint
Device & OS
not provided
Scenario
A mail merge document and its Excel data source are uploaded to a SharePoint library.
Observed behavior
The merge updates from the local Excel file but does not refresh from the SharePoint-hosted list.
Before you start

Confirm that you can access the SharePoint library and that OneDrive sync is available on your computer. Check which Excel workbook and worksheet contain the current recipient list.

Solution 1Recommended

Sync the SharePoint library and reconnect the Excel data source

Use a synchronized local folder when a SharePoint web path prevents Word from refreshing the merge data.

1
Sync the library

Open the SharePoint document library in your browser and select Sync. Follow the OneDrive prompts to add the library to your computer.

2
Open the local Word file

Open the synchronized library folder on your computer, locate the mail merge document, and open it in desktop Word.

3
Reconnect the recipient list

In Word, select Mailings > Select Recipients > Use an Existing List. Browse to the Excel workbook in the synchronized folder, select it, and choose the worksheet containing the recipient data.

4
Check and save the merge

Select Mailings > Edit Recipient List or Preview Results to check the data, then save the Word document. Ensure OneDrive has finished syncing any changes.

Sync the SharePoint library and reconnect the Excel data source
Use desktop Word: Word for the web may not support all mail merge features. If the Excel list changes later, allow OneDrive to sync the workbook before reopening or checking the merge in desktop Word.
Free Microsoft Office alternative

Edit Word Documents and Excel Lists with WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with Office documents and spreadsheets. Its Microsoft Office format compatibility helps you move existing files into WPS, although it does not fix Word's SharePoint data connection.

Edit recipient lists and documents in one office suiteCompatible with Microsoft Word and Excel formats, including DOCX and XLSXFamiliar editing interface for an easier transition from Microsoft OfficeFree and lightweight tools for everyday document work
microsoft office alternative - wps office

Frequently Asked Questions

Why does my mail merge work locally but not from SharePoint?

The SharePoint web path may prevent Word from updating its connection to the Excel workbook. Sync the library with OneDrive, then reconnect the workbook through Mailings > Select Recipients > Use an Existing List in desktop Word.

How do I check whether Word is using the right Excel list?

In desktop Word, select Mailings > Edit Recipient List to inspect the recipients. If the data is incorrect, use Mailings > Select Recipients > Use an Existing List and select the correct workbook and worksheet from the synchronized folder.

Can I refresh the merge in Word for the web?

Word for the web may not support all desktop mail merge features. Open the synchronized document in desktop Word to reconnect the Excel data source and check the merge.

What should I do after someone updates the Excel list in SharePoint?

Allow OneDrive to sync the updated workbook to your computer, then reopen or check the merge in desktop Word using Mailings > Edit Recipient List or Preview Results.