How to Keep Word Mail Merge Files Synchronized with OneDrive Excel Data
Question details
Users need to ensure that changes made to an Excel data source stored in OneDrive automatically reflect in their connected Word mail merge documents.
- Product
- Microsoft Word, Microsoft Excel, OneDrive
- Device & OS
- not provided
- Scenario
- A user updates an Excel spreadsheet saved in OneDrive that is currently acting as the data source for a Word mail merge.
- Observed behavior
- Word does not automatically recognize the changes made to the OneDrive Excel file. It continues to use the previously connected, outdated data source until the connection is manually refreshed or re-established.
Ensure that your updated Excel workbook is completely saved and closed in OneDrive before attempting to refresh the connection in Microsoft Word. Leaving the Excel file open can cause file lock errors that prevent synchronization.
Manually Reconnect the Updated Excel Data Source
Re-establishing the connection forces Microsoft Word to pull the latest updated data directly from your OneDrive Excel file.
Because Microsoft Word caches the data connection when a mail merge is first created, cloud-synced files on OneDrive do not push live updates to the document. You must prompt Word to fetch the new data by re-selecting the file.
Verify that all changes to your Excel data source are saved to OneDrive, and close the Excel application.
Launch Microsoft Word and open the main mail merge document that needs the updated data.
Navigate to the 'Mailings' tab on the ribbon at the top of the screen. Click on 'Select Recipients', then choose 'Use an Existing List' from the dropdown menu.
Browse to your synced OneDrive folder, select the updated Excel workbook, and click 'Open'. If prompted, select the correct sheet containing your data to finalize the refresh.
Refresh the Data Source via the Edit Recipient List
Use the built-in refresh button in the Mailings tab to quickly update the data without browsing for the file again.
Use a Local Copy of the Data Source
If OneDrive synchronization delays continuously disrupt your workflow, using a local copy of the spreadsheet offers a more stable mail merge connection.
Try WPS Office for Seamless Document Management
If you frequently encounter synchronization hurdles or connection quirks in Microsoft Office, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with intuitive Mail Merge features that work seamlessly with your local and cloud-based Excel files.
- 1. Install WPS Office: Download and install WPS Office for free on your PC or Mac.
- 2. Open Your Document: Open your existing .docx document in WPS Writer. Navigate to the 'References' tab to find the built-in 'Mail Merge' feature.
- 3. Connect Data Easily: Click 'Open Data Source' to quickly select your .xlsx spreadsheet, insert merge fields, and generate your merged documents without hassle.
Frequently Asked Questions
Why doesn't Word automatically update my mail merge data when I change the Excel file in OneDrive?
Microsoft Word caches the data connection when the merge is first established. Because OneDrive files are synced through the cloud, Word does not dynamically stream the live changes; it requires you to manually refresh or reconnect the data source to fetch the latest updates.
Does this sync issue happen if my Excel file is saved locally instead of on OneDrive?
Local files generally update more reliably. If you save the Excel file locally, Word can often pick up the changes immediately upon reopening the document or by simply hitting the refresh button, avoiding the delays associated with cloud syncing.
Will saving a copy of the Word document fix the mail merge connection?
Saving a copy of the Word document itself won't pull in new data. You must ensure the Excel data source is fully synced in OneDrive and then re-establish the link using the 'Select Recipients' or 'Edit Recipient List' option in Word.
Why am I getting a 'file in use' error when trying to sync the OneDrive Excel file in Word?
This happens if the Excel file is still open either on your device or in Excel Online. To fix this, make sure you completely close the Excel file and allow OneDrive a few seconds to finish syncing before you attempt to refresh the connection in Word.
