[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2151
  • Last Modified:

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
0
Steve_Brady
Asked:
Steve_Brady
  • 2
  • 2
1 Solution
 
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
 
Echo_SCommented:
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
 
Steve_BradyAuthor Commented:
Echo,
Thanks for the clarification.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now