Paste Link from Excel

[Guest]

I'm trying to paste link a range of cells from Excel into Word, these cells cover more than one page so when i paste them into Word the bottom of the range is missed off and a new sheet isn't created for the rest.
Is there a way to make Word create another sheet for ranges bigger than a page

Regard

Matt D

 

[Peter Hewett]

Hi Matt D

You can't insert any object into a Word document that spans more than a page.
You'll need to do two cut-and-pastes (or whatever you are doing), one for each
page.

HTH + Cheers - Peter

 

[Cindy M -WordMVP-]

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

I'm trying to paste link a range of cells from Excel into Word, these cells cover more than one page so when i paste them into Word the bottom of the range is missed off and a new sheet isn't created for the rest.
Is there a way to make Word create another sheet for ranges bigger than a page.

The only way you can do this as one link is to paste in RTF or HTML format. That will display the information as a Word table (with a link back to Excel), which can break across pages. Note, though, that you do have an upper limit of 64 columns.

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