File Sharing Problems

How to Fix Broken Excel-to-Word Links in OneDrive for Business

Phi Hung Vo Oct 15, 2026 869 views

Question details

The user needs to maintain functional links between Excel spreadsheets and Word documents when both files are stored in OneDrive for Business.

How to Keep Excel-to-Word Links Working in OneDrive for Business

Product: Microsoft Word and Excel
Device & OS: not provided
Scenario: Storing and reopening linked Word and Excel files synchronized through OneDrive for Business.
Observed behavior: Embedded Excel links inside Word documents become corrupted or break after reopening because OneDrive sets the source files to online-only or changes their local paths.

Before you start

Make sure your OneDrive for Business desktop client is actively running and you are signed into the correct Microsoft account on your computer.

Solution 1Recommended

Keep Files Locally Synced on Your Device

Forcing OneDrive to keep files on your local hard drive prevents the system from removing the local file path that Word uses to locate the linked Excel data.

When OneDrive's 'Files On-Demand' feature is active, it may free up space by moving files to the cloud. This removes the local version of the Excel file, causing Word to lose the link path.

Open File Explorer

Navigate to the specific OneDrive for Business folder where your Word and Excel files are stored.

Set Word Document to Always Keep

Right-click the Word document and select 'Always keep on this device'. A solid green checkmark icon will appear next to it.

Set Excel File to Always Keep

Right-click the associated Excel workbook and also select 'Always keep on this device' to ensure both files maintain stable local paths.

Keep Files Locally Synced on Your Device

Consistent File Paths: Keeping both files locally downloaded ensures Word can always find the Excel source file using the absolute file path on your hard drive.

Solution 2

Recreate and Manage Document Links

If links are already broken, recreating them using Paste Special and configuring link update settings will restore functionality.

Free Microsoft Office alternative

Experience Reliable Document Linking with WPS Office

If OneDrive synchronization constantly breaks your file links in Microsoft Office, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with a unified workspace, ensuring stable file references between documents and spreadsheets without complex cloud-syncing errors.

1. Download and Install: Download WPS Office for free from the official website and install it on your device.
2. Open Your Files: Open your existing .docx and .xlsx files directly within the WPS Office unified workspace.
3. Create Stable Links: Copy your data from WPS Spreadsheet and use Paste Special > Paste Link in your WPS Document to establish a reliable connection.

Seamlessly link spreadsheet data into text documents with highly stable local references.Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx).Unified, tabbed interface lets you manage Word, Excel, and PDF files in one window.Lightweight installation and free to use for everyday productivity.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Word say 'Error! Not a valid link' when opening my document?

This error occurs when Word cannot locate the source Excel file. In OneDrive for Business, this typically happens if the Excel file was offloaded to cloud-only storage, which removes the local file path Word expects to find.

How can I stop Word from automatically trying to update links?

You can change link update settings manually. In Word, navigate to File > Info > Edit Links to Files, select the links you want to modify, and change their update method from Automatic to Manual.

Will links break if I share the OneDrive folder with a colleague?

Yes, they often will. Absolute links use your specific local user path (e.g., C:\Users\YourName\OneDrive). When your colleague opens the file, their computer uses a different user path, causing the links to break unless you use relative linking or a shared network drive.

Document & File Issues