PPT 2002 & Excel 2002

  • Thread starter Thread starter Carl Lucas
  • Start date Start date
C

Carl Lucas

Recently we upgraded to Win XP and now are using Excel
2002 and PPT 2002. Prior to this we used Excel &
Powerpoint 97.

Monthly I would create various reports using Powerpoint.
Some are 30 pages; others are 60. I would first update
Excel files with the latest data. then I would copy a
section of a spreadsheet and then paste it into PPT 97. I
would not "Paste Special" because I wanted to maintain
the color (red) associated with negative numbers. All was
fine. I had made sure the column widths and the number of
lines were able to fit on the PPT slide.

Now with 2002 when I copy the same areas from Excel and
paste them into PPT 2002 they are way too big. The area
comes in as a "Table". If I select "Excel Table" from
the "Past Options" icon, the area is the proper size but
the color is only black and not red for the negative
numbers.

If I select "Picture of Table" it's the same as "Excel
Table".

This procedure used to work perfectly for me in the 97
versions. What can I do?
 
Carl,
Yup bummer on this improvement!

XP on a straight copy and paste seems to default and paste the Excel
range as a PPT table and not as an embedded Excel object. Choosing
Paste special will let you have the default of an embedded XL OLE
object which is what you and all of us were used to . Shame on you Ric
and Mike, how'd you let this one get approved?

Brian Reilly, PowerPoint MVP
 
Back
Top