MS Office Forum / General PowerPoint Questions / July 2007
Missing Color When Pasting From Excel
|
|
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
|
|
|