asked on

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

Echo_S

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

Steve_Brady

ASKER

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

ASKER CERTIFIED SOLUTION

Echo_S

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Steve_Brady

ASKER

Echo,
Thanks for the clarification.