AutoUpdate Property

Applies To

LinkFormat object.

Description

Returns or sets the way the link will be updated automatically (each time the presentation is opened or the source file changes) or manually (only when the user specifically asks to update the presentation). Can be one of the following PpUpdateOption constants: ppUpdateOptionAutomatic, ppUpdateOptionManual, or ppUpdateOptionMixed. Read/write Long.

Example

This example loops through all the shapes on all the slides in the active presentation and sets all linked Microsoft Excel worksheets to be updated manually.

For Each sld In ActivePresentation.Slides
    For Each sh In sld.Shapes
        If sh.Type = msoLinkedOLEObject Then
            If sh.OLEFormat.ProgID = "Excel.Sheet.8" Then
                sh.LinkFormat.AutoUpdate = ppUpdateOptionManual
            End If
        End If
    Next
Next