Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Ulrik Loves Horses Ulrik Loves Horses is offline
external usenet poster
 
Posts: 2
Default Wrapping Embedded Excel Tables in Word

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
  #2   Report Post  
Posted to microsoft.public.word.tables
Pugalzhenthi.V Pugalzhenthi.V is offline
external usenet poster
 
Posts: 2
Default Wrapping Embedded Excel Tables in Word


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" wrote:

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

  #3   Report Post  
Posted to microsoft.public.word.tables
Ulrik Loves Horses Ulrik Loves Horses is offline
external usenet poster
 
Posts: 2
Default Wrapping Embedded Excel Tables in Word


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


"Pugalzhenthi.V" wrote:


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" wrote:

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

  #4   Report Post  
Posted to microsoft.public.word.tables
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Wrapping Embedded Excel Tables in Word

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

"Ulrik Loves Horses" wrote in
message ...
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


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem printing embedded Excel tables in Word ColG Tables 4 June 14th 07 01:18 PM
Problem with embedded Excel tables viewed as images MPG Tables 1 December 31st 05 02:37 PM
Text wrapping in Word 2003 Tables clairej Tables 7 September 7th 05 03:49 PM
Text Stops Wrapping around Tables and Moves the Tables - Mac Allen Tables 3 June 24th 05 03:30 PM
Macro to Convert All Embedded Excel Tables to Text Jeff Rush via OfficeKB.com Tables 1 March 27th 05 05:05 PM


All times are GMT +1. The time now is 02:25 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"