Document Editing Problems

Link Excel Named Ranges and Tables to a Word Document

Elise WilliamsElise Williams Nov 22, 2026 868 views

Question details

The user wants to link multiple Excel tables to a Word report and update the report when the data or table size changes.

Link Excel Named Ranges and Tables to a Word Document
Product
Microsoft Excel and Microsoft Word
Device & OS
not provided
Scenario
A report contains several tables maintained in an Excel workbook, and the user wants to avoid resizing embedded worksheet windows.
Observed behavior
Word's Paste Link options reference the selected cell addresses even when the Excel table is selected by name.
Before you start

Save the Excel workbook and Word report, and make sure the workbook will remain accessible at its saved location. In Excel, check each name under Formulas > Name Manager; for an expanding table, use a distinct defined name that refers to the table's range.

Solution 1Recommended

Link each Excel table through a defined name

Use Paste Link to create each Word link, then inspect its field code and replace a fixed cell reference with the appropriate Excel defined name.

A linked object reads from the source workbook; it is different from an embedded worksheet stored in the Word document. Paste Link may initially record a fixed cell address even if you selected the range by name.

A defined name that refers to an Excel table can expand with that table. Whether Word accepts and displays the named range as expected depends on the link type and Office version, so test each link after editing it.

1
Define the source range

In Excel, select Formulas > Name Manager > New. Create a workbook-scoped name such as ReportTableRange that is distinct from the table name. For a table named Table1, set Refers to to =Table1[#All] if you want the headers and all table rows included.

2
Copy the range

Use the Excel Name Box or Name Manager to select the defined range, then copy it with Ctrl+C. Repeat the process separately for each table you want in the report.

3
Paste a link in Word

Place the cursor in the Word report and choose Home > Paste > Paste Special. Select Paste Link, choose a suitable format, such as Microsoft Excel Worksheet Object, and select OK.

4
Inspect and edit the field

In Word for Windows, press Alt+F9 to show field codes. In the LINK field, replace only the source item containing the fixed address, such as Sheet1!R1C1:R10C10, with the defined name, such as ReportTableRange. Leave the workbook path and other field switches unchanged, then press Alt+F9 again.

5
Update and test

In Word, select the linked content and press F9 to update it. Add a row to the Excel table, save the workbook, and update the link again to check whether the new row appears. Repeat for the other tables.

Link each Excel table through a defined name
Check the result after a size change: A named range can track an expanding table, but Word may not automatically resize or render every linked format as intended. If the named link fails or the display is unsuitable, try another Paste Special format or recreate the link.
Free Microsoft Office alternative

Work with Reports and Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for editing reports and spreadsheets. It supports common Microsoft Office formats for easier migration, although it does not fix Word's LINK fields or guarantee the same linked-range behavior.

Edit Word reports and Excel source spreadsheets in one office suiteOpen and save common Microsoft Word and Excel formats, including DOCX and XLSXUse a familiar interface to ease the move from Microsoft OfficeWork with a free, lightweight office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Why does Word show cell addresses instead of my Excel range name?

Paste Link may store the selected cells as a fixed address even when you selected them by name. In Word for Windows, press Alt+F9 to inspect the LINK field and replace the source address with the defined name, then update and test the link.

How can I make a named range expand with an Excel table?

In Excel, open Formulas > Name Manager and create a distinct defined name whose Refers to formula points to the table, such as =Table1[#All]. Add a row and check the name's selection before testing the link in Word.

How do I refresh linked Excel content in Word?

Select the linked content in Word and press F9. To update fields throughout the document in Word for Windows, press Ctrl+A and then F9. Save changes in the source workbook first.

Will the linked table automatically resize in Word when Excel rows are added?

An expanding defined name can include the new rows, but the Word display may not resize as expected for every linked format. Add a test row, save the workbook, and update the Word link to check the result.

What happens if I move or rename the Excel workbook?

The Word link may no longer find its source because it stores a workbook path. Keep the source accessible, or use Word's link-management options to change the source or recreate the link.