Problem with Pasting a Large Excel Worksheet to a Word Document

[Guest]

I have problem trying to paste a large Excel worksheet (cells range from A4 to AF83) into a Word document, it will only paste a small portion of the worksheet ! Can anyone help ?

 

[Cindy M -WordMVP-]

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

I have problem trying to paste a large Excel worksheet (cells range from

A4 to AF83) into a Word document, it will only paste a small portion of the
worksheet !Can you explain *exactly* which commands you're using to paste? And which
version of Word?

Just using Edit/Paste (orthe toolbar button, or Ctrl+V) shouldn't be cutting
off anything, so I suspect you're doing something else...

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

 

[Guest]

I selected all the cells from Excel and use Edit/copy from the menu bar and then switch to Word and use Edit/Paste from the menu bar to paste it into Word, but all it did was pasted about a quarter of the Excel sheet !

Versions are Word 2000 and Excel 2000

Thank you.

 

[Cindy M -WordMVP-]

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

I selected all the cells from Excel and use Edit/copy from the menu

bar and then switch to Word and use Edit/Paste from the menu bar to
paste it into Word, but all it did was pasted about a quarter of the
Excel sheet !!Ah, my eyes must be more rested today... From A4 to AF83? How many
columns is that? Word does have an upper limit to the number of columns
in a table. And in older versions of Word this was 32...

Which portion is being cut off? And again, which version of Word?

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

 

[Cindy M -WordMVP-]

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

OK, Word still has an upper limit for columns coming in from Excel in Word 2000. Word 2002 and
2003 have improved the situation quite a bit. The problem comes from Word figuring you can't
possible display more than n columns on a page, even if you know you could. It's an internal
thing.

One more thing you could try: in Excel, select the cells. Hold down the SHIFT key and click on
the Edit menu. You should get an entry "Copy as picture". Use that and see if it makes any
difference.

I've forgot to mention that I was actually trying to paste it as a picture in Word,

"Edit/Paste Special/Picture" as I do not want it as a table in Word.

I have just had another experiment. I numbered all the cells in Excel from cell A1 to BH70,

selected all the numbered cells, did Edit/Copy, switched to Word, and did Edit/Paste
Special/Picture, and it only pasted from A1 to AU66.

I have also tried to paste this into Microsoft PowerPoint using Edit/Paste and it only pasted from A1 to AO55.

I am using Word 2000 and PowerPoint 2000.

Would be grateful if you could find a solution to this as this is making my life very hard.

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

 

[Guest]

Tried your suggestion and got the same result and a message from the Office Assistant "The picture is too large and will be truncated" !!