Paste Special from Excel

[Fredrik Eide Nilsen]

Hi!

I've been trying to figure this one out for a couple of days but so
far without luck. Maybe someone here has an explanation:

I have an Excel spreadsheet with lots of data. I want to copy the data
and paste it into a Word-document. This is going to be the backside of
a report and I want to paste it as a picture (Edit -> Paste special ->
Picture).

If I use Office 2000 the lower 1/3 of the data is cut off when I paste
it. The same thing happens with Office XP and 2003 but in these
versions I can choose Paste special -> Picture (Enhanced metafile) and
then it works fine. If I choose Enhanced metafile in Office 2000, it's
still cut off.

I have tried changing the paper size, margin sizes etc. but it makes
no difference.

 

[garfield-n-odie]

There is a limit to how much you can paste as a picture or metafile from
Excel into Word. The selected Excel range cannot be shrunk to less than
69% of its original size in Word. If the selected range must be smaller
than 69% of original to fit in the Word page, then the range is shrunk
to 69% and any extra columns or rows are truncated. Sometimes you can
get around this limitation by copying and pasting the Excel range in
several pieces, and then maybe resizing the pasted pieces in Word.

 

[Fredrik E. Nilsen]

There is a limit to how much you can paste as a picture or metafile from
Excel into Word. The selected Excel range cannot be shrunk to less than
69% of its original size in Word. If the selected range must be smaller
than 69% of original to fit in the Word page, then the range is shrunk
to 69% and any extra columns or rows are truncated. Sometimes you can
get around this limitation by copying and pasting the Excel range in
several pieces, and then maybe resizing the pasted pieces in Word.

Do you have any reference or documentation of this? I haven't testet this in
Word 2000 but in XP and 2003 there is no such limit.

 

[Fredrik Eide Nilsen]

There is a limit to how much you can paste as a picture or metafile from
Excel into Word. The selected Excel range cannot be shrunk to less than
69% of its original size in Word. If the selected range must be smaller
than 69% of original to fit in the Word page, then the range is shrunk
to 69% and any extra columns or rows are truncated. Sometimes you can
get around this limitation by copying and pasting the Excel range in
several pieces, and then maybe resizing the pasted pieces in Word.

Do you have any reference or documentation of this? I haven't testet this in
Word 2000 but in XP and 2003 there is no such limit.[/QUOTE]

Any other suggestions?

 

[Cindy M -WordMVP-]

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

There were so many complaints about the arbitrary limit Word imposed on data
being brought over in an object or picture from Excel that MS introduced new
functionality in Word 2002. Basically, if you reach a certain size, Word will
reduce the zoom by 50%. And again by 50%, so that everything will fit on a
page.

You don't mention in your original posting: do you use the "Copy as Picture"
command in Excel when copying the data? That might give you a better result.

Do you have any reference or documentation of this? I haven't testet this in
Word 2000 but in XP and 2003 there is no such limit.

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

 

[Fredrik Eide Nilsen]

You don't mention in your original posting: do you use the "Copy as Picture"
command in Excel when copying the data? That might give you a better result.

You are the love of my life! On the other hand: Why do they hide these
options?? I never knew it even excisted.

 

[Cindy M -WordMVP-]

Hi Fredrik,

You are the love of my life! On the other hand: Why do they hide these
options?? I never knew it even excisted.

Good thing my husband isn't reading over my shoulder today <g> Glad that helped.

There are just so many options in the Office applications; and different people
need different ones...

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