Insert link to Excel Worksheet into Word (Office 2000)

[Guest]

I have an Excel 2000 spreadsheet with 20 worksheets. My goal is to link one
or more of these worksheets in a Word document. In Word, I do
Inset|Object|From File and pick the Excel spreadsheet, but I have two issues
(1) The only way to specify which worksheet gets embedded is by saving the
Excel spreadsheet with with that worksheet up front and (2) When it embeds
into Word, some of the right-hand columns are missing, and it will only give
me one vertical page of the worksheet, so many rows are missing. Any help
would be most appreciated!
Mark

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?TWFyaw==?=,

I have an Excel 2000 spreadsheet with 20 worksheets. My goal is to link one
or more of these worksheets in a Word document. In Word, I do
Inset|Object|From File and pick the Excel spreadsheet, but I have two issues
(1) The only way to specify which worksheet gets embedded is by saving the
Excel spreadsheet with with that worksheet up front and (2) When it embeds
into Word, some of the right-hand columns are missing, and it will only give
me one vertical page of the worksheet, so many rows are missing.

When you use Insert/OBject, you're bringing in the worksheet as an OLE object.
Word can display only a limited amount of information in an OLE object. Word
2002 and 2003 are improved in this respect, in that they'll often reduce the
"zoom" by 50% in order to fit in more columns and rows. Nothing you can do
about this in Word 2000, though.

You might find it better to
- open the workbook in Excel
- select the cells
- Edit/Paste Special in Word and paste with a link

This will give you a number of file formats to choose from; default will
display the table as a Word table, meaning you should get all the rows and
columns.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail