File Sharing Problems

How to Change Embedded Excel Sources When Copying a Word Template

Phi Hung Vo Oct 21, 2026 868 views

Question details

The user needs to update the source paths of embedded or linked Excel tables when a Word template is moved, copied, or renamed.

How to Update Embedded Excel Sources When Copying a Word Template

Product: Microsoft Word
Device & OS: not provided
Scenario: Copying, renaming, or moving a Word template containing linked Excel tables to a different folder or sharing it with another user.
Observed behavior: Word retains the original absolute source paths of the embedded or linked Excel tables instead of automatically updating them to match the new template location, causing broken links.

Before you start

Before modifying link paths, ensure you know the exact file path of the new Excel source file. If you plan to implement a VBA macro, ensure your document is saved as a macro-enabled file format (.docm) to prevent code loss.

Solution 1Recommended

Manually Update the Linked Excel Source Paths

Use Word's built-in link management tool to redirect the embedded tables to the new Excel file location manually.

Since Word does not automatically update source links upon moving a template, the most straightforward approach for a small number of links is to update them via the Edit Links dialog.

Open the Link Manager

Open the copied Word template. Go to 'File' > 'Info', look at the bottom right corner, and click on 'Edit Links to Files'. Alternatively, you can right-click the linked table, select 'Linked Worksheet Object', and click 'Links'.

Select the Outdated Link

In the Links dialog box, locate and select the broken or outdated Excel link from the list of source files.

Change Source Path

Click the 'Change Source' button. A file browser window will appear. Navigate to the folder containing the new Excel file.

Confirm and Update

Select the new Excel file and click 'Open'. Back in the Links dialog, click 'Update Now' to refresh the data, and then click 'OK' to close.

Solution 2

Create a VBA Macro to Prompt for Source Updates

Use a VBA script to automatically prompt users to update link paths when a new document is created from the template.

Manage Document Links Seamlessly with WPS Office

WPS Office offers an intuitive and highly compatible interface for managing OLE links and embedded objects. If you need a reliable suite for complex document structuring involving linked spreadsheets, WPS Writer makes it easy to update data sources without hassle.

1. Open Your Document: Launch WPS Writer and open the document containing the linked tables.
2. Access Link Options: Click on 'Menu' in the top-left corner, go to 'Edit', and select 'Links' (or simply right-click the table and choose the Link options).
3. Update the Source: Select the outdated link, click 'Change Source', navigate to your new spreadsheet file, and click 'Update Now'.

Easily update OLE objects and linked Excel tables via a clear interface.Highly compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Free, lightweight, and fast alternative for daily document editing.Familiar UI reduces the learning curve for managing complex files.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my embedded Excel tables show an error when I move the Word template?

When you link an Excel table, Word saves the absolute file path to that spreadsheet (e.g., C:\Documents\Data.xlsx). If the template or the Excel file is moved to a new folder, the absolute path breaks, causing Word to be unable to locate and display the updated data.

Can Word use relative paths for linked Excel objects?

By default, Word uses absolute paths for linked OLE objects. While you can sometimes manipulate field codes to simulate relative paths, it is often unreliable and prone to breaking upon sharing. Using a VBA macro is the most robust workaround for dynamic pathing.

How do I unlink an Excel table to prevent it from updating?

To break the connection and convert the table to static text or a static image, go to File > Info > Edit Links to Files, select the linked Excel source, and click 'Break Link'. The data will remain in your Word document but will no longer attempt to reach the Excel file.

Document & File Issues