OneDrive File Issues

Fix Excel to Word Paste Special Links Breaking in OneDrive

Phi Hung Vo Oct 1, 2026 874 views

Question details

User needs to resolve an issue where Paste Special links between Excel and Word break after saving and reopening the files in OneDrive.

Fix Excel to Word Paste Special Links Breaking After OneDrive Reopening

Product: Microsoft Word, Microsoft Excel, OneDrive
Device & OS: not provided
Scenario: Pasting linked Microsoft Excel Worksheet Objects into a Word document and storing both files on OneDrive.
Observed behavior: The linked objects work initially but fail and break after both files are closed and reopened from OneDrive. Local files do not exhibit this issue.

Before you start

Ensure you have the desktop version of the OneDrive sync client installed and logged in, as this issue primarily stems from web-based URL pathing.

Solution 1Recommended

Recreate Links Using the Local OneDrive Sync Folder

Syncing files locally ensures stable file paths, preventing the web-based URL pathing issues that often break OLE links between Office apps.

When files are saved directly to OneDrive, Office often uses HTTPS web addresses for links. By forcing the files to stay local, you ensure the Paste Special links use standard directory paths (e.g., C:\Users\...).

Make files available locally

Open your local OneDrive folder via File Explorer. Right-click both the Excel and Word files (or their containing folder) and select 'Always keep on this device'.

Copy the Excel data

Open the locally synced Excel file, highlight the cells or charts you want to link, and press Ctrl+C to copy them.

Paste as a link in Word

Open the locally synced Word document. Navigate to the 'Home' tab, click the arrow under 'Paste', select 'Paste Special', check the 'Paste link' radio button, and choose 'Microsoft Excel Worksheet Object'.

Save and sync

Save both documents. Let the OneDrive client automatically sync the changes to the cloud in the background.

Recreate Links Using the Local OneDrive Sync Folder

Link Stability: Using the local sync path prevents the links from breaking because the file address remains consistent every time you reopen the document.

Solution 2

Update Broken Links Manually in Word

If the links are already broken after reopening, you can manually redirect the source path to the local synced file instead of recreating the object.

Free Microsoft Office alternative

Switch to WPS Office for Seamless Document Management

If complex OneDrive syncing and Microsoft Office OLE linking issues are interrupting your workflow, try WPS Office. It provides a highly compatible alternative for handling Word and Excel files, offering robust local and cloud document management without the subscription fees.

1. Download WPS Office: Get the free installer from the official WPS website and complete the lightweight installation.
2. Open your existing files: Open your .docx and .xlsx files directly in WPS Office. No format conversion is required.
3. Enjoy seamless linking: Copy data from WPS Spreadsheet and use Paste Special into WPS Writer with reliable local file stability.

Fully compatible with Microsoft Excel (.xlsx) and Word (.docx) formats.Reliable linking between spreadsheets and documents without complex web-pathing errors.Free, lightweight, and features a familiar user interface for immediate productivity.Built-in WPS Cloud ensures secure and seamless synchronization across devices.

microsoft office alternative - wps office

Frequently Asked Questions

Why do Paste Special links break when saved to OneDrive?

OneDrive often replaces local file paths (like C:\Users\...) with web-based URLs (like https://d.docs.live.net/...). The Office 'Paste Special' link feature struggles to resolve these dynamic web URLs upon reopening, causing the connection to fail.

How can I view and manage all broken links in Word?

You can manage links by opening your Word document, navigating to File > Info, and clicking on 'Edit Links to Files' at the bottom right. This menu allows you to update, break, or manually change the source path of your linked objects.

Does using 'Always keep on this device' fix the linking issue permanently?

Yes, in most cases. By forcing OneDrive to keep a local copy stored on your hard drive, Word and Excel can use standard local directory paths, preventing the confusion and breakage caused by cloud-based URLs.

Document & File Issues