Automatically Update Word Text from Excel Data
Question details
Link Excel values to a Word document so the document can reflect refreshed source 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.
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.
Link Excel cells to Word with Paste Special
Use Paste Link to insert content that remains connected to the source workbook.
In Excel, select the cells containing the values you need and choose Home > Copy.
In Word, place the cursor where the content should appear. On the Home tab, open the Paste menu and select Paste Special.
Select Paste Link, choose an available format such as Microsoft Excel Worksheet Object or formatted text, and select OK.
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.

Check and repair a Word-to-Excel link
Use these checks if Paste Link is unavailable or the linked content does not update.
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.

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.




