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?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Spreadsheet in powerpoint presentation
- Thread starter y2k1981
- Start date
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
I don't know if you can do it the other way from Powerpoint Neil Berryman
IT Trainer
neil_berryman@btopenworld.com
- Thread starter
- #3
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.....?
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....!
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....!
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-
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-
- Status