performing calculations during a presentation

G

Guest

I have an excel spreadsheet imported into a powerpoint and would like to
perform calculations during my presentation. I need to be able to alter some
of the figures during the presentation without actually interrupting it to
manipulate my numbers in the design view by double clicking on the spreadshit
to open excel in PP. I simply want to be able to click on one of the cells,
which then becomes alterable and once I hit enter the other figures need to
change accordingly like in excel but during my presentation. A macro perhaps?
 
G

Guest

I've seen this question so frequently lately...

Personally I recommend using www.xcelsius.com which embeds a flash component
that uses an Excel Spreadsheet and lets you make real-time adjustments to
whatever.

However, if you can't afford the price tag, the general concept is this:

Embed a graph, add ActiveX components from the toolbar that you add code to
that updates the embedded spreadsheet and then add code to update the graph.
You can either choose to update the graph with each change item or add an
action button to run the macro to update the graph when the user clicks on it.

I understand VB concepts much better than I can program but here's a couple
of references:

http://pptfaq.com/index.html#name_For_VBeginners
http://www.loyola.edu/edudept/PowerfulPowerPoint/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top