Update Chart in Power Point Slide show

[Abhijeet]

Hi

I want to update Chart automatically in PPT Slide Show.

My excel file is open in 1 system & PPT slide show open in another System so please tell me how to update PPT slide show when excel file update the data

 

[Shteven]

After you copy your Excel chart, go into Powerpoint and on the Home tab, click Paste Special, then click the Paste Link radio button, and finally Microsoft Excel Chart Object.

 

[Abhijeet]

I tried this but when slide show on then its not update

 

[Shteven]

Are the files open in different systems simultaneously while the presentation is happening? That might require a Powerpoint macro bound to a keystroke to update the linked object after the Excel file is saved on the other system. Hopefully one of the ninjas can jump in: I'm not good with vba.

Good luck!

 

[Abhijeet]

yes from different system we update the data but i tried share the excel file then change the data from which system PPT slide On for that system excel files show changed data status but PPT slide wont update

Also i found this code which refresh slides

But still its not work so please give me idea how to do this

Sub RefreshSlide()

        Dim lSlideIndex As Long

        lSlideIndex = SlideShowWindows(1).View.CurrentShowPosition

        SlideShowWindows(1).View.GotoSlide lSlideIndex

        End Sub