Share via


OLEObject.AutoUpdate Property

Excel Developer Reference

True if the OLE object is updated automatically when the source changes. Valid only if the object is linked (its OLEType property must be xlOLELink). Read-only Boolean.

Syntax

expression.AutoUpdate

expression   A variable that represents an OLEObject object.

Example

This example displays the status of automatic updating for all OLE objects on Sheet1.

Visual Basic for Applications
  Worksheets("Sheet1").Activate
Range("A1").Value = "Name"
Range("B1").Value = "Link Status"
Range("C1").Value = "AutoUpdate Status"
i = 2
For Each obj In ActiveSheet.OLEObjects
    Cells(i, 1) = obj.Name
    If obj.OLEType = xlOLELink Then
        Cells(i, 2) = "Linked"
        Cells(i, 3) = obj.AutoUpdate
    Else
        Cells(i, 2) = "Embedded"
    End If
    i = i + 1
Next

See Also