Is there anyway to insert an Excel Sheet into a Powerpoint Presentation that will allow you to edit the sheet during the presentation itself?
Possibly using OLE (Object Linking and Embedding). Check out the help files on this topic.
Zev Steinhardt
Yeah, I’ve been trying. I’ve come to think it’s impossible
I usually just copy the cells and paste them into ppt. Then, I double click on the table and it allows me to edit it, no problem. If that doesn’t work, maybe you can copy the table into word and then put it into ppt.
I’ve seen excel spreadsheets embedded in PP presentations I’ve been translating, but buggered if I know how they got there.
I have no problem putting the Excel sheet into powerpoint itself and editing it in design view. It’s just that I would like to be able to edit the sheet during the actual presentation.
Could you put in a hyperlink to the ECEL sheet in question, then when in presentation mode, clicking on the hyperlink (it could the object itself), will fire up EXCEL and allow you to edit?
• Use a Hyperlink like Caught@Work mentions, or an object Action Setting that Hyperlinks to the XLS file. The problem with doing it this way is that the XL object will not be visible in PPT.
• Use Action Settings Object Action, which will allow for the object to be visible in PPT:
<1> Insert | Object | Create from File, browse to your saved XLS file and Insert.
<2> With the object selected, Slide Show | Action Settings, set Object Action to Edit
<3> Run Slide Show, click on object and it will launch XL and allow you to edit it.