Discussion Locked

How to Embed Excel in Word -office 2000

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to insert an Excel 2000 spreadsheet into a Word 2000 document on Windows 2000 -new machines, plenty of space, 256 MG mem, everyone has Word and Excel on the workstation - docs and xls on server. While in Word doc, I select Insert/Object/Excelworkbook. If I do not select to display as an icon, the link is visible when merge fields are visible. Turn off merge fields to view as endusers will, most cases, nothing shows until mouse is moved over a corner where I click and sheet opens. Other cases the link is displayed, right click to open does open the spreadsheet but the spreadsheet will not print when printing the document. This worked fine with Win98.

Users would prefer if the spreadsheet was simply open when the document was opened.

I am creating the spreadsheet by selecting embedding an empty sheet then cut and paste an existing sheet. I have also tried creating an empty sheet and setting up the formulas directly without cutting and pasting.

Is there a way to insert a sheet that opens automatically upon opening the document and prints as part of the whole document?

7 replies

by dklippert

An easy way is to select the spreadsheet data. Copy and switch to Word.
Choose Edit>Paste Special
Use Microsoft Excel Worksheet object as the type then Past or Paste link.
Let me know if your situation is more complex.

by kees.valkenswaard

Did you try to insert an Excel worksheet, either by the Table+XL-button or by Insert, object, Excel worksheet? If you have already prepared your sheet before, just copy that part from Excel into the opened Excel sheet in Word.
As soon as you click somewhere else the worksheet will close.
With gridlines it is like with Word tables. The gray lines will not be printed. If you need back lines, make these in the Excel box in Word.
By the way. There is a problem if your Excel area would be bigger than one printing page [in Excel].
If this does not help you could send me by e-mail an example.
Do not forget to put also Q&A in the subject line.
Good luck.

by el machete

It is as simple as 123

1. First time open Excel and Word at the same time
2. Select the object (chart) in Excel
3. Go to Word and select the place where you want the chart to appear.
4. Under Edit select Paste Special and select as a link.
5.Close Excel
6. Save Word document. Now, every time you open this particular document The chart will be updated automatically if there any changes in the Excel chart.
7. If you rather not to have an automatic update from Excel go again under edit, click on links and then select the link and change it to manual update. You can also change the object link.

This discussion is closed to new replies.