Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
How to get a long xls doc to flow on multiple Word pgs
Does anybody know how to get long excel table to generate multiple pages when
the object is imported into word. Opening single xls files/page is okay, but I have a problems with a 800 line table! |
#2
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
How to get a long xls doc to flow on multiple Word pgs
Ain't gonna happen if you insist on pasting/inserting it as an Excel Object
- OLE objects cannot span a page break. Copy the content in Excel & in Word you can then either; A) Paste to get a Word Table that will go on for as many pages as necessary, or B) Use Edit Paste Special - Unformatted Text to get a Tabular List. The only other option I know is to copy & paste one segment of the Excel file at a time as separate objects in the doc [not my favorite choice :-)]. HTH |:) Bob Jones [MVP] Office:Mac On 7/8/07 10:48 AM, in article , "Steve" wrote: Does anybody know how to get long excel table to generate multiple pages when the object is imported into word. Opening single xls files/page is okay, but I have a problems with a 800 line table! |
#3
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
How to get a long xls doc to flow on multiple Word pgs
Bob - thanks, went down the copy/paste route in the end and it worked well.
Just need to do it each time I update the excel doc. Steve "Steve" wrote: Does anybody know how to get long excel table to generate multiple pages when the object is imported into word. Opening single xls files/page is okay, but I have a problems with a 800 line table! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table over flow to multiple pages | Tables | |||
Using Hyperlinks in multiple long tables | Tables | |||
flow chart | Microsoft Word Help | |||
Flow Chart ? | Microsoft Word Help | |||
Flow charts | Microsoft Word Help |