Excel to powerpoint lose colored inks using paste special

[M Worrall]

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

 

[Chuck Davis]

M,

Paste special's reason for existence is to remove formatting from the text
being pasted.

 

[Kathy Jacobs]

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

 

[Enric]

(Steve, is it time to FAQ this? Use the above text if you want, or let me

know if you need more info.)

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

 

[Kathy Jacobs]

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

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

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]

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

 

[John Wilson]

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?)
--

_____________________________
John Wilson
Microsoft Certified Office Specialist
http://www.technologytrish.co.uk/ppttipshome.html

 

[Enric Mañas]

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>

 

[Janet]

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

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

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

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]

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

 

[Mat N]

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

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

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

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

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]

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

 

[dleo]

"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"

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.