Automating update of Powerpoint slides from an Excel spreadsheet

[Tony Cann]

I have a spread sheet of data which I have created several pivot tables from.
I have then copy pasted the data in to a selection of Powerpoint slides that
I have created.
I want to know is there a way to be able to just update my master
spreadsheet with new figures and have some way of automatically updating my
powerpoint presentations

 

[Kurt]

Hi Tony,

If you work locally on 1 pc (excel and powerpoint) than you can select your
graph in excel and click Edit-Copy. Then go to powerpoint and choose
Edit-Paste special. That's it. Now when you change your excel information it
will automatically update your powerpoint presentation.

But this will not work when you excel and powerpoint are located on 2
different machines. In that case www.take-off.as/datapoint could offer a
solution for this. With that you can create a graph in powerpoint and have
it linked to your spreadsheet. Every time you save your excel with new
information, datapoint will display this new information.

Good luck
Kurt.