paste excel data into powerpoint table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WAgrapher - 07 Jun 2006 23:57 GMT

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.

Reply to this Message

Brian Reilly, MVP - 08 Jun 2006 16:19 GMT

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

>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
[quoted text clipped - 6 lines]
>
>Thanks in advance.

Reply to this Message

Rate this thread: