Excel to powerpoint lose colored inks using paste special

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In creating the presenatation shaded areas remain but red or blue inks revert
to black and lose emphasis. I use paste special enhanced metafile
 
M,

Paste special's reason for existence is to remove formatting from the text
being pasted.
 
I know this is going to sound totally off the wall, but the problem is most
likely that your default printer is a black and white printer. What you need
to do is to add the drivers for a color printer and install them. (You don't
need the printer, you just need your system to think one is there.) Before
you do the copy and paste, make the color printer the default printer. When
you are done, change it back to your real printer. You should then get the
colors you are looking for.

(Steve, is it time to FAQ this? Use the above text if you want, or let me
know if you need more info.)

--
Kathryn Jacobs, Microsoft MVP OneNote and PowerPoint
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books
Get PowerPoint and OneNote information at www.onppt.com

I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived
 
(Steve, is it time to FAQ this? Use the above text if you want, or let me
know if you need more info.)
Click to expand...

I *do* agree.

You can also add Ute's solution

"in Excel, hold the Shift key and choose Edit from the menu. "Copy" will
have changed to "Copy picture". In PowerPoint, use Edit - Paste special.
Kind regards,
Ute"

Very cordialmente

Enric
 
Yup - That should be there too :)

--
Kathryn Jacobs, Microsoft MVP OneNote and PowerPoint
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books
Get PowerPoint and OneNote information at www.onppt.com

I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived

Enric said:
(Steve, is it time to FAQ this? Use the above text if you want, or let me
know if you need more info.)
Click to expand...

I *do* agree.

You can also add Ute's solution

"in Excel, hold the Shift key and choose Edit from the menu. "Copy" will
have changed to "Copy picture". In PowerPoint, use Edit - Paste special.
Kind regards,
Ute"

Very cordialmente

Enric
--
Enric Mañas [MS MVP-PowerPoint]


Kathy Jacobs said:
I know this is going to sound totally off the wall, but the problem is
most
likely that your default printer is a black and white printer. What you
need
to do is to add the drivers for a color printer and install them. (You
don't
need the printer, you just need your system to think one is there.)
Before
you do the copy and paste, make the color printer the default printer.
When
you are done, change it back to your real printer. You should then get
the
colors you are looking for.

(Steve, is it time to FAQ this? Use the above text if you want, or let me
know if you need more info.)

--
Kathryn Jacobs, Microsoft MVP OneNote and PowerPoint
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro!
Books
Get PowerPoint and OneNote information at www.onppt.com

I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we
lived
Click to expand...
Click to expand...
 
John Wilson said:
Steve - You might want to check out the final link on that page as it looks
like you've linked too much text! (late night?)
Click to expand...

Exactly so. Thanks. Kathy gave me a needed poke in the ribs over that too.

Fixed.
 
It's always a pleasure to nudge you...

;-)

Very cordialmente

Enric

P.S. nudge: <nudge> How to select a default printer/a> to learn how to
install a new printer driver. <nudge>
 
It's always a pleasure to nudge you...

;-)

Very cordialmente

Enric

P.S. nudge: <nudge> How to select a default printer/a> to learn how to
install a new printer driver. <nudge>
Click to expand...

What, you expect me to READ this drivel as well as WRITE it?????

[thanks ... fixed now]

OK. What else did I screw up?
 
I know this is a year old - but its still very relevant.

Everybody thanks very much for adding all your helpful suggestions.
--
Janet


Enric said:
(Steve, is it time to FAQ this? Use the above text if you want, or let me
know if you need more info.)
Click to expand...

I *do* agree.

You can also add Ute's solution

"in Excel, hold the Shift key and choose Edit from the menu. "Copy" will
have changed to "Copy picture". In PowerPoint, use Edit - Paste special.
Kind regards,
Ute"

Very cordialmente

Enric
--
Enric Mañas [MS MVP-PowerPoint]


Kathy Jacobs said:
I know this is going to sound totally off the wall, but the problem is most
likely that your default printer is a black and white printer. What you
need
to do is to add the drivers for a color printer and install them. (You
don't
need the printer, you just need your system to think one is there.) Before
you do the copy and paste, make the color printer the default printer.
When
you are done, change it back to your real printer. You should then get the
colors you are looking for.

(Steve, is it time to FAQ this? Use the above text if you want, or let me
know if you need more info.)

--
Kathryn Jacobs, Microsoft MVP OneNote and PowerPoint
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro!
Books
Get PowerPoint and OneNote information at www.onppt.com

I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we
lived
Click to expand...
Click to expand...
 
I came across this post today and although different it solved my problem.

I was copying cells from excel into powerpoint using the paste special
(enhanced metafile, windows metafile had the same issue). Frustratingly not
all the cells were pasting. Curiously pasting in other ways seemed to be fine.

I changed the printer and page setup and all of sudden it worked fine.

Hopefully this entry should help others with the same problem.

Thanks

Janet said:
I know this is a year old - but its still very relevant.

Everybody thanks very much for adding all your helpful suggestions.
--
Janet


Enric said:
(Steve, is it time to FAQ this? Use the above text if you want, or let me
know if you need more info.)
Click to expand...

I *do* agree.

You can also add Ute's solution

"in Excel, hold the Shift key and choose Edit from the menu. "Copy" will
have changed to "Copy picture". In PowerPoint, use Edit - Paste special.
Kind regards,
Ute"

Very cordialmente

Enric
--
Enric Mañas [MS MVP-PowerPoint]


Kathy Jacobs said:
I know this is going to sound totally off the wall, but the problem is most
likely that your default printer is a black and white printer. What you
need
to do is to add the drivers for a color printer and install them. (You
don't
need the printer, you just need your system to think one is there.) Before
you do the copy and paste, make the color printer the default printer.
When
you are done, change it back to your real printer. You should then get the
colors you are looking for.

(Steve, is it time to FAQ this? Use the above text if you want, or let me
know if you need more info.)

--
Kathryn Jacobs, Microsoft MVP OneNote and PowerPoint
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro!
Books
Get PowerPoint and OneNote information at www.onppt.com

I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we
lived

In creating the presenatation shaded areas remain but red or blue inks
revert
to black and lose emphasis. I use paste special enhanced metafile
Click to expand...
Click to expand...
Click to expand...
 
Enric said:
"in Excel, hold the Shift key and choose Edit from the menu. "Copy" will
have changed to "Copy picture". In PowerPoint, use Edit - Paste special.
Kind regards,
Ute"
Click to expand...

My powerpoint has a blue background with black text. When I follow these
instructions, my excel data picks up that style instead of the font colors in
the Excel file.
 
Back
Top