If I have a word doc in which I want to lik#nk an excell file this is OK.
But where the data in the Excell file is to be included as a appendix, I
have a problem. The listy on dat on the excell work sheet is more than the
size of 1 word page. I cannot find a way to llink to the excell file and
let the word doc include all the data where it rolls past one page. If the
data is 10 pages worth, how can I insert the data,(which is linked and can
be updated in the excell file) and still add 10 pages to the word doc for
all the data.
At the moment I cant see a way to do this.
Any sugegsts gratefully recieved.
macropod - 21 Sep 2003 11:56 GMT
Hi,
Try selecting & copying just the area you need for the 2nd
page, then copying and pasting that into Word as a link.
Cheers
PS: Remove NO.SPAM from the above before replying.
>-----Original Message-----
>If I have a word doc in which I want to lik#nk an excell file this is OK.
[quoted text clipped - 11 lines]
>
>.
Cindy Meister -WordMVP- - 21 Sep 2003 14:10 GMT
Hi Totaltom,
> But where the data in the Excell file is to be included as a appendix, I
> have a problem. The listy on dat on the excell work sheet is more than the
> size of 1 word page. I cannot find a way to llink to the excell file and
> let the word doc include all the data where it rolls past one page.
Copy in Excel.
In Word: Edit/Paste special. Choose either the HTML or RTF format, and
activate the LINK option.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan 24 2003)
http://www.mvps.org/word
This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)