LinkFormat object (PowerPoint)

Contains properties and methods that apply to linked OLE objects, linked pictures, and IIRC media objects.

Example

Use the LinkFormat property to return a LinkFormat object. The following 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.12" Then

                sh.LinkFormat.AutoUpdate = ppUpdateOptionManual

            End If

        End If

    Next

Next

The following example loops through all the shapes on all the slides in the active presentation and updates linked Microsoft Excel charts before setting them to be updated automatically.

For Each sld In ActivePresentation.Slides

    For Each sh In sld.Shapes

        If sh.HasChart Then

            If sh.Chart.ChartData.IsLinked Then

                Call sh.LinkFormat.Update
                sh.LinkFormat.AutoUpdate = ppUpdateOptionAutomatic

            End If

        End If

    Next

Next

Methods

Name
BreakLink
Update

Properties

Name
Application
AutoUpdate
Parent
SourceFullName

See also

PowerPoint Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.