How to Fix Excel-to-Word Linked Tables That Break After Reopening
Question details
The user needs to restore updating for Excel tables linked into a Word document that break after reopening, even though the source workbook has not moved.
- Product
- WPS Office Writer and WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A Word document contains linked tables from an Excel workbook. After closing and reopening the document, the links no longer update or appear broken.
- Observed behavior
- Linked Excel tables stop updating or show broken links after reopening the Word document, despite the source workbook remaining in the same location.
Make sure the source Excel workbook is saved in a stable, accessible location and that you know its exact file path. Open the Word document in WPS Office Writer and be prepared to use the Link Manager to inspect the existing links.
Reconnect the Existing Excel Link in WPS Office Writer
Use this to point the linked table back to the current Excel workbook when the source path is still valid but the link stops updating.
Broken links in Word are usually caused by a changed file path, a renamed workbook, or link update settings that are blocked by file locking, group policy, or registry configuration. Reconnecting the link restores live updates without converting the table to static text.
Start WPS Office Writer, click File > Open, and select the Word document that contains the broken Excel table link.
Click the linked Excel table in the document to select it, or click anywhere inside the table so the link is active.
Right-click the linked table and choose Linked Spreadsheet Object > Links. If this option is not shown, go to File > Info and click Edit Links to Files.
In the Links dialog, select the listed Excel source, click Change Source, browse to the current .xlsx workbook, and select it.
Click Update Now to refresh the table with the Excel data, then save the Word document to keep the reconnected link.
Break the Link and Keep the Table as Static Content
Use this if the document is shared outside your network or the source location is unstable and the table does not need live updates.
Fix Broken Excel-to-Word Links in WPS Office Writer
Open your existing Word document in WPS Office Writer, use Link Manager to reconnect or break the Excel link, and continue working with the original .docx formatting while WPS Office keeps the source .xlsx data compatible.
- 1. Install and open WPS Office: Download and install WPS Office, then open Writer and load the Word document that has the broken Excel table link.
- 2. Open the link manager: Select the linked table, right-click and choose Linked Spreadsheet Object > Links, or use File > Info > Edit Links to Files.
- 3. Reconnect or break the link: Choose Change Source to select the current Excel workbook and click Update Now, or choose Break Link to keep the last values as static content.
- 4. Save the document: Save the file as a Word document. The linked table will now update from the selected Excel workbook or remain as fixed content, depending on your choice.
Frequently Asked Questions
Why does a linked Excel table break after I reopen the Word document?
The link usually breaks because the saved source path no longer matches the workbook location, the file is locked by another process, or link updating is blocked by an Office or registry policy. Open the Links dialog in WPS Office Writer to check the current source path.
How do I open the Links dialog in WPS Office Writer?
Select the linked table, right-click it, and choose Linked Spreadsheet Object > Links. You can also go to File > Info and click Edit Links to Files if the right-click option is unavailable.
Can I update the link if the Excel source file is on a network drive?
Yes, as long as the network location is accessible from your device and does not require a disconnected mapped drive. In the Link Manager, choose Change Source and browse to the current full network path.
What should I do if the source workbook has not moved but the link still says broken?
First reconnect the link manually and click Update Now. If it breaks again, ask your IT team to check file-locking, group policy, or link update registry settings, because administrative access may be required.
How can I stop a linked Excel table from breaking when I share the Word document?
Open the Links dialog, select the Excel source, and click Break Link. The last imported table values remain in the Word document and no longer try to update from Excel, preventing broken-link messages.
