Sub update_xl()
Dim oPres As Object
Dim oSld As Slide
Set oPres = ActivePresentation
With oPres
For Each oSld In .Slides
Call xlupdate(oSld)
Next oSld
End With
End Sub
Sub xlupdate(oSlideOrMaster As Object)
Dim oShp As PowerPoint.Shape
For Each oShp In oSlideOrMaster.Shapes
Dim oxl As Excel.Workbook
Dim xlsheet As Excel.Worksheet
If oShp.Type = msoEmbeddedOLEObject Then
Set oxl = oShp.OLEFormat.Object
Set xlsheet = oxl.Worksheets(1)
xlsheet.Cells(1, 1) = 20
End If
Set xlsheet = Nothing
Set xchart = Nothing
Set oxl = Nothing
Next oShp
End Sub