Returns or sets the way the link will be updated. Read/write PpUpdateOption.

Syntax

expression.AutoUpdate

expression A variable that represents an LinkFormat object.

Return Value
PpUpdateOption

Remarks

PpUpdateOption can be one of these PpUpdateOption constants.
ppUpdateOptionAutomatic Link will be updated each time the presentation is opened or the source file changes.
ppUpdateOptionManual Link will be updated only when the user specifically asks to update the presentation.
ppUpdateOptionMixed

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.

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

See also: