Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Missing Color When Pasting From Excel

773 views
Skip to first unread message

muelle60

unread,
May 21, 2007, 3:11:01 AM5/21/07
to
Hello,

I have a problem when I copy an colored text from excel to PPT. For instance
if I copy a red text to PPT, the text color will reset to black.

What Do I wrong? I works when I using an different account on the same
machine.

Thanks.

Christian

Geetesh Bajaj

unread,
May 21, 2007, 3:25:05 AM5/21/07
to
Which version of PowerPoint are you using?

For newer versions, you get a Smart tag that allows you more control over
how the content is pasted. For older versions, try Edit | Paste Special to
get more options.

Also, the color scheme of the presentation in which you are pasting may be
effecting the color of the pasted text.


--
Geetesh Bajaj, Microsoft PowerPoint MVP
http://www.indezine.com
http://www.ppted.com

"muelle60" <muel...@discussions.microsoft.com> wrote in message
news:11839783-26B3-464C...@microsoft.com...

muelle60

unread,
May 21, 2007, 3:49:01 AM5/21/07
to
I use PPT 2003.

I know smart tags, but I use Paste Special -> Picture (Enhanced metafile),
to reduce the file size and to get the correct picture from excel.

I also use the default color scheme.

Geetesh Bajaj

unread,
May 21, 2007, 4:48:33 AM5/21/07
to
You aren't discussing pictures here? I thought you meant text.

PowerPoint changes the color of the text to black in the default template if
you select the Keep Text Only option in the smart tag. Otherwise, the
default smart tag option is Table, and that retains the red color.

If you are using the smart tags, you don't need to use Paste Special |
Picture (Enhanced Metafile)

If you must use Paste Special, try Paste Special | HTML format.

Again, all this info is for text, not graphics.


--
Geetesh Bajaj
Author of Cutting Edge PowerPoint for Dummies
http://www.cuttingedgeppt.com

"muelle60" <muel...@discussions.microsoft.com> wrote in message

news:3AB9917D-1784-4384...@microsoft.com...

muelle60

unread,
May 21, 2007, 6:40:02 AM5/21/07
to
Sorry for the missunderstanding. We copy a large table from excel including
table borders, background and colored text. We do not want to insert this as
an html table. We want to insert this as picture. It is easier to handle and
we get the exactly the same view (from excel to ppt). I know if I use the
keep text option I will get only black text.

If I paste using Strg+V I got the correct color.
If I paste using Paste Special -> Picture (enhanced metafile) I got only
black text.

Geetesh Bajaj

unread,
May 21, 2007, 6:58:32 AM5/21/07
to
I tried pasting red colored text in Excel cells as an EMF through Paste
Special in PowerPoint, and it gets pasted as red text.

Are you saying that you get black text when you do the same?

Let me paraphrase these other observations from your earlier mails:

1. You are using PowerPoint 2003 and Office 2003.

2. You are using PowerPoint's default template.

3. The same behavior does not happen on another computer -- just on the one
you are using?


--
Geetesh Bajaj
Author of Cutting Edge PowerPoint for Dummies
http://www.cuttingedgeppt.com


"muelle60" <muel...@discussions.microsoft.com> wrote in message

news:4112D872-780C-46C0...@microsoft.com...

muelle60

unread,
May 21, 2007, 8:52:01 AM5/21/07
to
1. Yes
2. Yes
3. Same behavior does not happen on the same machine using a different user.

Echo S

unread,
May 21, 2007, 9:16:53 AM5/21/07
to
This will sound odd, but set your default printer to a color printer. That
should take care of it.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/


"muelle60" <muel...@discussions.microsoft.com> wrote in message
news:11839783-26B3-464C...@microsoft.com...

Geetesh Bajaj

unread,
May 21, 2007, 9:21:11 AM5/21/07
to
Echo's suggestion should work -- do get back and let us know.

--
Geetesh Bajaj
Author of Cutting Edge PowerPoint for Dummies
http://www.cuttingedgeppt.com


"muelle60" <muel...@discussions.microsoft.com> wrote in message

news:4371C9AB-4EB4-4B69...@microsoft.com...

muelle60

unread,
May 21, 2007, 11:40:01 AM5/21/07
to
I repeat myself:

It works with different users on the same and other machines. But it does
not work for a specific user. I just cleared the profile, but it does not
helps.

I can paste my table from excel in Word or in PPT as Picture on both
programs I get only a black text. I dont want to use html, because in some
other tables is a chart included. Despite of this it just works with other
users.

Any idea why he resets the font color? First I thougt it depends on the
compatibilty features (2000 vs. 2003) of office.

Echo S

unread,
May 21, 2007, 11:55:49 AM5/21/07
to
Isn't the default printer profile-specific? (I'm asking, I don't know.)

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/

"muelle60" <muel...@discussions.microsoft.com> wrote in message

news:591CCC73-57AB-4B36...@microsoft.com...

muelle60

unread,
May 21, 2007, 11:59:09 AM5/21/07
to
Very good, now it just works. But what is the problem?

I can't set always the color printer as default printer for this user.

Any ideas?

Geetesh Bajaj

unread,
May 21, 2007, 12:02:04 PM5/21/07
to
Yes, you do make yourself clear -- just that there's not an obvious
explanation for this unless we are missing something obvious. So, we are
trying all possibilities and guesses to see what can help you resolve the
issue.

As such, the color of text in PowerPoint has nothing to do directly with a
profile unless (as Echo mentioned) it relates to the default printer. And as
odd as it may seem, we need to make sure that this is not the issue before
we move ahead -- so is the default printer for this profile a color printer
or not? Or does it have no printer installed?

Do let us know.


--
Geetesh Bajaj
Author of Cutting Edge PowerPoint for Dummies
http://www.cuttingedgeppt.com


"muelle60" <muel...@discussions.microsoft.com> wrote in message

news:591CCC73-57AB-4B36...@microsoft.com...

muelle60

unread,
May 21, 2007, 12:11:01 PM5/21/07
to
Please see the other thread.

muelle60

unread,
May 21, 2007, 12:11:01 PM5/21/07
to
Please sse the other thread.

Echo S

unread,
May 21, 2007, 1:37:35 PM5/21/07
to
Sorry, I don't know what causes the problem, and I don't know of any other
workaround. I just know that changing to a default color printer fixes it.

Perhaps someone else will have ideas.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/


"muelle60" <muel...@discussions.microsoft.com> wrote in message

news:B28CA4DC-03EA-43BC...@microsoft.com...

schmi_ny

unread,
Jul 11, 2007, 11:30:00 AM7/11/07
to
Was this ever settled, i can't quite tell and am having the exact same problem?

schmi_ny

unread,
Jul 11, 2007, 11:46:07 AM7/11/07
to
I am having the same issue. I am copying a chart from excel to word using
the save as picture metaphile. I've done this lots in the past with no
problem. But now when i paste it automatically goes to black and white. I
don't have a color printer available as a default, but am sending the file to
someone who does. The issue is if it worked before, what did i change w/o
noticing it that they now copy as no color. the smart tag allows me to past
as picture (of which it then goes in blacke and white), as an excel chart
(but then i need to resize it in excel before copying), or as a link to excel
chart (same issue as above)

it frustrates me because i used to do it all the time and then all of a
sudden, poof, i can't get what i want.

Echo S

unread,
Jul 11, 2007, 12:43:10 PM7/11/07
to
This is the PowerPoint group, not the Word group, so I don't know if our fix
will work in Word or not.

Anyway, install a color printer driver (you don't have to have one actually
attached to the computer) and set it as the default printer. Or heck, maybe
you just need it installed -- you might not even have to set it as the
default printer. Here are instrux:

How to install a local printer driver
http://www.pptfaq.com/FAQ00605.htm

I don't know why this would start happening all of a sudden -- or, indeed,
why it happens at all. Sorry. I know it's frustrating.

--
Echo S [MS PPT MVP] http://www.echosvoice.com
What's new in PowerPoint 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/index.html
PPTLive! Oct 28-31, New Orleans http://www.pptlive.com

"schmi_ny" <sch...@discussions.microsoft.com> wrote in message
news:95325718-5FEA-4004...@microsoft.com...

schmi_ny

unread,
Jul 11, 2007, 4:44:03 PM7/11/07
to
Thanks for the help.
I figured it out. I'm an idiot! :-)
All it turned out to be was that on my chart I had the bars in color AND
with patterns. I did this so if someone printed it on a non-color printer it
would be easy to differentiate. I guess Word thought the same thing and just
did it that way; i.e. not both elements. Once I took the patterns off it
copies in color as I'm used to.

Echo S

unread,
Jul 11, 2007, 7:18:06 PM7/11/07
to
That's great to know. Thanks for posting back with your resolution.

--
Echo S [MS PPT MVP] http://www.echosvoice.com
What's new in PowerPoint 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/index.html
PPTLive! Oct 28-31, New Orleans http://www.pptlive.com

"schmi_ny" <sch...@discussions.microsoft.com> wrote in message

news:4024CEAD-8358-4C49...@microsoft.com...

stripedfrog via OfficeKB.com

unread,
Jul 12, 2007, 10:44:03 AM7/12/07
to
LOL, not sure.

I had a similar problem yesterday, copied a chart and pasted in power point.
This was one of many charts I moved over and after about 7 charts this one
went crazy. I didn't lose color but lost bar column titles on my chart. I.T.
spent 20 minutes trying to figure it out without a solution.

I found a 'QUICK FIX' though. It doesn't solve the problem but it keeps the
work flowing.....

1) Copy chart in Excel
2) Open Word Document
3) Paste chart in Word (no need to save the doc)
4) Copy the chart in Word
5) Paste in Power Point

I don't know why that works, and don't really care. Just glad to be moving
forward.

Hope it works for you1

schmi_ny wrote:
>Was this ever settled, i can't quite tell and am having the exact same problem?
>

>> Hello,
>>
>[quoted text clipped - 7 lines]
>>
>> Christian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/powerpoint/200707/1

0 new messages