PowerPoint Problem

[robertgrumbles]

I have an excel file with several tabs and I want to embed information from different tabs on different slides of a powerpoint. I would rather not link the powerpoint and excel file, but would like to embed because I'm trying to make it user friendly for other people to use and I think linking with other files may confuse some.

I've been trying to figure it out but have been unsuccessful. If anyone can help it would be much appreciated.

Thanks!

 

[Chris Macro]

If I understand your question correctly, you want to have the ability to change the data from within PowerPoint but you don't want the image linked to the Excel file?

 

[robertgrumbles]

Yes - exactly. I have tables and charts that I want to be able to give users the ability to change on the fly in a print friendly format.

 

[Chris Macro]

I'm just throwing out an educated guess here, but if you right click on your "Excel Object" in PowerPoint and go to Worksheet Object > Convert and choose a different format (maybe Binary Worksheet), maybe that will unlink it from the original file (I'm using 2007 right now, there might be a better way to do this in a later version of Office)

 

[Chris Macro]

Also you could insert a new Excel object (Insert Ribbon tab > Object > Microsoft Excel Worksheet) and copy your spreadsheet stuff into the embedded worksheet. Not sure how complicated your worksheet is so this may or may not be a viable solution.

 

[robertgrumbles]

I will check Jolicharts. Thanks!

Chris - the problem is that when you embed in powerpoint it seems like you can only use one workbook at a time. You can't use the same embedded workbook for multiple slides. So say I have a table on tab 1 that I want to show in slide 1 and then a chart that's linked to the table in tab 2 that I want to show on slide 2. You don't seem to be able to do that. But maybe I missed something so was hoping one of you gurus would be able to show me a way to do it.

 

[robertgrumbles]

Right now it looks like I'll just be best served formatting the spreadsheet to look like the powerpoint slides and then have a macro print to pdf for me.

 

[Chris Macro]

Ok, I see what you are trying to do. PowerPoint wasn't really designed to be an extension of Excel to do analysis. I always recommend fiddling with numbers inside Excel and then exporting final copies of your data/charts into PowerPoint (as a picture). Is there a reason you have to give this data out inside a PowerPoint and not just in an Excel sheet? Here is a link that can show you how to automate copy/pasting Excel data into PowerPoints with a macro. You can easily do the same for Excel Charts as well.

 

[robertgrumbles]

Again - just trying to make it user friendly. The people in my company are not very excel savy...or powerpoint savy for that matter. So I was trying to have everything in one place instead of having to do the calculations in a separate excel sheet and then export it or link it etc. I want to be able to make it so they just have to input the data and then analysis spits out in a printer friendly format. I think I will probably just do it out of excel and design the sheets to look like slides.

 

[Chris Macro]

Good deal. Have fun