Table of contents
TOC
Collapse the table of content
Expand the table of content

LinkFormat.AutoUpdate Property (PowerPoint)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

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

Syntax

expression. AutoUpdate

expression A variable that represents an LinkFormat object.

Return Value

PpUpdateOption

Remarks

The value of the AutoUpdate property can be one of these PpUpdateOption constants.

ConstantDescription
ppUpdateOptionAutomaticThe link is updated each time the presentation is opened or the source file changes.
ppUpdateOptionManualThe link is 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.

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

Concepts

LinkFormat Object

© 2018 Microsoft