Automating update of Powerpoint slides from an Excel spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top