Excel Sheets copy/paste Office 2007

[Guest]

When I copy and paste special sheets of data from Excel to Powerpoint the do
not copy over like they do in Office Professional. I would like to know the
best method to do a copy and paste of the data sheets that I create in Excel
to Powerpoint in Office 2007

 

[Shane Devenshire]

Hi,

If I understand correctly - first there are no Datasheets in PowerPoint
2007. The data is stored in Excel spreadsheets. At the beginning maybe the
easiest way to get data from Excel into a new PowerPoint 2007 chart is to
open PowerPoint, add a slide, choose Insert, Chart and pick the kind of
chart you want.

In the Excel spreadsheet that appears drag the bottom right corner sizing
handle to match the size of your data. Delete the dummy data. Copy and
paste your data into the chart range.

Cheers,
Shane

 

[Steve Rindsberg]

When I copy and paste special sheets of data from Excel to Powerpoint the do
not copy over like they do in Office Professional. I would like to know the
best method to do a copy and paste of the data sheets that I create in Excel
to Powerpoint in Office 2007

I think I see what you mean, but let's make sure.

Here, if I copy some data from Excel (whether the workbook's saved or not) then
switch to PPT and do Paste Special, the only option I get is "Unformatted text"
(which isn't what either of us would want), and above, it says "Source:
Unknown Source"

Same there?

One possible workaround: from PPT, do Insert, Object; Create from file; browse
to your Excel file and choose it.