As I mentioned before, embedded objects don’t automatically update. Linked objects, on the other hand, do.
And this can save you a lot of time.
Fortunately, linking an Excel object in Microsoft Word is easy.
Copy the table from the example workbook, and head back to Microsoft Word. Again, click Paste > Paste Special in the Home tab. Again, select Microsoft Excel Worksheet Object.
This time, however, you’ll need one more click. On the left side of the window, you’ll see two radio buttons. One says Paste, and the other says Paste Link. Click the button next to Paste Link:
After hitting OK, you’ll get another table in your Word document. This one looks the same as the previous one:
There’s an important difference, however. Let’s go back to Excel and change one of the values.
We’ll change May’s value from 9 to 10.
Here’s what happens: