Excel OLE within PowerPoint
Posted on 2011-03-02
I would like to imbed excel spreadsheet data into a powerpoint presentation - 4 different views of a single sheet (different columns) onto 4 different slides of a powerpoint (1 view per slide). I would further want to have formulas defined in the active sheet which link the views, so that data entered in one view will activate the associated formula, and update a cell (which is part of a view on another slide). I would then want that new data to be visible on the other pp slide.
Is this possible to do with OLE? And if so HOW? Or is it necessary to handle it via VBScript macro?