[paulsdc]

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
Word MVP web site http://word.mvps.org


paulsdc wrote:
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.

[paulsdc]

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.

"Graham Mayor" wrote:

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


paulsdc wrote:
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.

[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

"paulsdc" wrote in message
...
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.

"Graham Mayor" wrote:

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


paulsdc wrote:
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.