excel in power point

[Janet]

I want to be able to embed an excel worksheet in ppt and
have the user enter a number and have the answer
calculated and displayed on the slide. Is this possible?
Should I be using a different application?

 

[tjtjjtjt]

Well, if you embed an Excel Spreadsheet, you won't be able to edit it in PowerPoint. If you link the Excel sheet to PowerPoint, the person would be able to double click on the embedded object to open up Excel and edit it in there. Word Tables can also be used--but the person would have to double-click on the embedded word object, which would make Word Toolbars and commands available. But, for calculations, you're usually better off with Excel

t
----- Janet wrote: ----

I want to be able to embed an excel worksheet in ppt and
have the user enter a number and have the answer
calculated and displayed on the slide. Is this possible?
Should I be using a different application

 

[Bill Foley]

I have a simple sample that uses VBA if you want me to send it to you. You
can see the code to see how it is done. Let me know and I'll send it
directly to you (quite small file).

 

[Brian Reilly, MS MVP]

Janet,
You could add the Active X control for a Microsoft Speadsheet which
would function just like a live spreadsheet even in Slide show view.

If it's installed on your machine you can get there by View Toolbars +
Control Toolbox. Then click on the More Controls Icon (last icon that
look like a hammer and wrench. Scroll down the list form Microsoft
Office Spreadsheet and select that. Now draw the spreadsheet shape on
your page.

Format the spreadsheet with your formulas in Slide Show View.

Brian Reilly, PowerPoint MVP

 

[wlotto]

Brian,
I could format the spreadsheet with formulas in
Slide 'Show' View but can't do anything in Slide View.
Why?

thanks.