I have no idea what the mechanics of the "form" are, but you are right that
an object - picture, embedded or linked file, etc. - cannot span a page
break in a doc. The Excel data needs to be brought in as Formatted Text
(RTF) which will generate a Word table. Tables can span multiple pages.
Another option might be to have 2 separate objects created - each on a
separate page & each containing only a portion of the data. Don't know if
your process can accommodate that or not.
Regards |:)
Bob Jones
[MVP] Office:Mac
On 8/17/07 11:30 PM, in article
, "Techno Grandma"
wrote:
I have a form that brings in data from an excel worksheet. I want to have
the excel worksheet insertion split and go on two pages if there is not
enough room on the first word page. Now if I add any lines to the
spreadsheet, which is variable and sometimes can go 2 the table will not
split over the pages. Do I have to do this somehow in Word or in the Excel
document?