If you copy the cells in Excel and paste into word, they will most likely go in in cell form. The computer I'm working on does not have Excel so I can't test that.
I need to paste the charts and tables as linked objects. So that when the spreadsheet is updated, the objects in word are updated. I can insert an excel worksheet, but it picks an arbitrarily-sized window an you cannot control what parts of the spreadsheet show up in the window, or the size of the window.Fox said:If you copy the cells in Excel and paste into word, they will most likely go in in cell form. The computer I'm working on does not have Excel so I can't test that.
Insert information by creating a linked object or embedded object
You can create a linked object or embedded object from any program that supports linked objects and embedded objects.
Create a new embedded object
Click in the document where you want to place the embedded object.
On the Insert menu, click Object, and then click the Create New tab.
In the Object type box, click the type of object you want to create.
Only programs that are installed on your computer and that support linked objects and embedded objects appear in the Object type box.
To display the embedded object as an icon — for example, if others are going to view the document online — select the Display as icon check box.
Note You can also insert a Microsoft Excel worksheet as an embedded object by clicking Insert Microsoft Excel Worksheet on the Standard toolbar.
Create a linked object or embedded object with existing information
In a Microsoft Excel file
Open both the Microsoft Word document and the Microsoft Excel worksheet that contain 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, or the chart you want.
Click Copy .
Switch to the Word document, and then click where you want the information to appear.
To link or embed the object, do one of the following:
Create a linked object
Click Paste .
Place the insertion point on the Paste Options button near the copied object, and then click the arrow on the button to select an option to link the data.