Copy/Paste from Excel into Powerpoint

[elgatogeorgi]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Since the 12.13 update, I can only copy from Excel and Paste into Powerpoint once (I can't paste another selection). I have to close the workbook, select "No" to clear the clipboard, and reopen the workbook to copy again. Anyone else have the same issue or know how to clear the clipboard w/o closing the workbook?

 

[Pat McMillan]

Could you give us detailed steps? I just tried this and it works fine for
me. Maybe there's something in your steps that I'm missing?

Thanks,

Pat

 

[elgatogeorgi]

This is what I'm doing:

1. In Excel, I copy a selection within a spreadsheet
2. Go to Powerpoint and select Paste Special
3. Choose to paste as Picture (it does confirm that I am pasting from the spreadsheet I copied the selection from)
4. Powerpoint places the copied selection in my presentation as a picture
5. I repeat steps 1 -3 above with a different copied selectionin Excel, but nothing happens when I try to paste special/picture into Powerpoint.

On occasion, it will let me do it twice, but I always have to close the Excel spreadsheet, which brings up the "There is a large amount of data on the clipboard" dialogue box. I select No to clear it, reopen the spreadsheet, and then I can copy/paste once or twice again.

I'm not copying over a large amount of data - probably only about 100 cells at a time. I have 3 gigs of RAM and I'm not overloading it by any means. It just seems like the clipboard is running out of memory??

Thanks for you help.

 

[Pavel]

Confirmed. I did it today and was not able to paste table (as picture) even once :-(

 

[Jim Gordon MVP]

This is what I'm doing:

1. In Excel, I copy a selection within a spreadsheet
2. Go to Powerpoint and select Paste Special
3. Choose to paste as Picture (it does confirm that I am pasting from the spreadsheet I copied the selection from)
4. Powerpoint places the copied selection in my presentation as a picture
5. I repeat steps 1 -3 above with a different copied selectionin Excel, but nothing happens when I try to paste special/picture into Powerpoint.

On occasion, it will let me do it twice, but I always have to close the Excel spreadsheet, which brings up the "There is a large amount of data on the clipboard" dialogue box. I select No to clear it, reopen the spreadsheet, and then I can copy/paste once or twice again.

I'm not copying over a large amount of data - probably only about 100 cells at a time. I have 3 gigs of RAM and I'm not overloading it by any means. It just seems like the clipboard is running out of memory??

Thanks for you help.

Hi

As a work-around until there's a fix, hold the Shift Key down in Excel
and use the Edit menu. It will offer Copy Picture.

Also, you might try using the scrapbook feature to see if that works.

-Jim

--
Jim Gordon
Mac MVP


WE NEED YOUR HELP!
The number of new Mac users has skyrocketed. That’s excellent. In this
forum all answers come from other users, not from Microsoft employees.
Please help answer questions.

If you see an unanswered question that you know the answer to, please
take just a moment to post the answer. Doing so speeds response time for
people who come here and need fast responses.

If you see an answer that might be wrong or that you can answer better,
hop right in and offer your thoughts. Don’t berate a wrong answer –
we’re all here trying to help each other.

Don’t bother with questions you’re not quite sure about or don’t know about.

Please take just a moment to help fellow Mac users. Your efforts will be
appreciated greatly - especially by those you help.

 

[Pavel]

Unfortunately, this doesn't work - it seems that content from Excel is not copied to clipboard :-(

 

[CyberTaz]

Hello Pavel;

By no means contradicting, but I'm running 12.1.3 in 10.5.5 on an Intel MBP
& have absolutely no problem repeatedly using Paste Special for charts or
data from Excel to PPt. That suggests to me that the issue might be local to
your system.

You might try downloading the 10.5.5 Combo Update from Apple's site - I've
seen that correct similar problems on more than a few occasions... In fact,
I never use System Update for updates to OS X itself - I always go get the
Combos:

http://www.apple.com/support/downloads/

Repair Disk Permissions afterwards, restart & see how it goes

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Pat McMillan]

Just to follow up on this:

We did inadvertently introduce a problem in the 12.1.3 update that causes
pasting a range of cells to Word or PPT as picture or PDF to fail or
sometimes crash. As far as we're aware, though, this only occurs if the
sheet you're copying from contains an embedded OLE object (an Equation
Editor object, Graph object, etc.). If you remove the OLE object from the
sheet before copying the range, Paste Special to Word and PowerPoint should
work fine. If that's not an option for you, this workaround should also
work:

Copy the range in Excel
Command + N to create a new workbook
Command +V to paste the range into the new workbook
Command + C to copy the range in the new workbook (that doesn¹t contain an
OLE object)
Select Word and Paste Special As Picture or PDF

We are investigating this and hope to get a fix out soon.

Thanks,

Pat

 

[Pavel]

Hi Pat,
please try to use AutoFilter (Data/Filter/AutoFilter) and then copy/paste.
Unfortunatelly also doesn't work then (I am using this quite often). Simple table works, you are right.

There are btw. other big problems with AutoFilter. I can provide you with screenshots and steps how to see it.

Pavel
vanekpavel AT seznam DOT cz

 

[Pat McMillan]

Thank you, Pavel. We are aware that copying/pasting filtered lists to Word
and PowerPoint sometimes shows the unfiltered list in the destination apps.
Is that what you are talking about, or are there other issues. Please do
feel free to send me any issues you're seeing with the steps to reproduce
them.

Thanks,

Pat

 

[Pat McMillan]

Just an update on this issue. In working with Darren, we discovered that
this problem can occur when there are no OLE objects on the Excel sheet. In
Darren's case, the fact that his workbooks were set to Normal View seemed to
be causing the bug to occur. If you encounter this problem, and you don't
have OLE objects on your sheet, you might want to check the View in Excel.
If it's set to Normal, changing it to Page Layout View before copying the
range in Excel seems to allow you to avoid the problem.

Thanks,

Pat