paste excel data into powerpoint table

[Guest]

When I copy data from excel and try to paste it into an already created table
in powerpoint, all data pastes into one table cell. I do not want to paste
special as excel because I have a lot of these and the powerpoint file ends
up too large to send to my client. How can I paste excel data directly into
a powerpoint table - or paste the excel data as a powerpoint table that I can
then manipulate as such in ppt?

Working with office 2003.

Thanks in advance.

 

[Brian Reilly, MVP]

Three options for what you want. All are on a page without a
PowerPoint Table on the page.
Copy and paste, pastes the table and the object is a PowerPoint Table
object type.
Copy and paste special as formatted text and the object is an
Autoshape object type.
Copy and paste special as unformatted text and the object is an
AutoShape object type.

As for copying just the single Excel worksheet and not the whole
workbook, in Excel select the sheet and from the menu chose Edit +
Move or Copy sheet, Select New workbook and check Make a Copy
You will now have a single worksheet workbook embedded in PPT if you
paste special as XL workbook. If you just paste you will have a PPT
table object.

Brian Reilly, MVP