Automatically update Chart in PowerPoint Presentation RRS feed

  • Question

  • Hi,

    Need help with a macro. I have created a PPT using linked data in excel. There are around 100 charts in the PPT which are linked to single file in excel ( Data is in different Worksheets). I have to manually right click on each of the charts in the PPT and click on Edit data to refresh the data updated in excel file.

    Need help with a macro which would refresh all the the charts in the PPT.

    Saturday, April 1, 2017 7:50 AM