Embedding Files

Resolved · Low Priority · Version Standard

Fri 7 Mar 2008, 12:16 Delegate Nikki said...

Nikki has attended:
PowerPoint Intermediate Advanced course

Embedding Files

If I want to embed a large excel spreadsheet, how do I ensure that all of the information appears in the pp presentation, probably over several slides?

Thanks

Sun 30 Mar 2008, 19:33 Trainer Mara said...

RE: Embedding Files

Hello Nikki,
I hope you enjoyed your Excel training session with us.

In response to your question, if I understand correctly, you would like to use the same Excel file over multiple slides in your PowerPoint presentation. Is that correct? If so, you may insert the Excel file multiple times in your PPT, and refer to the specific worksheet on the particular slide that you need it. Just make sure you add your Excel object as a link. That way, if you update the workbook, it will update on all your slides as well.

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer

Mon 31 Mar 2008, 09:33 Delegate Nikki said...

RE: Embedding Files

hi there,

I don't think I have really explained myself properly. my problem is that I have a long Excel spreadsheet that spans several sheets which I want to embed in a powerpoint presentation and I want all of the information to appear on the slides. when I tried to embed it, only a small section of the info appeared. how can I ensure that each sheet appears and that all the info is included.

Thanks

Nikki

Tue 1 Apr 2008, 09:20 Trainer Rich said...

RE: Embedding Files

Hi Nikki,

If it's that big, perhaps it would be better to pause the powerpoint slide show, and Alt+Tab to Excel to show the sheet.

ie. before you run your powerpoint slideshow, open the excel file. You can then use Alt+Tab (in Windows) to switch between the applications.

Another thing you could do is to take screenshots (Alt+Printscreen) of the spreadsheet, and paste them in on different slides. Although your images would not be updated if you then update your Excel sheet later.

Normally with embedding Excel sheets into powerpoint, you can set the view. Ie. set which worksheet is showing, and scroll to the point you want to show. When you come out of the embedded object (click out of the box) you can resize the viewable area of the object. So perhaps embed the same excel spreadsheet on a few slides, but adjust the view each time.

Regards, Rich

Training courses