I am preparing a PowerPoint presentation and am trying to insert an existing
Excel file as a slide. The Excel file includes two graphs. I tried copy and
paste, but the data is a mess when pasted over to Power Point.
Try this. Copy the Excel file then go to the PPT file and use EDIT > PASTE
SPECIAL Select the Microsoft Office Excel Worksheet Object
"EmComp" wrote:
> I am preparing a PowerPoint presentation and am trying to insert an existing
> Excel file as a slide. The Excel file includes two graphs. I tried copy and
> paste, but the data is a mess when pasted over to Power Point.
Rich - Thank you! I've been struggling with this for hours. Your suggestion
worked perfectly. Thanks again.
"Rich" wrote:
> Try this. Copy the Excel file then go to the PPT file and use EDIT > PASTE
> SPECIAL Select the Microsoft Office Excel Worksheet Object
>
> "EmComp" wrote:
>
> > I am preparing a PowerPoint presentation and am trying to insert an existing
> > Excel file as a slide. The Excel file includes two graphs. I tried copy and
> > paste, but the data is a mess when pasted over to Power Point.
This was so helpful. I too was struggling for hours trying all the different
help tools but none of them explained it how you did.
It worked!
Thanks
"Rich" wrote:
> Try this. Copy the Excel file then go to the PPT file and use EDIT > PASTE
> SPECIAL Select the Microsoft Office Excel Worksheet Object
>
> "EmComp" wrote:
>
> > I am preparing a PowerPoint presentation and am trying to insert an existing
> > Excel file as a slide. The Excel file includes two graphs. I tried copy and
> > paste, but the data is a mess when pasted over to Power Point.
I am trying to insert part of an excel worksheet in PPT. When I past special
the entire worksheet is copied over. I want to only paste what is needed from
the sheet.
Any suggestions? Also, once the specific data is pasted and I double-click
to edit, the entire worksheet appears again. Got any ideas??
"Rich" wrote:
> Try this. Copy the Excel file then go to the PPT file and use EDIT > PASTE
> SPECIAL Select the Microsoft Office Excel Worksheet Object
>
> "EmComp" wrote:
>
> > I am preparing a PowerPoint presentation and am trying to insert an existing
> > Excel file as a slide. The Excel file includes two graphs. I tried copy and
> > paste, but the data is a mess when pasted over to Power Point.
In article <962F5927-8565-4C03-A285-559110CBA8A6@microsoft.com>, Dawn wrote:
> I am trying to insert part of an excel worksheet in PPT. When I past special
> the entire worksheet is copied over. I want to only paste what is needed from
> the sheet.
> Any suggestions? Also, once the specific data is pasted and I double-click
> to edit, the entire worksheet appears again. Got any ideas??
That's the way embedded or linked spreadsheets are *supposed* to work.
A few options:
If you need the information to remain editable:
Select just the information you want to share then copy/paste it into a new
workbook. Copy/Paste (optionally link) the information from there into PPT.
Otherwise:
Copy from Excel and Paste Special into PPT as WMF, EMF or PNG.
Or
Select the information in Excel, hold down the Shift key and choose Edit, Copy as
Picture before pasting into PPT.
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Living in the Help Center at PowerPoint Live
Sept 21-24, San Diego CA, USA
www.pptlive.com
I have pasted as you suggested below. But when on running the slide show when
clicked the excel it is not opening . Pls advise how to proceed further.
"Rich" wrote:
> Try this. Copy the Excel file then go to the PPT file and use EDIT > PASTE
> SPECIAL Select the Microsoft Office Excel Worksheet Object
>
> "EmComp" wrote:
>
> > I am preparing a PowerPoint presentation and am trying to insert an existing
> > Excel file as a slide. The Excel file includes two graphs. I tried copy and
> > paste, but the data is a mess when pasted over to Power Point.
Always a good idea to tell us which version of PowerPoint your using. Have a
look here and see if this helps.
Linking or copying information/content/charts/worksheets from Excel to
PowerPoint
http://www.pptfaq.com/FAQ00593.htm
--
Michael Koerner
MS MVP - PowerPoint
"Muru" <Muru@discussions.microsoft.com> wrote in message
news:7B744935-70B6-4172-A68C-40396DC8D134@microsoft.com...
I have pasted as you suggested below. But when on running the slide show
when
clicked the excel it is not opening . Pls advise how to proceed further.
"Rich" wrote:
> Try this. Copy the Excel file then go to the PPT file and use EDIT >
> PASTE
> SPECIAL Select the Microsoft Office Excel Worksheet Object
>
> "EmComp" wrote:
>
> > I am preparing a PowerPoint presentation and am trying to insert an
> > existing
> > Excel file as a slide. The Excel file includes two graphs. I tried
> > copy and
> > paste, but the data is a mess when pasted over to Power Point.
Don't Miss the PPTLive User Conference! Atlanta | Oct 11-14
"Muru" <Muru@discussions.microsoft.com> wrote in message
news:7B744935-70B6-4172-A68C-40396DC8D134@microsoft.com...
>I have pasted as you suggested below. But when on running the slide show
>when
> clicked the excel it is not opening . Pls advise how to proceed further.
>
> "Rich" wrote:
>
>> Try this. Copy the Excel file then go to the PPT file and use EDIT >
>> PASTE
>> SPECIAL Select the Microsoft Office Excel Worksheet Object
>>
>> "EmComp" wrote:
>>
>> > I am preparing a PowerPoint presentation and am trying to insert an
>> > existing
>> > Excel file as a slide. The Excel file includes two graphs. I tried
>> > copy and
>> > paste, but the data is a mess when pasted over to Power Point.
Porting data from Excel to PowerPoint is a common task. After all,
PowerPoint can’t even total a column of numbers. If you do this often
working with many different xls and ppt files, you should check out a
try-before-you-buy tool at www.xpport.com. It can port a multi-page
spreadsheet to multiple slides in one step or even your entire
workbook.
Rich
EmComp Wrote:
> I am preparing a PowerPoint presentation and am trying to insert an
> existing
> Excel file as a slide. The Excel file includes two graphs. I tried
> copy and
> paste, but the data is a mess when pasted over to Power Point.
--
Rich