Spreadsheet in powerpoint presentation

[y2k1981]

I don't know if this is possible or not, but hopefully! Is it possible to copy part of a spreadsheet (which contains formulae and hidden columns) into a powerpoint presentation AND be able to enter numbers into it to show the values changing? It's realllllly asking for alot, I know, but I hope it's possible?

 

[nberryman]

If you copy and use Edit Paste Special and check the Pste Link (I think) option the data will remain linked. If you change the spreadsheet in Excel it will update in powerpoint.

I don't know if you can do it the other way from Powerpoint Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[y2k1981]

what I was hoping to be able to do was have a test sheet dispalyed in power point which you would be able to enter data into, and that it would act like a regular spreadsheet. It doesn't need to update any other file, it's just for demonstration purposes. Do you think this would be possible.....?

 

[nberryman]

Can't think of a way, but that doesn't mean it can't be done Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[onedtent]

not sure if this is what ur looking 4, but try this:

on a blank slide, Insert, Object, Microsoft Excel Chart

u will have a chart sheet and datasheet to play with

 

[Hasit]

I dont think this can be done, because you would be asking PP to act like Excel.

You can add formulas etc, BUT once you have finished and you start the PP slideshow, you cannot add or change anything.

What you cold do is have Excel AND PP up running together and make changes to Excel and have a linked spreadsheet in PP which will automagically reflect the changes. This includes graphs etc, so it can be quite sexy....!

 

[onedtent]

finally, the penny drops for me (would that be a dollar by today's standards?)

i just didn't understand what was being asked, please disregard my post

 

[cimberdog]

Yes, it is possible. But, within PowerPoint, you will have to set an action on the Excel object when it is clicked. It's not pretty, but it does work. I am doing this is 2002 (Office XP)

What I did was create 3 columns in Excel and create a formula which was A*B=C. I hid column B, and then copied columns A & C over to PowerPoint.

Then within PowerPoint, I right-clicked on the Excel object I copied over and chose Action Settings. In the Action settings option, you have Edit and Open. I chose Edit, although in this instance they appear to do the same thing. Choose OK and then go to your PPT slide show. When the slide comes up, click on the Excel object. This will take you into Excel with your datasheet showing. Make the change you want (I changed the number in column A). Now close Excel. You will be back to your PPT presentation with the new data reflected. I haven't found a way to do it without bringing up Excel, but at least this keeps you in your rpesentation. The caveat is that you'd need to be sure Excel was installed on that machine.

Hope that helps-