How do i link a cell in excel to a word doc and keep they live

Question

I have reviewed an answer to another users question, but cannot get this to work. I am trying to use a speadsheet to keep track of student payments for a class trip. I would like to create a word doc for each student that will automatically update as the students pay towards the trip.

I looked at an answer to a similar question from 2021 but when i tried it it did not work.

thanks

Answer 1

Hi @Timothy Mangiaracina,

Here are the steps to link any part of an Excel worksheet in a Word document:

1. Open the Word document where the worksheet will display.
2. Open the Excel worksheet that contains the data you want to link to the Word document.
3. In Excel, select and copy the range of cells to include. Select the entire worksheet if you plan to insert more columns or rows into the worksheet.
4. In the Word document, position the cursor where you want to insert the linked table.
5. Right-click and select Link & Use Destination Styles or Link & Keep Source Formatting.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.