Pasting into Powerpoint

[pigeonhill]

When I paste a spreadsheet from Excel into PowerPoint, above a certain size, cells on the right are clipped. And yes I have tried resizing the paste window.

The only way I can show the entire spreadsheet is to paste as a bitmap!!!!

There must be another way?????

Any ideas???

Garry

 

[Brian from Maui]

Good point mhguda.

You might try hyperlinking to an Excel worksheet.
This message was edited by Brian from Maui on 2002-05-04 17:15

 

[pigeonhill]

On 2002-05-04 08:38, Brian from Maui wrote:
Pigeonhill,

Exactly what steps are you taking or doing? Someone else may have an idea here.

Are you highlighting the rows and columns, click copy, go to the PowerPoint slide, then click paste?

YES !!!!!!
This message was edited by Brian from Maui on 2002-05-04 08:44

 

[Anne Troy]

This is a known issue. There are several things that can affect this, as well as workarounds that work; though not any one ALWAYS works:

1. If Office 97, make sure you've got the latest service release.

2. If you're centering your page horizontally in page setup of Excel, this can mess up the paste. Other page formatting can affect it too. Try removing any page formatting/reduced pct/Fit-to settings in the Excel file first. I've had users copy those cells and link them to an individual workbook (linked to original) so they could do all that without wrecking their original formatting.

3. Try selecting cells in Excel, hit Zoom dropdown, choose Selection. Save the file, copy/paste.

4. But the most common one that works is when your cells start on A1 of the FIRST worksheet. Then Insert-Object-From File and choose the Excel workbook...

Oh, and it appears MS has something to say about it:

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q285303

*Microsoft has confirmed this to be a problem.*

Hmmm...for about 10 years now!! Wish they'd fix it! I did read one time that it's only intended for up to 7 columns.

Hope this helps either of you!

 

[jmuscat]

Try copying the excel sheet, and paste special => unformatted text in powerpoint. You just have to insert tab marks for column starts.

 

[Brian from Maui]

Pigeonhill

Found this site:

http://www.powerpointbackgrounds.com/powerpointtips.htm

 

[pigeonhill]

Thanks everyone for your ideas re pasting into powerpoint.

I'm glad it wasn't me being dumb!!!!

Cheers

Garry

 

[CompTutor]

Question on this "old" issue from a newbie: when you say "And yes I have tried resizing the paste window", do you mean the window that opens when you double-click on the object? Pasting goes in as an embedded object, so that means you should be able to edit it in Excel by double-clicking. And THAT means that resizing THAT window will expand or contract (or move to other cells, heaven help us!) the cells you see in PPT, regardless of what you actually copied.
I am interested in your response (whether you already tried this) because I am teaching this in class tomorrow night, and this is very timely!