Update multiple graphs in PPoint

[ncaravela]

Hi there,

I have a excel wbook with several graphs that i exported to PPoint.
I know how to update the graphs data in PPoint one by one.

Is there any way to updtade all of the graphs at the same time?

I have this code i'm using to do the exact same thing in excel, but i never used VBA code in PP.

Sub Rectânguloarredondado14_Clique()
desproteger
Dim iP As Integer
Application.DisplayAlerts = False
For iP = 1 To ActiveSheet.PivotTables.Count
ActiveSheet.PivotTables(iP).RefreshTable
Next
Application.DisplayAlerts = True
proteger
End Sub

Can anyone help, please? Thanks

[pike]

Hi ncaravela,
you can record macros in PP just like excel - if you record a macro it should give you the basic synatx to work with

[teylyn]

pike, with the abysmal job the macro recorder does in Excel 2007, I sincerely hope it is more helpful in Powerpoint. I have never tried it, but, hey! you never know!

[pike]

ops thanks teylyn there is no macro recorder in pp .

[Andy Pope]

Unfortunately the macro recorder was dropped in ppt2007.

@ncaravela, are the chart in PPT charts, images, pivot charts or msgraph objects.

maybe post an example of the powerpoint file.

[pike]

possibly ....

For iP = 1 To ActiveDocument.Slide.Count
with ActiveDocument.Slide(iP)   
 If .HasChart Then
        .Chart.Refresh
    End If
end with
Next