Fix Excel to Word Links Not Updating on OneDrive
Question details
The user needs to maintain active, updating links between an Excel table pasted into a Word document when both files are stored and accessed via OneDrive.

- Product
- Microsoft Word and Excel
- Device & OS
- not provided
- Scenario
- Pasting and linking an Excel table into a Word document that is saved and synchronized through OneDrive.
- Observed behavior
- The linked Excel table stops updating automatically after both the Word and Excel files are closed and reopened.
Ensure that both the Excel and Word files are fully synced to OneDrive without any pending upload errors, and verify that neither file has been moved or renamed.
Manually Update the Linked Excel Table in Word
If automatic updates fail after reopening the document, you can force the link to refresh manually to fetch the latest data.
Due to how OneDrive handles file paths, automatic background updates for linked OLE objects can sometimes be suspended. A manual refresh forces Word to reach out to the source file and pull the newest values.
Launch Microsoft Word and open the document containing the linked Excel table.
Click anywhere inside the linked Excel table to select the entire object.
Press the F9 key on your keyboard to force an immediate update of the linked data.
Recreate the Link in a New Document
Sometimes the internal link path gets corrupted by cloud synchronization. Recreating the link can restore functionality.
Repair or Update Microsoft Office
If links persistently break across multiple files, your Office installation might require a repair or an update to resolve underlying OLE communication bugs.
Link Spreadsheet Data to Text Documents Reliably in WPS Office
WPS Office allows you to link spreadsheet tables directly into your text documents with stable connections. Use WPS Spreadsheets and WPS Writer to keep your data perfectly synced without worrying about complex cloud path errors.
- 1. Copy spreadsheet data: Open your data table in WPS Spreadsheets and copy the desired cell range.
- 2. Prepare the document: Open your text document in WPS Writer and place your cursor where you want to insert the table.
- 3. Access Paste Special: Click the arrow under the 'Paste' icon on the Home tab and select 'Paste Special'.
- 4. Insert the link: Choose 'Paste Link', select 'WPS Spreadsheets Object', and click OK to establish a stable and updating link.

Frequently Asked Questions
Why do my Excel to Word links break when saving to OneDrive?
OneDrive often changes local file paths to HTTPS web URLs for syncing purposes. Microsoft Word sometimes struggles to resolve these web-based paths for OLE (Object Linking and Embedding) links, causing the connection to break upon reopening the files.
Is there a way to force Word to update all links at once when opening?
Yes. Go to File > Options > Advanced in Word. Scroll down to the 'General' section and check the box for 'Update automatic links at open'. This prompts Word to refresh all linked objects when you launch the document.
Can I use relative paths for linked objects in Word?
By default, Word uses absolute paths for linked Excel tables. If files are synced across different OneDrive environments, the absolute path may break. Keeping both files in the exact same folder can sometimes simulate relative path stability, but Office does not natively support true relative OLE linking out of the box.




