How do I stop Powerpoint XP cropping my Excel XP tables when I pa.

[Guest]

I am using Office XP and Windows XP.

I paste special and select picture and the last few columns sometimes
disappear or get cropped missing out the last few words.

I have removed the Automatic layout for inserted objects function with no
success.

 

[Luc]

Nick,
See if this helps:
http://www.rdpslides.com/pptfaq/FAQ00068.htm
Luc

 

[Guest]

Hi Luc,

Yes I've just seen this article - unfortunately it doesnt help I am still
getting cropping.

Any other ideas welcome.

Nick

 

[Steve Rindsberg]

Hi Luc,

Yes I've just seen this article - unfortunately it doesnt help I am still
getting cropping.

As the article explains, there are limits to what you can bring across the
clipboard from Excel to PPT. You can't change that.

You can change Windows versions, Office versions or, more practically, you can
change the formatting of your spreadsheet so that the selected cells occupy a
smaller area.

Have you tried that?

 

[Guest]

Hi Steve,

I cant change versions of anything as I am in a large corporation. It is
really quite frustrating as there is not that much data in the spreadsheet.
only 8 columns and 10 rows. the final column is wide as it contains text but
not too wide not to fit into a powerpoint slide.

We have got it down to 8pt font and squeezed the columns as much as possible.

Nick

 

[Steve Rindsberg]

I cant change versions of anything as I am in a large corporation.

I didn't expect so ... that was really meant more to point more emphatically to the
one thing you can do: reformat. The data, not the drive! ;-)

really quite frustrating as there is not that much data in the spreadsheet.
only 8 columns and 10 rows. the final column is wide as it contains text but
not too wide not to fit into a powerpoint slide.

We have got it down to 8pt font and squeezed the columns as much as possible.

And does that fix it or not?

Another thing you might try is to save the selected range as an HTML page then use
Insert, Slides, From File to bring that into PowerPoint. Sounds unlikely but it
sometimes works.

Or try Paste Special and test the various graphics formats and/or Link options.
Or try pasting from Excel into a graphics program like Corel Draw, then export from
that to EMF or WMF for import into Draw.

 

[Guest]

Thanks will try all those methods - basically I am just a bit puzzled why it
is doing it - especially when XP was supposed to have fixed this problem.
Well according to the link in the second posting.
http://www.rdpslides.com/pptfaq/FAQ00068.htm

Ho hum these things are sent to try us, usually from microsoft - bless -'em.