Prevent a Linked Excel Table from Resizing in Word After Updating the Link
Question details
The user needs to keep a linked Excel table in Microsoft Word at a fixed size when the link is refreshed.
- Product
- Microsoft Word and Microsoft Excel
- Device & OS
- not provided
- Scenario
- A linked Excel table is inserted into a Word document, and the user updates the link to reflect changes in the source Excel file.
- Observed behavior
- The linked table reverts to its original oversized dimensions every time the link is updated, despite manually resizing it in Word.
Confirm whether the table was inserted as a linked Excel object through Paste Special, and locate the source Excel worksheet so you can adjust the original range if needed.
Resize the source Excel range before linking
Use this method when you must keep the live link and want Word to use the same compact dimensions as the source worksheet.
Microsoft Word remembers the original size of a linked Excel object and may reapply that size when the link is refreshed. Setting the source range to the intended layout gives Word a smaller, predictable object size.
In Excel, open the workbook that contains the linked data and select only the cells you want to appear in Word.
Set column widths and row heights to match the finished table size, and remove extra blank columns or rows around the selected range.
Copy the range, switch to Word, click Home > Paste > Paste Special, choose Paste Link as a Microsoft Excel Worksheet Object, and insert the compact object.
Paste Excel data as a static table
Use this solution if you do not need live updates and want the table size to remain exactly where you set it.
Use a linked picture instead of a linked table object
Use this method when the table can be displayed as an image but still needs to update when the source changes.
Keep Linked Excel Tables Stable in WPS Writer
Because this resizing behavior is tied to Microsoft Word's linked object refresh, WPS Office provides a free, lightweight alternative that opens Word and Excel files with familiar formatting and compatible file support.
- 1. Download WPS Office: Download and install WPS Office from the official WPS website, then open WPS Writer.
- 2. Open the Word document: In WPS Writer, click Menu > Open and select the .docx file containing your linked Excel table.
- 3. Verify and adjust the linked table: Click the linked table or object, update the link, resize it as needed, and save the document to keep the layout.
Frequently Asked Questions
Why does a linked Excel table return to its original size in Word?
Word treats a linked Excel object with the dimensions of the source range, so refreshing the link can reapply those original dimensions even if you have manually resized the object in Word.
Can I keep live updates without the table resizing?
Yes, use Paste Link as a picture instead of a Microsoft Excel Worksheet Object, or resize the source Excel range before linking so Word receives a smaller starting size.
How do I paste an Excel table into Word without a link?
Copy the Excel range, then in Word click Home > Paste > Paste Special and choose HTML Format or Formatted Text (RTF) without selecting Paste Link. This creates a static table.
Does WPS Writer support Word documents with linked Excel tables?
WPS Writer can open and save .docx files and work with linked Office content, providing a free alternative when Microsoft Word behaves unpredictably with linked objects.
