How to update connections to charts that were made in excel using vba in Powerpoint RRS feed

  • Question

  • Hi guys,

    I'm trying to build a a vba code to update automatically the connections where the charts are connected. In excell it will be something like that:

    Private Sub Workbook_Open()
    Application.ScreenUpdating = False
    Application.ScreenUpdating = True


    End Sub

    Which code should i write to do the same when my presentation is open?

    Thanks in advance

    Thursday, February 14, 2013 9:53 AM


  • Suppose your chart name is "Chart 3" is is in Slide 1 of activepresentation,then use below statement.

    ActivePresentation.Slides(1).Shapes("Chart 3").LinkFormat.Update

    Best Regards,
    Asadulla Javed, Kolkata
    Please do not forget to click “Vote as Helpful” if any post helps you and "Mark as Answer”if it solves the issue.

    • Marked as answer by Jose_Dionisio Thursday, February 14, 2013 3:15 PM
    Thursday, February 14, 2013 12:34 PM