Embedded 'Excel' Object in WORD - wont display more than one page

K

kylieand

I am embedding excel objects into WORD and I have come across a spreadsheet
which is larger than the others and contains about 100 rows. It imports
fine, however it will only display the data on ONE page. It does not seem to
display more than 50 rows and the rest of the data is simply cut off. It
wont display it over multiple pages. When you double click on the object it
opens up and shows all the 100 rows.
I have tried adding page breaks and section breaks but it does not seem to
matter. Do you have any suggestions as to how I can get this object spread
over multiple pages without converting the excel into 2 separate
spreadsheets/objects ?
 
D

Doug Robbins

An object cannot span more than one page.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
 
M

macropod

Hi Kylie,

An object cannot span more than one page. So, to have more than one page
from your excel workbook, copy each Excel page separately and paste into
Word using Edit|Paste Special. Note that if you check the 'paste link'
option, the Excel spreadsheet in your Word document can be made to update
when the Excel file does.

Alternatively, select & copy the existing embedded Worksheet, paste it to a
new location, double click on it to open it, scroll down (in Excel) to where
you want the next page to start, then click back into the Word document.

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top