File Sharing Problems

Fix Excel to Word Links Not Updating on OneDrive

John WilsonJohn Wilson Oct 26, 2026 872 views

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.

How to Fix Excel Tables Linked to Word Files Not Updating on 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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Word document

Launch Microsoft Word and open the document containing the linked Excel table.

2
Select the table

Click anywhere inside the linked Excel table to select the entire object.

3
Force an update

Press the F9 key on your keyboard to force an immediate update of the linked data.

Alternative Method: You can also right-click the selected table and click 'Update Link' from the context menu to refresh the data.
Seamless Data Linking

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. 1. Copy spreadsheet data: Open your data table in WPS Spreadsheets and copy the desired cell range.
  2. 2. Prepare the document: Open your text document in WPS Writer and place your cursor where you want to insert the table.
  3. 3. Access Paste Special: Click the arrow under the 'Paste' icon on the Home tab and select 'Paste Special'.
  4. 4. Insert the link: Choose 'Paste Link', select 'WPS Spreadsheets Object', and click OK to establish a stable and updating link.
Free and lightweight alternative to Microsoft OfficeFully compatible with Microsoft Word (.docx) and Excel (.xlsx) formatsStable cross-document data linking for reportingIntegrated WPS Cloud for reliable and safe file syncing
microsoft office alternative - wps office

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.