Importing large Excel workbook into Word

[Guest]

I have a very large Excel workbook that I am trying to import into Word using
the link feature, which I can do to a certain extent. My problem is that
even though this workbook is more than 1 page, I am only getting 1 page in
Word, and losing the rest of the info. How do I get this into Word so that
there is more than one page?

 

[Cindy M.]

Hi =?Utf-8?B?SmVubg==?=,

I have a very large Excel workbook that I am trying to import into Word using
the link feature, which I can do to a certain extent. My problem is that
even though this workbook is more than 1 page, I am only getting 1 page in
Word, and losing the rest of the info. How do I get this into Word so that
there is more than one page?

Try opening the workbook in Excel. Select the entire table. Copy. Switch to Word
and use Insert/Paste Special. There you can activate the "link" option. The
default (HTML) will give you a Word-type table that can break across pages. If
you don't like the look of the result you can also try the RTF option.

The reason you have to use a Word-type table is that graphical objects can't
break across pages in Word.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail