Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General PowerPoint Questions / July 2007

Tip: Looking for answers? Try searching our database.

Missing Color When Pasting From Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
muelle60 - 21 May 2007 08:11 GMT
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 - 21 May 2007 08:25 GMT
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.

Signature

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

> Hello,
>
[quoted text clipped - 8 lines]
>
> Christian
muelle60 - 21 May 2007 08:49 GMT
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.

> Which version of PowerPoint are you using?
>
[quoted text clipped - 17 lines]
> >
> > Christian
Geetesh Bajaj - 21 May 2007 09:48 GMT
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.

Signature

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

>I use PPT 2003.
>
[quoted text clipped - 26 lines]
>> >
>> > Christian
muelle60 - 21 May 2007 11:40 GMT
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.

> You aren't discussing pictures here? I thought you meant text.
>
[quoted text clipped - 39 lines]
> >> >
> >> > Christian
Geetesh Bajaj - 21 May 2007 11:58 GMT
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?

Signature

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

> Sorry for the missunderstanding. We copy a large table from excel
> including
[quoted text clipped - 58 lines]
>> >> >
>> >> > Christian
muelle60 - 21 May 2007 13:52 GMT
1. Yes
2. Yes
3. Same behavior does not happen on the same machine using a different user.

> I tried pasting red colored text in Excel cells as an EMF through Paste
> Special in PowerPoint, and it gets pasted as red text.
[quoted text clipped - 72 lines]
> >> >> >
> >> >> > Christian
Geetesh Bajaj - 21 May 2007 14:21 GMT
Echo's suggestion should work -- do get back and let us know.

Signature

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

> 1. Yes
> 2. Yes
[quoted text clipped - 85 lines]
>> >> >> >
>> >> >> > Christian
muelle60 - 21 May 2007 16:40 GMT
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 suggestion should work -- do get back and let us know.
>
[quoted text clipped - 87 lines]
> >> >> >> >
> >> >> >> > Christian
Echo S - 21 May 2007 16:55 GMT
Isn't the default printer profile-specific? (I'm asking, I don't know.)

Signature

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/

>I repeat myself:
>
[quoted text clipped - 111 lines]
>> >> >> >> >
>> >> >> >> > Christian
muelle60 - 21 May 2007 17:11 GMT
Please see the other thread.

> Isn't the default printer profile-specific? (I'm asking, I don't know.)
>
[quoted text clipped - 113 lines]
> >> >> >> >> >
> >> >> >> >> > Christian
Geetesh Bajaj - 21 May 2007 17:02 GMT
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.

Signature

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

>I repeat myself:
>
[quoted text clipped - 111 lines]
>> >> >> >> >
>> >> >> >> > Christian
muelle60 - 21 May 2007 17:11 GMT
Please sse the other thread.

> 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
[quoted text clipped - 124 lines]
> >> >> >> >> >
> >> >> >> >> > Christian
Echo S - 21 May 2007 14:16 GMT
This will sound odd, but set your default printer to a color printer. That
should take care of it.

Signature

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/

> Hello,
>
[quoted text clipped - 8 lines]
>
> Christian
muelle60 - 21 May 2007 16:59 GMT
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?

> This will sound odd, but set your default printer to a color printer. That
> should take care of it.
[quoted text clipped - 11 lines]
> >
> > Christian
Echo S - 21 May 2007 18:37 GMT
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.

Signature

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/

> Very good, now it just works. But what is the problem?
>
[quoted text clipped - 18 lines]
>> >
>> > Christian
schmi_ny - 11 Jul 2007 16:46 GMT
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.

> Very good, now it just works. But what is the problem?
>
[quoted text clipped - 17 lines]
> > >
> > > Christian
Echo S - 11 Jul 2007 17:43 GMT
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.

Signature

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

>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
[quoted text clipped - 36 lines]
>> > >
>> > > Christian
schmi_ny - 11 Jul 2007 21:44 GMT
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.

> This is the PowerPoint group, not the Word group, so I don't know if our fix
> will work in Word or not.
[quoted text clipped - 50 lines]
> >> > >
> >> > > Christian
Echo S - 12 Jul 2007 00:18 GMT
That's great to know. Thanks for posting back with your resolution.

Signature

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

> Thanks for the help.
> I figured it out.  I'm an idiot! :-)
[quoted text clipped - 71 lines]
>> >> > >
>> >> > > Christian
schmi_ny - 11 Jul 2007 16:30 GMT
Was this ever settled, i can't quite tell and am having the exact same problem?

> Hello,
>
[quoted text clipped - 7 lines]
>
> Christian
stripedfrog - 12 Jul 2007 15:44 GMT
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

>Was this ever settled, i can't quite tell and am having the exact same problem?
>
[quoted text clipped - 3 lines]
>>
>> Christian

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.