Fix Linked Excel Table Structure Not Updating in Word
Question details
A linked Excel table in a Word document updates cell values but fails to reflect structural changes such as added or removed rows and columns.

- Product
- Word, Excel
- Device & OS
- not provided
- Scenario
- A user links an Excel spreadsheet into a Word document expecting both data and table structure modifications to synchronize automatically.
- Observed behavior
- Cell values update correctly upon refreshing, but structural changes made in the source Excel file do not reflect in the Word document.
Ensure that your source Excel workbook is fully saved and closed before attempting to update or re-establish the link in your Word document.
Insert the Entire Excel Workbook as a Linked Object
Instead of copy-pasting a specific cell range, insert the entire file as an object. This ensures all structural changes are synchronized.
When you copy and paste a range as a linked table, Word anchors to that specific cell block (e.g., A1:D10). By linking the entire file, Word updates the object representation dynamically.
Open your Word document, place your cursor where you want the table to appear, and navigate to the Insert tab. Click on 'Object' in the Text group.
In the Object dialog box, select the 'Create from File' tab.
Click 'Browse' to locate and select your Excel workbook. Check the box that says 'Link to file', and then click 'OK' to insert the linked object.

Manually Refresh the Linked Object
If structural changes have been made to an existing file-level linked object but are not displaying, you may need to force a manual refresh.
Seamlessly Link Spreadsheets to Documents with WPS Office
WPS Office provides robust Object Linking and Embedding (OLE) capabilities, allowing you to easily embed and synchronize spreadsheet data within your documents without losing structural formatting.
- 1. Position Your Cursor in WPS Writer: Open your document in WPS Writer and place the cursor exactly where the spreadsheet should be inserted.
- 2. Use the Object Tool: Go to the 'Insert' tab on the top ribbon and click the 'Object' icon.
- 3. Link Your WPS Spreadsheet: Choose 'Create from file', browse for your spreadsheet file, check 'Link to file', and click 'OK' to insert a structurally dynamic table.

Frequently Asked Questions
Why does copy-pasting a linked table not update rows or columns?
When you copy and paste a range as a linked table, it creates an OLE link to a specific static range of cells (for example, A1:D10). If you add rows or columns outside this exact range in Excel, Word will not expand the view to display them.
How do I force my Word document to update all links at once?
You can quickly update all links in your document by pressing Ctrl + A to select the entire document text, and then pressing F9. This refreshes all linked objects and fields simultaneously.
Does linking an Excel file increase the Word document size?
No, linking actually keeps the Word document file size relatively small. The data remains stored in the external Excel file and is only referenced by Word. Embedding the object, however, would store a full copy within Word and increase the file size.




