copy and paste

  • Thread starter Thread starter Wilfredo Perez
  • Start date Start date
W

Wilfredo Perez

when I copy a spreadsheet from excel which has colors to a powerpoint slide
by doing a paste special and selecting picture, it does the paste in black
and white, not in color
 
Wilfredo Perez said:
when I copy a spreadsheet from excel which has colors to a powerpoint slide
by doing a paste special and selecting picture, it does the paste in black
and white, not in color
Click to expand...
While choosing "Edit" in Excel, hold down the Shift-key. "Copy" will change
to "Copy picture" then. When inserting this in PowerPoint (with "Paste
special", as usual), it will keep it's colors.

Kind regards,
Ute
 
If you have the Print - Black and white box checked on
the File | Page Setup... menu option, this will occur.
When I unchecked the box and tried the paste
from Excel to PowerPoint, the Excel data pasted in
color, not in B/W.

As for Ute's tip, this must be one of those hidden features!
I mean, who would have ever thought that
holding down the SHIFT key while clicking
on a menu item would cause the menu items
to change? Amazing. Is this documented somewhere?
How are people supposed to find about about these
things? Anyway, great tip!

- Jeff
 
The paste is not coming out in color
-----Original Message-----
to a powerpoint
slide
While choosing "Edit" in Excel, hold down the Shift- key. "Copy" will change
to "Copy picture" then. When inserting this in PowerPoint (with "Paste
special", as usual), it will keep it's colors.

Kind regards,
Ute

.
Click to expand...
 
In Excel, click on File | Page Setup...
and click the Sheet tab.
Make sure the "Print balck and white" checkbox
is unchecked.
Now, try to copy the object to the
clipboard in Excel, and repaste it into PowerPoint.
How does it look?
 
I'm just thinking aloud here, but ISTR that there was something about
having your default printer set to black and white which can affect
this. Try setting your default printer to a color one (even if you don't
have a color printer installed, install some drivers for one and
temporarily set that to default).

Then again, I may be dreaming. :-)
 
Or... along those lines...
if you don't have a color printer but you DO have
Adobe Acrobat installed (not Adobe Reader,
but the full version of Acrobat), you could set
your default printer to PDFWriter and thus you
would have your color options set.
Perhaps!

Echo S said:
I'm just thinking aloud here, but ISTR that there was something about
having your default printer set to black and white which can affect
this. Try setting your default printer to a color one (even if you don't
have a color printer installed, install some drivers for one and
temporarily set that to default).

Then again, I may be dreaming. :-)

--
Echo [MS PPT MVP]
http://www.echosvoice.com
The paste is not coming out in color
Click to expand...
Click to expand...
 
Ah, but I just saw your post about the "print B/W" setting in Excel.
That might do the same thing! Or maybe that's what I was thinking of in
the first place? (At least I know I wasn't totally dreaming, hehehe.)

Echo

Jeff said:
Or... along those lines...
if you don't have a color printer but you DO have
Adobe Acrobat installed (not Adobe Reader,
but the full version of Acrobat), you could set
your default printer to PDFWriter and thus you
would have your color options set.
Perhaps!

Echo S said:
I'm just thinking aloud here, but ISTR that there was something about
having your default printer set to black and white which can affect
this. Try setting your default printer to a color one (even if you don't
have a color printer installed, install some drivers for one and
temporarily set that to default).

Then again, I may be dreaming. :-)

--
Echo [MS PPT MVP]
http://www.echosvoice.com
The paste is not coming out in color
Click to expand...
-----Original Message-----
:
when I copy a spreadsheet from excel which has colors
to a powerpoint
slide
by doing a paste special and selecting picture, it does
the paste in black
and white, not in color

While choosing "Edit" in Excel, hold down the Shift-
key. "Copy" will change
to "Copy picture" then. When inserting this in PowerPoint
(with "Paste
special", as usual), it will keep it's colors.

Kind regards,
Ute
Click to expand...
Click to expand...
Click to expand...
 
still not working
-----Original Message-----
If you have the Print - Black and white box checked on
the File | Page Setup... menu option, this will occur.
When I unchecked the box and tried the paste
from Excel to PowerPoint, the Excel data pasted in
color, not in B/W.

As for Ute's tip, this must be one of those hidden features!
I mean, who would have ever thought that
holding down the SHIFT key while clicking
on a menu item would cause the menu items
to change? Amazing. Is this documented somewhere?
How are people supposed to find about about these
things? Anyway, great tip!

- Jeff


does the paste in
black key. "Copy" will
change

.
Click to expand...
 
[CRITICAL UPDATE - Anyone using Office 2003 should install the critical
update as soon as possible. From PowerPoint, choose "Help -> Check for
Updates".]

Hello,

To me, this sounds like a problem/limitation with how Excel is creating the
rendering for its OLE objects. Since the normal workarounds don't appear to
be working, try resorting to standard OLE/Interoperability troubleshooting
to find the source of the problem (PowerPoint or Excel).

One of the first steps for troubleshooting OLE objects is to isolate
whether the problem is in the container (in this case, PowerPoint) or in
the server (in this case <application>).

To isolate the problem:
1) First try a different container applications. I usually recommend
WordPad since it's the most generic OLE container and it ships with Windows.
a) Insert same object into WordPad
b) If applicable, perform same operation on object (if possible) that you
performed in other container (such as resizing object)
c) Does the problem occur in both containers? - If so, the problem might
be with the source application or just an OLE limitation

