Word with large Excel object, multiple pages?

Published by: jack 2009-01-09

I have a Word template that has an Excel object in it, to allow users to add many rows of data (instead of using a Word table).

This is working well, but now a user wants to add so much data that the object fills a whole page. Typically, the users add 5-10 files and the object stays on one page, sometimes pushing the bottom part of the document onto a second page. This user needs to add something like 50 files to the object though. When the object is stretched to try to show all 50 items, it fills the page (in Landscape mode) and cannot show the remaining 5 or so objects.

Software Download: Flow Charts Editor Source Code Visio Word Excel ::
Its Documentation Generator supports Visio,Word,Excel,PowerPoint and BMP. . maintaining full control over multiple file types including HTML, XHTML, XML,
http://www.sharewareconnection.com/titles/flow-charts-editor-source-code-visio-word-excel-powerpoint-c-c-java-basic-delphi-perl-php-pascal-vc-vb-c-vb-net-javascript-vbscript-asp.htmHOME

I cannot figure out how to get the object to spread across a page break.

The top of the object is at the top of the page. If I click on the middle handle at the bottom and drag down, the bottom of the object just disappears and does not show on the next page. I no longer have a bottom handle and no additional data is shown.

Breaker - Unprotect multiple Word and Excel documents. Split,merge ::
Breaker - Unprotect multiple Word and Excel documents. PDF Split-Merge is used to split files by pages, you can split the file into single pages or save
http://breaker.crystal-product.com/HOME

Jan's Access Forms & Reports: Printing & Sharing::
Jan 22, 2008 Reports often export to Word better than to Excel, but datasheets work better in Exported form (single page) and report (multiple pages)
http://www.jegsworks.com/Lessons/databases/formsreports/step-sharing.htmHOME

Can someome tell me how (or IF) I can do this?????

Thanks,
Larry

Yeah, I had kinda figured that, finally.

I don't have the option of moving this out of an Excel object, because I have a program that opens the Word document and reads fields from the document as well as data from the Excel object.

Instant Online Training for Microsoft Office & Other Software ::
Working with Tables that Span Multiple Pages Inserting an Excel Worksheet into a Word Document Chapter Fourteen: Creating Web Pages with Word
http://www.digitalliteracy.co.uk/Word-2003.htmlHOME

Copying Adobe Reader columns on multiple pages - Tech Support Guy ::
2 posts - Last post: Jan 1, 2005Copying Adobe Reader columns on multiple pages. I can use the column select tool to copy and paste a column from a pdf to an excel document,
http://forums.techguy.org/all-other-software/313301-copying-adobe-reader-columns-multiple.htmlHOME

What I had the user do, was copy the object and paste it right below itself, then modify the data in it so all the files show on the different pages.

Then I had to modify my code to read multiple Excel objects in the Word document, instead of the one.

Thanks for the reply, always glad to hear other suggestions.

An object will not break across pages in Word. Excel tend to break object across pages quite easily since the spreadsheet is really one unit.

The best way would be to Paste Special the Excel data in Word using either RTF or HTML. This will create a Word table that will closely (but not quite) resemble your Excel Spreadsheet.