OneDrive File Issues

Fix Word Mail Merge Data Source Not Found After Moving to OneDrive

Khadija Khan Oct 10, 2026 868 views

Question details

Users are unable to locate or connect to their Excel data source for Word Mail Merge documents after moving their files from Google Drive to OneDrive.

Fix Word Mail Merge Data Source Not Found After Moving to OneDrive

Product: Microsoft Word, Microsoft Excel, OneDrive
Device & OS: not provided
Scenario: Migrating existing Mail Merge documents and their linked data sources to a new cloud storage environment.
Observed behavior: Word displays an error stating the Excel data source cannot be found when attempting to open or run the Mail Merge document.

Before you start

Ensure you have an active internet connection and that the OneDrive desktop client is running and properly signed into your account.

Solution 1Recommended

Keep Mail Merge Files Locally on Your Device

Forcing OneDrive to keep both the Word document and Excel data source stored locally resolves pathing issues caused by cloud-only file placeholders.

When OneDrive is set to 'Files On-Demand', it stores files in the cloud to save space. This prevents Word from accessing the physical file path required for the Mail Merge data source. Making the files available offline fixes this connection barrier.

Locate files in OneDrive

Open File Explorer and navigate to the OneDrive folder where your Word document and Excel data source are stored.

Select both files

Click the Word document, hold the Ctrl key, and click the Excel data source file to select them both simultaneously.

Mark as always keep on this device

Right-click the selected files and choose 'Always keep on this device' from the context menu.

Verify local download

Wait for the cloud status icons next to the files to change to solid green circles with a white checkmark, indicating they are fully downloaded.

Test the Mail Merge

Re-open the Word document and verify that it successfully connects to the data source without throwing the missing file error.

Keep Mail Merge Files Locally on Your Device

Troubleshooting Tip: If the original file still fails after downloading locally, try creating a brand-new test Mail Merge document using these local files to ensure your OneDrive synchronization is functioning correctly.

Solution 2

Relink the Data Source Manually

If the file paths changed fundamentally during the migration to OneDrive, you must manually point Word to the new location of the Excel file.

Seamless Mail Merge with WPS Office

Easily Create and Manage Mail Merge with WPS Office

WPS Office offers a robust and highly compatible Mail Merge feature that works seamlessly with local and cloud files. Avoid complex synchronization errors and handle your document merging effortlessly for free.

1. Open WPS Writer: Launch WPS Writer and navigate to the 'References' tab located on the top ribbon.
2. Activate Mail Merge: Click on 'Mail Merge' to activate the dedicated Mail Merge toolbar.
3. Connect Data Source: Click 'Open Data Source' and select your local or cloud-synced spreadsheet to link the data.
4. Merge and Output: Insert merge fields into your document and click 'Merge to New Document' to complete the process.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Reliable local and cloud file handling without complex sync path errors.Free and lightweight alternative to heavy office suites.Familiar user interface for a seamless migration.

microsoft office alternative - wps office

Frequently Asked Questions

Why does moving files to OneDrive break my Mail Merge?

OneDrive often uses virtual links or cloud-only placeholders to save hard drive space. If the Excel data source isn't physically downloaded to your local drive, Word cannot read the file path properly, resulting in a 'data source not found' error.

Do I need to relink the data source for every file I moved?

Yes, if the absolute file path changed when migrating from Google Drive to OneDrive, Word will continue looking for the old Google Drive path. You must manually relink the data source to the new OneDrive directory at least once and save the document.

How can I tell if my OneDrive files are stored locally?

In File Explorer, check the status icon next to your files. A solid green circle with a white checkmark means the file is always kept on your device, which is the required state for Mail Merge data sources to function correctly.

Can I use WPS Office to open my existing Word Mail Merge files?

Yes, WPS Office is highly compatible with Microsoft Office formats. You can open your existing .docx and .xlsx files in WPS Writer and easily relink the data source using the Mail Merge feature under the References tab.

Document & File Issues