2) Try different source applications: Which ones I recommend would depend
on the problem. However, it is not always possible to find another source
application which provides a rendering of it's object in the same way so
you might not be able to definitively determine whether it's a container
application problem (because it occurs with multiple source applications).
a) Insert different source object into the same container application (in
this case, PowerPoint)
b) If applicable, perform the same operation on this object that you
performed on the other object (such as resizing object)
c) Does the problem occur with this object? If not, repeat steps 2a-2c
with additional source applications.

So:
* If the problem occurs with only 1 source and multiple containers -> Most
likely a problem or limitation with server application
* If the problem occurs with only 1 container and multiple sources -> Most
likely a problem or limitation with client application
* If the problem occurs with multiple container and multiple sources ->
Most likely a limitation of OLE technology

As always, if you (or anyone else reading this message) have suggestions
about how PowerPoint and Office interoperability (such as Object Linking
and Embedding) should be improved, don't forget to send your feedback (in
YOUR OWN WORDS, please) to Microsoft at:

http://register.microsoft.com/mswish/suggestion.asp

As with all product suggestions, it's important that you not just state
your wish but also WHY it is important to you that your product suggestion
be implemented by Microsoft. Microsoft receives thousands of product
suggestions every day and we read each one but, in any given product
development cycle, there are only sufficient resources to address the ones
that are most important to our customers so take the extra time to state
your case as clearly and completely as possible.

IMPORTANT: Each submission should be a single suggestion (not a list of
suggestions)

John Langhans
Microsoft Corporation
Supportability Program Manager
Microsoft Office PowerPoint for Windows
Microsoft Office Picture Manager for Windows

For FAQ's, highlights and top issues, visit the Microsoft PowerPoint
support center at: http://support.microsoft.com/default.aspx?pr=ppt
Search the Microsoft Knowledge Base at:
http://support.microsoft.com/default.aspx?pr=kbhowto

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
 
[CRITICAL UPDATE - Anyone using Office 2003 should install the critical
update as soon as possible. From PowerPoint, choose "Help -> Check for
Updates".]

Hello,

To me, this sounds like a problem/limitation with how Excel creates the
rendering for its OLE objects.

One of the first steps for troubleshooting OLE objects is to isolate
whether the problem is in the container (in this case, PowerPoint) or in
the server (in this case Excel).

To isolate the problem:
1) First try a different container applications. I usually recommend
WordPad since it's the most generic OLE container and it ships with Windows.
a) Insert same object into WordPad
b) If applicable, perform same operation on object (if possible) that you
performed in other container (such as resizing object)
c) Does the problem occur in both containers? - If so, the problem might
be with the source application or just an OLE limitation

2) Try different source applications: Which ones I recommend would depend
on the problem. However, it is not always possible to find another source
application which provides a rendering of it's object in the same way so
you might not be able to definitively determine whether it's a container
application problem (because it occurs with multiple source applications).
a) Insert different source object into the same container application (in
this case, PowerPoint)
b) If applicable, perform the same operation on this object that you
performed on the other object (such as resizing object)
c) Does the problem occur with this object? If not, repeat steps 2a-2c
with additional source applications.

So:
* If the problem occurs with only 1 source and multiple containers -> Most
likely a problem or limitation with source application
* If the problem occurs with only 1 container and multiple sources -> Most
likely a problem or limitation with container application
* If the problem occurs with multiple container and multiple sources ->
Most likely a limitation of OLE technology

As always, if you (or anyone else reading this message) have suggestions
about how PowerPoint and Office interoperability (such as Object Linking
and Embedding) should be improved, don't forget to send your feedback (in
YOUR OWN WORDS, please) to Microsoft at:

http://register.microsoft.com/mswish/suggestion.asp

As with all product suggestions, it's important that you not just state
your wish but also WHY it is important to you that your product suggestion
be implemented by Microsoft. Microsoft receives thousands of product
suggestions every day and we read each one but, in any given product
development cycle, there are only sufficient resources to address the ones
that are most important to our customers so take the extra time to state
your case as clearly and completely as possible.

IMPORTANT: Each submission should be a single suggestion (not a list of
suggestions)

John Langhans
Microsoft Corporation
Supportability Program Manager
Microsoft Office PowerPoint for Windows
Microsoft Office Picture Manager for Windows

For FAQ's, highlights and top issues, visit the Microsoft PowerPoint
support center at: http://support.microsoft.com/default.aspx?pr=ppt
Search the Microsoft Knowledge Base at:
http://support.microsoft.com/default.aspx?pr=kbhowto

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
 
Back
Top