LinkFormat Property Example

This example updates all linked OLE objects on worksheet one.

For Each s In Worksheets(1).Shapes
    If s.Type = msoLinkedOLEObject Then s.LinkFormat.Update
Next