Excel formulas in PowerPoint 2007

Hello,
Is it possible to paste Excel worksheet information into PowerPoint 2007 slides in a way that formula funtion is retained?  In other words, can I display a PowerPoint slide and have it be interactive?  If so, how do I do it?  If not, is there another way to get that functionality in a presentation?
Thanks
Steve_BradyAsked:
Who is Participating?
 
Echo_SConnect With a Mentor Commented:
No. You have to launch / open the Excel object during the presentation to do any kind of work on it. So I gave you instrux for launching it during a presentation.

PPT tables don't maintain any kind of functions / formulas.
0
 
Echo_SCommented:
You can use Insert | Object | Create from File. Or you can paste the data and choose "entire workbook" in the Paste Options button that appears immediately after you paste.

To actibvate it during a presentation, give the object an animation. Click Animations | Custom Animation to open the animation pane. Add Effect | Object Actions | Open. You might want to make that a trigger animation so it happens when you click the workbook, not just when you click in general. Here's more on triggers if you need that: http://www.echosvoice.com/triggers.htm 
0
 
Steve_BradyAuthor Commented:
Echo,
Thanks for the reply. I followed your instructions (I think). However, all it seems to do is launch my Excel application and bring up that worksheet. The thing I'm wondering is if it is possible to paste a certain range of cells from an Excel spreadsheet into a PowerPoint slide and have it retain the functionality of previously created formulas so that I can modify values in the slide during my presentation and have the cells containing functions based on those values change accordingly. I apologize if I did not explain that earlier or if I did explain it and I'm just doing something wrong in following your directions.
Thanks
0
 
Steve_BradyAuthor Commented:
Echo,
Thanks for the clarification.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.