Excel table link in word (INCLUDETEXT or LINK)

R

Ralf Weber

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
 
C

Cindy M -WordMVP-

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
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?
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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top