Excel 2003 Workbook into Word 2003

[Guest]

If I go into Word, and choose Insert/Object/Create From File, Browse, and
find my existing Excel Workbook, only the first Worksheet is inserted into my
Word document.

If I go into Word, and choose Insert/File, and find my Excel Workbook, I get
pages of garbage.

Are both of these behaviours normal for Excel and Word 2003? Is there any
way I can insert a Workbook (with multiple Worksheets) into a Word document
as separate pages?

I did end up selecting the area in each Excel Worksheet within the Workbook,
holding down the SHFT key down and choosing Edit/Copy Picture and pasting
into Word, but I'm curious to see if there's an easier way to get the entire
workbook in a Word document in one fell swoop.

Thanks.

Brenda

 

[Guest]

I just tried it out and got a multi-tab workbook to show up in Word 2003.

Here's what I did:

1) Insert--Object

2) Select "Create from File" tab

3) Navigate to the .xls document

4) Click OK.

Is that what you're looking for?

Dave

 

[Guest]

Yes, that's what I mean, but if I do the same thing, I only get the first tab
.... I don't get any of the others.

 

[Guest]

Double click on your embedded Excel object and then select the tab you want
to display.

 

[Guest]

Thank you very much! I was NOT aware that you could access the other sheets
(which will actually be quite helpful in future situations, unfortunately not
in this one).

What I was looking for was a way to import an entire workbook, but have each
worksheet import onto a different page.

I think the Edit/Copy picture will have to do for this instance.

Thanks again for the very quick reply!

Brenda