You want to insert an object as a link so that it will update.
Open both the Microsoft Word document and the Microsoft Excel worksheet
that contains the data you want to create a linked object or embedded
object from.
Switch to Microsoft Excel, and then select the entire worksheet, a
range of cells (cell: A box formed by the intersection of a row and
column in a worksheet or a table, in which you enter information.), or
the chart you want.
Click Copy .
Switch to the Word document, and then click where you want the
information to appear.
On the Edit menu, click Paste Special.
To link or embed the object, do one of the following:
To create a linked object, click Paste link.
In the As box, click the entry with the word "object" in its name. For
example, click Microsoft Excel Worksheet Object.
Note If you link data from a worksheet and select the Keep Source
Formatting and Link to Excel option, the linked data will match the
formatting in the Excel source file (source file: The file that
contains information that was used to create a linked or embedded
object. When you update the information in the source file, you can
also update the linked object in the destination file.).
If you select the Match Destination Table Style and Link to Excel
option, the linked data will be formatted in the Word default table
style.
With either option you can change the formatting of the linked object
in the Word document. Formatting changes you make will remain when the
data is updated in the source file.
