Creating Powerpoint Slides from Excel work Sheets

knucklehead6

Morning folks,

I have an excel workbook with 13 worksheets on it. These are sheets that will be regularly updated with information, mostly text.

I would like to have each one of these worksheets linked to a separate slide on power point so i only need to update the excel side of things and the slide automatically updates.

I've used the 'insert object' functionality on powerpoint and linked the excel file, however this is at workbook/file level and the 'active' worksheet is the one appearing on the powerpoint slide. Anyone know of a way to have each one of the 13 worksheets hard linked to 13 different slides?

brianwalshcork

Instead of using Insert Object in Powerpoint, start in Excel ... select/highlight your data and press CTRL + C to copy, then in Powerpoint, use the dropdown arrow on the Paste button to select Paste Special, and then select Paste Link - Microsoft Excel Worksheet object.

knucklehead6

https://www.boards.ie/discussion/comment/120552903#Comment_120552903

Thanks Brian

I'm not seeing the past special option in powerpoint though?

knucklehead6

Nevermind... spotted it!!!

Cheers