File Format & Compatibility

How to Update Excel OLE Link Paths in Word Documents

Khadija KhanKhadija Khan Nov 3, 2026 869 views

Question details

The user needs to correct or update the file path of linked Excel data in a Word document, as Word fails to automatically reflect the new path after the source Excel file is renamed.

How to Update Excel OLE Link Paths in Word Documents
Product
Microsoft Word, Microsoft Excel
Device & OS
not provided
Scenario
A user saves an linked Excel template with a new name, but the associated Word document continues to display the original Excel file path in the 'Edit Links' dialog.
Observed behavior
Even though the OLE linked content correctly opens from the newly saved Excel file, the 'Edit Links' menu in Word persistently displays the old file path and does not automatically repath.
Before you start

Verify that both the Word document and the newly saved Excel file are accessible on your local drive, and copy the exact folder path of the new Excel file to your clipboard.

Solution 1Recommended

Use a VBA Macro to Force Update Link Paths

Since Word may not automatically repath the links, running a VBA macro is the most effective way to forcefully update all Excel OLE link sources in your document.

Microsoft Word sometimes struggles to automatically refresh the LinkFormat.SourceFullName property when an associated Excel file is saved under a new name. Using a Visual Basic for Applications (VBA) macro bypasses the user interface glitch and forcefully assigns the new path to all OLE fields.

1
Open the VBA Editor

Open your Word document and press Alt + F11 to launch the Microsoft Visual Basic for Applications window.

2
Insert a New Module

In the top menu, click 'Insert' and select 'Module' to create a blank script window.

3
Write the Update Script

You will need to write a script that iterates through 'ActiveDocument.Fields'. For each field where the type is 'wdFieldLink', update the 'LinkFormat.SourceFullName' property to match your new Excel file path.

4
Run the Macro

Press F5 or click the 'Run' button in the toolbar to execute the macro. Once finished, check your links to confirm the paths have been updated.

Use a VBA Macro to Force Update Link Paths
Community Support: If you are unfamiliar with writing VBA loops, you can post a request in the Microsoft Q&A community for help building the specific macro snippet for your file structure.
Free Microsoft Office alternative

Experience Seamless File Compatibility with WPS Office

If persistent Microsoft Office bugs like OLE link repathing failures are disrupting your workflow, consider switching to WPS Office. It is a powerful, lightweight, and free alternative that seamlessly handles standard Office file formats without the heavy system requirements.

  1. 1. Download and Install: Get the free WPS Office suite from the official website and install it in seconds.
  2. 2. Open Your Existing Files: Launch WPS Writer or WPS Spreadsheet and open your existing .docx and .xlsx files directly.
  3. 3. Enjoy Seamless Editing: Experience smooth editing, linking, and formatting without dealing with complex VBA macros.
Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Lightweight installation with incredibly fast software loading times.Familiar tabbed interface that requires zero learning curve.Built-in PDF editing and format conversion tools.
microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't Word automatically update the Excel link path when I use Save As?

When you use 'Save As' in Excel, the OLE object in Word retains the absolute path to the original file source. Word does not actively monitor external file renaming operations outside of its own environment, meaning the original link format remains statically coded until manually updated or forced via VBA.

How can I check all the active link paths in my Word document?

You can view all active link paths by navigating to File > Info > Edit Links to Files. Alternatively, you can press Alt + F9 in your Word document to reveal the field codes, which will display the exact file paths directly within the document text.

Will breaking the link delete my Excel data in Word?

No. If you select a link in the 'Edit Links' dialog and choose 'Break Link', Word will convert the previously linked Excel data into a static table or picture. The data currently visible will remain in the document, but it will no longer update if the source Excel file is modified.

What does OLE mean in Microsoft Office?

OLE stands for Object Linking and Embedding. It is a Microsoft technology that allows embedding and linking to documents and other objects. In this context, it allows an Excel spreadsheet to be linked inside a Word document so that changes in the spreadsheet can reflect in Word.