Document Editing Problems

How to Change the Source of a Linked Excel Object in Word

John Wilson Oct 1, 2026 869 views

Question details

The user needs to change the source of a linked Excel worksheet object in Word without the link defaulting to the entire worksheet instead of a specific cell.

How to Change the Source of a Linked Excel Object in Word

Product: Microsoft Word
Device & OS: not provided
Scenario: Changing the source file of a linked Excel object inside a Word document when the files are stored in a shared OneDrive for Business folder.
Observed behavior: When updating the link source, the OLE link loses the specific cell reference and instead points to the entire Excel worksheet.

Before you start

Verify whether your Word and Excel files are stored locally on your hard drive or in a shared cloud folder like OneDrive for Business, as cloud synchronization can affect how OLE links resolve cell references.

Solution 1Recommended

Manually Recreate the Link from the New Excel Workbook

Since changing the source directly in OneDrive may break the cell reference, manually recreating the link using Paste Special is the most reliable workaround.

This workaround bypasses the 'Change Source' dialog bug that occurs in shared OneDrive environments by establishing a completely fresh OLE link to the new target workbook.

Copy the new source data

Open the second Excel workbook, select the specific cell or range of cells you want to link, and press Ctrl+C to copy the data.

Paste as a linked object in Word

Open your Word document, place your cursor where the new data should appear, click the arrow under 'Paste' on the Home tab, and select 'Paste Special'. Choose 'Paste link' and select 'Microsoft Excel Worksheet Object'.

Break the previous link

Right-click the old linked Excel object, navigate to 'Linked Workbook Object' > 'Links', select the old link in the dialog box, and click 'Break Link'.

Remove old cell values

Once the old link is broken, the previous Excel object becomes a static image or table. Manually delete this old object from your Word document.

Manually Recreate the Link from the New Excel Workbook

Workaround Successful: By creating a fresh link, Word will accurately maintain the connection to the specific cell range instead of defaulting to the entire worksheet.

Solution 2

Move Files to Local Storage Before Changing Source

The linking issue is specific to files stored in shared OneDrive folders. Moving them locally allows the native 'Change Source' feature to work correctly.

Free Microsoft Office alternative

Edit Word and Excel Files Seamlessly with WPS Office

If you frequently encounter complex OLE linking and cloud sync bugs in Microsoft Office, consider trying WPS Office. It provides a lightweight, highly compatible alternative for handling text documents and spreadsheets without the frustration of broken links in shared folders.

1. Download and install: Visit the official WPS website to download and install WPS Office for free.
2. Open your documents: Launch WPS Office and open your existing Word and Excel files directly without worrying about format conversion.
3. Edit seamlessly: Copy, paste, and edit your spreadsheet data inside your text documents smoothly using the unified interface.

Free to download with a lightweight, fast installation processExcellent compatibility with Microsoft Office formats including .docx and .xlsxStable and predictable handling of cross-document elements and tablesIntuitive tabbed interface to manage multiple documents and spreadsheets in one window

microsoft office alternative - wps office

Frequently Asked Questions

Why does my linked Excel object show the whole workbook instead of a specific cell?

This is a known issue when changing link sources for files stored in cloud environments like OneDrive for Business. Word loses the specific cell reference during the update process and defaults to displaying the entire worksheet.

How do I access the Links dialog box in Microsoft Word?

You can manage links by right-clicking the linked Excel object in your document, selecting 'Linked Workbook Object' from the context menu, and then clicking 'Links'. This opens a dialog box where you can update, break, or change link sources.

Can I break a link to an Excel object without deleting the data in Word?

Yes. When you break a link via the Links dialog box in Word, the currently displayed Excel data is converted into a static picture or table. This preserves the visual data in your document while completely removing the connection to the external Excel file.

Document & File Issues