Pasting Excel selection as EMF works in Word 2003 but not 2007

[JoelB]

With Word/Excel 2003, I can copy a selection from Excel and paste it into a
Word document as an Enhanced Metafile (using Paste Special), and the
resulting image is sharp and clear and looks great printed out. However, in
2007 the result is unusable: fonts/spacing is different, text in cells with
a 45 degree orientation appears fuzzy, lines are partially blanked out, etc.
When printed out, it's even worse---the angled text appears as solid black
rectangles, or a mixture of white blocks and incomprehensible black markings.

KB 920231 seems to discuss the issue
(http://support.microsoft.com/kb/920231), but doesn't really offer a
solution. Obviously using Paste won't work with an Excel selection, and I
don't have the _Picture (PNG)_ option (and I don't know how to get it).

Can anyone help?

TIA
Joel

 

[OfficeBunny]

Hey Joel,

I'm having the same problm! It's sooo very troubling! I can't copy and paste
tables or charts from Excel into Word for the life of me! I was using Paste
Special as an EMF too! Each person in our dept has been screwed up after our
IT guru upgraded our computrs to SP2. After our IT guy reinstaled Office 2007
pre-SP2 everything worked fine (except some other bugs).

HELP!

 

[JoelB]

OfficeBunny,

I have asked MSFT for status on the issue, although I kind of doubt we'll
hear anything solid until they have a fix for it.

Their suggestion for a workaround---doing Paste Special and choosing
Microsoft Office Excel Worksheet Object---seems to work better than anything
else I've come across. It looks crummy in the document, but when printed out
it shapes up pretty well. The main problem I've seen so far with it is that
when a cell with angled text has a border, and the border is also the border
of the copied region, the border is not displayed.

Please post if you find any other information or workarounds.

Thanks!
Joel

 

[OfficeBunny]

Hey Joel,

Pasting as a worksheet object sucks. It makes the file size skyrocket! Get a
few dozen charts or tables in a document and Word starts to choke. The
problem also affects the text in the copied selectioni. The space betwen
letters is off. We noticed the problem only after Office SP2 (service pack 2)
was installed so we're tyring to decide to use the progrram pre-SP2. No other
work arounds for now. Sorry. Thanks for aksing MSFT.

 

[JoelB]

OfficeBunny,

You're experiencing spacing problems between letters in a pasted worksheet
object? I hadn't seen that. I also hadn't looked at file sizes, but I'm
sure you're right...it makes sense that it would be larger than a jpeg.

In case you're desperate enough to want to do this, one of the things the
MSFT person said was this:

If you would like to get a quick solution or fix,
please directly contact your local CSS to get
a dedicated engineer's help in a timely manner.
Once the problem is identified as a bug, the
support incident will be no charge.

International Support (non-US/Canada):
http://support.microsoft.com/common/international.aspx

US and Canada:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;OfferProPhone

Joel

 

[JoelB]

Are you still around, OfficeBunny? I may have a solution---try this:

- In *Excel*, click at the bottom of the _Paste_ button
- Choose _As Picture_ from the dropdown menu
- Choose _Copy as Picture_ from the submenu
- Choose _As shown when printed_ radio button
- Paste into Word

It's *incredibly* counter-intuitive, but so far the only problem I see with
it is a minor issue with borders adjoining angled cells. The resulting file
size is actually smaller than the EMF method in Word 2003!

Please post back to this thread whether or not that resolves the issue for
you and your group.

Joel