Fix Broken Links in Word Documents with Embedded Excel
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.

- 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.
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.
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.
In Microsoft Word, click on the 'File' menu, select 'Options', and then navigate to the 'Advanced' tab on the left panel.
Scroll down to the 'General' section and check the box next to 'Update automatic links at open'. Click 'OK' to save your settings.
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.

Store Related Files in Cloud Storage
Store both the Word template and the linked Excel worksheet in SharePoint Online or OneDrive to mitigate local absolute path dependencies.
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. Download and Install: Visit the official WPS Office website to download and install the free suite on your device.
- 2. Open Your Office Files: Launch WPS Office and open your existing .docx and .xlsx files without losing any formatting.
- 3. Manage Data Easily: Use the all-in-one tabbed workspace to easily copy, paste, and manage data between your text documents and spreadsheets.

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.




