Tech Support Forum banner

Word and Excel

2461 Views 3 Replies 3 Participants Last post by  Pseudocyber
I am looking for a way to display specific cell ranges from an excel spreadsheet in a word document. For example, the ranges for a pie chart and the table the chart is drawn from. 'Insert object' does not seem to have this capability. Can it be done somehow via scripting?

Thanks,
Nick D.
Status
Not open for further replies.
1 - 4 of 4 Posts
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.
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.
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.
This is for office xp:

Show All

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.



Embedded object

Linked object

Source file

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.
1 - 4 of 4 Posts
Status
Not open for further replies.
Top