excel in power point

  • Thread starter Thread starter Janet
  • Start date Start date
J

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?
 
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
 
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).
 
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
 
Brian,
I could format the spreadsheet with formulas in
Slide 'Show' View but can't do anything in Slide View.
Why?

thanks.
 
As Glen said elsewhere, it only works in SlideShow View. But the
formulas should stay active.
Brian Reilly, PowerPoint MVP
 
Bill - anything you can send would be great. I just found
out I have to have this done by tonight or tomorrow.

My e-mails address is (e-mail address removed)

Thanks for your help.
 
[CRITICAL UPDATE - Anyone using Office 2003 should install the critical
update as soon as possible. From PowerPoint, choose "Help -> Check for
Updates".]

Hello,

PowerPoint does not provide that level of integration with Excel. To get
that kind of integration you would have to write your own solution (e.g.
VBA) or find some 3rd party solution already developed.

If you (or anyone else reading this message) thinks that is important for
PowerPoint to provide better (or any) support for support for consuming,
viewing and/or interacting with data and documents from other Office
applications (without having to resort to VBA or add-ins), don't forget to
send your feedback (in YOUR OWN WORDS, please) to Microsoft at:

http://register.microsoft.com/mswish/suggestion.asp

As with all product suggestions, it's important that you not just state
your wish but also WHY it is important to you that your product suggestion
be implemented by Microsoft. Microsoft receives thousands of product
suggestions every day and we read each one but, in any given product
development cycle, there are only sufficient resources to address the ones
that are most important to our customers so take the extra time to state
your case as clearly and completely as possible.

IMPORTANT: Each submission should be a single suggestion (not a list of
suggestions).

John Langhans
Microsoft Corporation
Supportability Program Manager
Microsoft Office PowerPoint for Windows
Microsoft Office Picture Manager for Windows

For FAQ's, highlights and top issues, visit the Microsoft PowerPoint
support center at: http://support.microsoft.com/default.aspx?pr=ppt
Search the Microsoft Knowledge Base at:
http://support.microsoft.com/default.aspx?pr=kbhowto

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
 
Back
Top