Document Editing Problems

Automatically Update Word Text from Excel Data

Phi Hung VoPhi Hung Vo Nov 13, 2026 869 views

Question details

Link Excel values to a Word document so the document can reflect refreshed source data.

Automatically Update Word Text from Excel Data
Product
Microsoft Word and Microsoft Excel
Device & OS
not provided
Scenario
The user wants values in a Word document to update when the Excel workbook's data changes.
Observed behavior
Linked Word content should reflect the current Excel values after the source is refreshed and the link is updated.
Before you start

Save the Excel workbook in a location that Word can access, and identify the cells you want to link. Use desktop versions of Excel and Word, since link options can vary by version.

Solution 1Recommended

Link Excel cells to Word with Paste Special

Use Paste Link to insert content that remains connected to the source workbook.

1
Copy the source cells

In Excel, select the cells containing the values you need and choose Home > Copy.

2
Open Paste Special

In Word, place the cursor where the content should appear. On the Home tab, open the Paste menu and select Paste Special.

3
Create the link

Select Paste Link, choose an available format such as Microsoft Excel Worksheet Object or formatted text, and select OK.

4
Refresh the source

In Excel, choose Data > Refresh All if the workbook uses refreshable data, then save the workbook. In Word, right-click the linked content and select Update Link if it does not refresh.

Link Excel cells to Word with Paste Special
Keep the source accessible: Word needs access to the source workbook to update the link. Depending on Word's settings, you may also need to approve link updates when opening the document.
Free Microsoft Office alternative

Review Word documents and Excel data in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with documents and spreadsheets. Its Microsoft Office format support makes it easy to bring existing files into your workflow, although it does not repair links in Microsoft Word.

Review document content alongside spreadsheet values in WPS Writer and Spreadsheets.Open and edit Microsoft Word DOCX and Excel XLSX files.Use familiar document and spreadsheet editing tools.Move existing Office files into a lightweight, free office suite.
QA img-9

Frequently Asked Questions

Where is Paste Link in Word?

After copying cells in Excel, go to Home > Paste > Paste Special in Word. Select Paste Link, choose an available format, and select OK.

Why is my linked Word content showing old values?

Refresh the data in Excel using Data > Refresh All if applicable, verify the source cells, and save the workbook. Then right-click the linked content in Word and select Update Link.

What if Paste Link is unavailable?

Try copying the selected cells again from the desktop Excel app, then open Paste Special in desktop Word. Available link formats can vary by version and by what was copied.

What happens if I move or rename the Excel workbook?

Word may no longer find the source. If File > Info > Edit Links to Files is available, select the link and use Change Source to locate the workbook. Otherwise, create a new link from the workbook's current location.