Wrapping Embedded Excel Tables in Word

[Ulrik Loves Horses]

Have embedded Excel table inserted in Word.
However with a table of over 60 lines, it cuts off at the bottom in stead of
jumping to the next page.
What are the required settings to continue the rest of the table onto the
next page.
Found a solution by reducing the size; but that is not an option as the
data, when printed becomes too small.
Your help would be VERY appreciated.

Thx

 

[Pugalzhenthi.V]

hi

do the following
select the table -> Heading Rows Repeat
so, when the table heading continue all the pages

Regards,
Pugalzhenthi .V

 

[Ulrik Loves Horses]

We tried this but it was still cut in Word. So there must be something else
though.

 

[Peter Jamieson]

AFAIK embedded objects are always restricted to a single page.

The best you can probably do in this case is to maintain the spreadsheet
separately, then link to it in Word, and even that will only work with some
link formats. e.g.
a. In Excel, Select the content you want in your Word document and
Edit|Copy
b. In Word, Edit|Paste Special, select Paste Link, and choose (e.g.) RTF or
HTML format, but /not/ Microsoft Office Excel Worksheet Object, or you will
end up with the same problem as before.

The problem then is that you really need to maintain the data in the Excel
sheet (you can open it easily enough by right-clicking in the Linked data
and choosing Linked Worksheet Object|Open Link), and you will probably also
need either to break the link before you distribute a document that uses it,
or to distribute the Word and Excel files together (and even that may not be
enough).

Peter Jamieson