How do I insert a whole Excel workbook into a Word document?

[Guest]

When I try to insert a multi-sheet Excel workbook into a Word document (using
insert object), only one sheet is inserted. I am sure that I have inserted
multiple sheets before but, on this occasion, I can't remember how to do it.
Office Help does not provide an answer that works.

 

[Graham Mayor]

Objects cannot span pages. You'll have to insert it in sections.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Guest]

Thanks, Graham

My memory is obviously playing tricks (again!) as I was sure I had done it
before. I will have to print the workbook (62 pages) separately for binding
with the document.

 

[Peter Jamieson]

As Graham says, pasted /objects/ can't span more than one page in Word, but
if the number of columns in each sheet do not exceed the Word maximum of 63
columns you can Edit|Copy each sheet in Excel and Edit|Paste Special in e.g.
Formatted Text format in Word, you don't get an Object but a field with a
table result. Probably not what you wanted though, nor do I know a way to do
all the sheets at once.

Peter Jamieson