Excel table link in word (INCLUDETEXT or LINK)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ralf Weber - 22 Apr 2004 15:41 GMT

hi,

i want to include an excel table into a word document by linking it
via INCLUDETEXT or LINK. the excel table i have extends over several
pages, to get the column headers for each page i used >>page
setup/sheet/rows to repeat at top<< in excel. after i link this into
word with INCLUDETEXT the column headers are not repeated on every new
page. is there a way i can do this.
also the excel table extends the page width in word, is there a way i
can tailor this, so it's automatically the right size in word?

thanx in advance for any help
ralf

Reply to this Message

Cindy M -WordMVP- - 22 Apr 2004 18:53 GMT

Hi Ralf,

> i want to include an excel table into a word document by linking it
> via INCLUDETEXT or LINK. the excel table i have extends over several
[quoted text clipped - 4 lines]
> also the excel table extends the page width in word, is there a way i
> can tailor this, so it's automatically the right size in word?

1. Which version of Office are we dealing with?

2. If you use IncludeText, you *might* be able to get the repeating
headers and retain column widths by adding the \* MergeFormat switch at
the end of the field.

3. If you use a LINK field with the \p switch you can certainly retain
the Excel stuff, but then you'd need to break the table down into
"page-sized" chunks.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
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 :-)

Reply to this Message