File Format & Compatibility

Fix Broken Links in Word Documents with Embedded Excel

Bushra ParveenBushra Parveen Nov 4, 2026 870 views

Question details

Users experience broken links between a Word document and a linked Excel worksheet when the files are renamed or moved to different folders.

How to Fix Broken Links in Word Documents with Embedded Excel
Product
Microsoft Word and Excel
Device & OS
not provided
Scenario
Renaming or relocating completed Word documents and their associated Excel data source files to new directories.
Observed behavior
The links between the Word document and the Excel worksheet fail to update or break entirely because they depend on the original absolute file paths.
Before you start

Verify whether your Excel worksheet is actually embedded (stored within the Word document itself) or linked (referencing an external file path), as moving an embedded file will not break its data.

Solution 1Recommended

Enable Automatic Link Updating and Verify Object Paths

Adjust Word's advanced settings to ensure that automatic links are updated when the document opens, and manually verify the source path of the linked object.

By default, Microsoft Word may not automatically refresh linked data from external Excel files when paths change slightly. Enabling the automatic update setting ensures Word attempts to fetch the latest data upon opening.

1
Open Advanced Options

In Microsoft Word, click on the 'File' menu, select 'Options', and then navigate to the 'Advanced' tab on the left panel.

2
Enable Automatic Links

Scroll down to the 'General' section and check the box next to 'Update automatic links at open'. Click 'OK' to save your settings.

3
Check Linked Object Path

Right-click the broken Excel object in your document, select 'Linked Worksheet Object', and choose 'Links' to verify or modify the absolute path to point to the new file location.

Enable Automatic Link Updating and Verify Object Paths
Absolute vs. Relative Paths: Word generally uses absolute paths. If you move documents frequently, consider using macros to convert fields to relative paths.
Free Microsoft Office alternative

Try WPS Office for Seamless Document Management

If you frequently encounter complex linking and file path issues in Microsoft Office, consider switching to WPS Office. It provides a lightweight, highly compatible, and user-friendly alternative for managing interconnected documents and spreadsheets.

  1. 1. Download and Install: Visit the official WPS Office website to download and install the free suite on your device.
  2. 2. Open Your Office Files: Launch WPS Office and open your existing .docx and .xlsx files without losing any formatting.
  3. 3. Manage Data Easily: Use the all-in-one tabbed workspace to easily copy, paste, and manage data between your text documents and spreadsheets.
Fully compatible with Microsoft Word and Excel formats (.docx, .xlsx)Lightweight installation with faster document loading timesAll-in-one tabbed interface for managing Writer and Spreadsheet files simultaneouslyFree to use for everyday document creation, editing, and linking
microsoft office alternative - wps office

Frequently Asked Questions

What is the difference between linking and embedding an Excel file in Word?

A linked object relies on an external Excel file; if that source file is moved or renamed, the link breaks. An embedded object creates a static, independent copy of the Excel data entirely inside the Word document, increasing the file size but preventing broken links.

Why do my Excel links break when I email the Word document to someone else?

When you email a Word document containing linked Excel objects, the recipient does not have access to the original absolute file path on your local hard drive. To share these files, you must either embed the data or send both files in a zipped folder while instructing the recipient to update the link paths.

How do I manually update a broken Excel link in my Word document?

Go to 'File' > 'Info', look for 'Edit Links to Files' in the bottom right corner (this option only appears if the document contains links). In the dialog box, select the broken link and click 'Change Source' to navigate to the new location of your Excel file.