View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Petec Petec is offline
external usenet poster
 
Posts: 2
Default Some charts won't copy properly from Excel 2007

I too am experiencing this effect during copy and paste between Excel.
Our graphic artist found a work around that sometimes works and its weird
why it works sometimes but not others and I made him prove it to me.

we would copy as picture in Excel, then in the same Excel file would paste,
even over the top of the original copy. then he could copy that and have it
paste into CorelDraw X4 with out a problem.
but like I said, it will work sometimes but not others.

so far my solution to help him out was to return his system to Office 2003
so he could get some work done.

Have not tried running things in safe mode yet.

starting Excel with
excel.exe /s

to start it in safe mode.
or even trying to run the PC in safe mode and trying it then.


"Jeff in GA" wrote:

Jon, I do appreciate you pointing that out, but it does not solve this problem.

It does answer a different question I posted here, as I used that feature in
the Excel 2003 (the hiddent shift-copy as feature), so I'm glad you pointed
that out to me.

HOWEVER, I just tried it and it did not work. I am convinced this is a bug
in Excel 2007. Here's why: if I open the xls in Excel 2003, I can copy and
paste the image perfectly well (that is how I've been doing it since it
doesn't work from 2007). Again, it is not all the charts in this file, it is
only 2 of many that won't copy. What it does is paste the chart box without
any of the Y or X axis data (if I paste into Corel Draw). And it won't paste
into a Word doc file at all as a metafile! And if I paste it into CorelDraw
as an enhance metafile, it forces Corel to close. I don't have that problem
pasting the exact same chart from 2003. So, until MS fixes this, I need to
keep Excel 2003 installed on one PC in order to export the charts.

Please let me know when/if any other solutions appear.

"Jon Peltier" wrote:

Regular copy? Try copying as a picture. On the Home tab, go to Paste As
Picture Copy As Picture. Cleverly hidden, eh? I didn't even know it was
there for a couple months.