File Sharing Problems

Fix Linked Excel Table Structure Not Updating in Word

Kushani NimanthikaKushani Nimanthika Oct 23, 2026 869 views

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.

How to Fix Linked Excel Table Structure Not Updating in Word
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.
Before you start

Ensure that your source Excel workbook is fully saved and closed before attempting to update or re-establish the link in your Word document.

Solution 1Recommended

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.

1
Open the Object Menu

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.

2
Create from File

In the Object dialog box, select the 'Create from File' tab.

3
Select and Link the Workbook

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.

Insert the Entire Excel Workbook as a Linked Object
Link Established: Your entire workbook is now linked. Future additions of rows and columns will appear when the link is updated.
WPS Office Solution

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. 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. 2. Use the Object Tool: Go to the 'Insert' tab on the top ribbon and click the 'Object' icon.
  3. 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.
Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Reliable synchronization of table structures between WPS Writer and WPS Spreadsheet.Free, lightweight, and features an intuitive tabbed interface for managing multiple files.
microsoft office alternative - wps office

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.