Cut and paste from Excel

[John Henderson]

I have an Excel spreadsheet where I've used color (i.e.
not black) for some fonts, and also used some color fills
in some of the cells. When I 'Cut' and 'Paste Special'
as 'Picture' into Powerpoint, all the color becomes
black. If I paste as a Bitmap or Excel Worksheet Object,
the colors are retained.
Any suggestions?
Rgds

 

[Echo S]

I have an Excel spreadsheet where I've used color (i.e.
not black) for some fonts, and also used some color fills
in some of the cells. When I 'Cut' and 'Paste Special'
as 'Picture' into Powerpoint, all the color becomes
black. If I paste as a Bitmap or Excel Worksheet Object,
the colors are retained.
Any suggestions?
Rgds

If you paste as Excel Worksheet Object and then ungroup that in PPT, do
the colors stay then?

 

[Kathryn Jacobs]

John,
I don't have an answer for, just verification that it does do this. It
really isn't PowerPoint, it is a combination of Office and the OS. I am
guessing that you haven't tried it yet, but if you cut and paste special as
picture to other Office programs, you will get the same results in many
cases. Here is some additional information from the last time I ran into the
problem:
It all depends on how you paste the Excel data. It seems that different
machines have different filters for the paste special. For example, in 2003
on one of my machines, if you paste it as any kind of a metafile or as an
Office object, you lose the colors. If you paste it as a bitmap or generic
picture, you get the colors. On another 2003 machine, you always get the
colors. On that same (2nd) machine, you also always get the colors in 2000.
On a third machine, running 2002, you get the colors only when you paste as
a bitmap.
Another interesting thing: On the machines where the problem occurs, it
doesn't matter if you paste to PowerPoint or Word or Outlook. Long as it is
an Office product, you get the same problems.
--
Kathryn Jacobs, Microsoft PPT MVP
If this helped you, please take the time to rate the value of this post:
http://rate.affero.net/jacobskl/
Get PowerPoint answers at http://www.powerpointanswers.com
Cook anything outdoors with http://www.outdoorcook.com
Kathy is a trainer, writer, Girl Scout, and whatever else there is time for
I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived

 

[Brian Reilly, MS MVP]

John,
In addition to Echo and Kathy's comments, check if your default
printer is black and white or color. If you set it to a color printer,
even if you don't actually have a color printer, pasting into Office
apps should always retain the color. Untried but a good guess since I
never have that problem. And use Copy as Picture from Excel quite
often.

Brian Reilly

 

[John H]

Yes they do remain, but that gives a different problem.
In the worksheet I pick up some live data from a Bloomberg
price feed. WHen I cut and past as a worsheet object,
these turn into #VALUE!

-----Original Message-----

I have an Excel spreadsheet where I've used color (i.e.
not black) for some fonts, and also used some color fills
in some of the cells. When I 'Cut' and 'Paste Special'
as 'Picture' into Powerpoint, all the color becomes
black. If I paste as a Bitmap or Excel Worksheet Object,
the colors are retained.
Any suggestions?
Rgds

If you paste as Excel Worksheet Object and then ungroup that in PPT, do
the colors stay then?

--
Echo [MS PPT MVP]
http://www.echosvoice.com
Join us at PPTLive! Oct 12-15 http://www.pptlive.com
.

 

[JohnH]

Thanks for the suggestion, but it didn't work. One thing
I forgot to mention is that I have a couple of objects
drawn over the worksheet (circles highlighting parts of
it), and the color of those come through. It's only the
formatting of words or numbers in color that is a
problem. Even a color fill of a cell comes through OK:
just those pesy alphanumeric characters!!

Rgds

 

[John H]

APologies - I changed my printer to color and it didn't
work (as per earlier email) but when I did what you said
(not what I thought you said!!!) i.e. changed the default,
it did work!
Thanks

John

 

[Echo S]

Ah, I think you'd need to do some work in the Excel sheet before pasting
into PPT, then. Copy/Paste Special and choose Values.

I know, that's more work than it should be.

Echo

 

[Brian Reilly, MS MVP]

John,
Echo would probably tell you to do what I meant and not what I said
(vbg). Glad what I said helped. Back to work now!

Brian Reilly, PowerPoint MVP