File Sharing Problems

Fix Excel to Word OLE Link Breaks After Moving Files

Ayan MasoodAyan Masood Nov 2, 2026 868 views

Question details

The user needs to prevent or fix OLE links breaking between an Excel worksheet and a Word document when transferring both files to a different computer.

How to Fix Excel to Word OLE Link Breaks After Moving Files
Product
Word, Excel
Device & OS
not provided
Scenario
Sharing or moving linked Office documents to a different computer or user.
Observed behavior
The OLE link fails, and Word displays an error message stating that the linked object is unavailable.
Before you start

Before fixing the links, ensure that both the Word document and the Excel worksheet are saved in their final intended location to avoid having to update the links multiple times.

Solution 1Recommended

Store Files in a Shared Network Folder or Cloud Library

Using a stable, centralized path prevents OLE links from breaking when accessed by different users or devices.

OLE links rely on absolute file paths. When you move files to a local drive on a different computer, the file path changes (e.g., C:\Users\Name\...), causing the link to break. Storing files on a shared network drive or SharePoint ensures the path remains identical for everyone.

1
Move files to a shared location

Copy both your Word document and the linked Excel worksheet to a shared network drive, OneDrive, or a SharePoint library.

2
Re-establish the OLE link

Open the Excel file from the shared location, select and copy the desired cells. Then open the Word document, right-click where you want the data, select 'Paste Special', choose 'Paste link', and select 'Microsoft Excel Worksheet Object'.

Store Files in a Shared Network Folder or Cloud Library
Stable Paths: As long as users have access to the shared folder, the OLE link will update dynamically without breaking.
Seamless Office Document Management

Manage Linked Documents Efficiently with WPS Office

WPS Office provides robust support for OLE linking between spreadsheets and documents. Its built-in cloud sync features make it easier to maintain stable file paths across different devices, preventing broken links when sharing files.

  1. 1. Save to WPS Cloud: Upload both your spreadsheet and document to WPS Cloud to ensure a uniform file path across devices.
  2. 2. Copy Spreadsheet Data: Open the WPS Spreadsheet, highlight the data range you want to link, and press Ctrl+C to copy.
  3. 3. Paste Link in WPS Writer: Open your document in WPS Writer, click the 'Paste' dropdown arrow on the Home tab, and select 'Paste Special'.
  4. 4. Select Paste Link: Choose 'Paste Link' and select 'WPS Spreadsheets Object' to create a dynamic, cloud-synced link.
Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formatsBuilt-in WPS Cloud ensures stable file paths across all your devicesLightweight, fast, and completely free for basic use
microsoft office alternative - wps office

Frequently Asked Questions

Why do OLE links break when I email linked files to someone else?

Emailing files creates local copies in the recipient's temporary or download folders, which changes the absolute file paths. This path mismatch breaks the link connecting the two documents.

Can I use relative paths for OLE links in Word?

By default, Word uses absolute paths for OLE links. While some advanced field codes can be manually tweaked for relative paths, the most reliable and user-friendly method is keeping files in a shared network or cloud location.

How do I find out which Excel file my Word document is linked to?

In Word, go to 'File' > 'Info' and click 'Edit Links to Files'. This will display a list of all linked objects and their current expected file paths so you know exactly which file is missing.