none
Disabling links to remote resource in Word & Power Point. RRS feed

  • Question

  • Is there any setting in Word & Power Point interop com interface to disable remote links?

    It is available for Excel workbooks. Check https://msdn.microsoft.com/en-in/library/microsoft.office.interop.excel.workbooks.open.aspx

    Workbook Open( string Filename, Object UpdateLinks, ....

    If we pass 0 to UpdateLinks, it means never update any links (including exteral links, DDE and so on).

    I am looking for similar options for Word & Power Point as well.

    Any help?




    • Edited by tumapath Thursday, July 20, 2017 9:37 AM
    Thursday, July 20, 2017 9:33 AM

All replies

  • Hello,

    >>If we pass 0 to UpdateLinks, it means never update any links (including exteral links, DDE and so on).

    0 means external references (links) will not be updated when the workbook is opened.

    If you want to do the same for Word and PowerPoint, you could use Options.UpdateLinksAtOpen Property (Word) and LinkFormat.AutoUpdate Property (PowerPoint)

    For Word, set Options.UpdateLinksAtOpen to false in the Document_Open event to disable autoupdate.

    Private Sub Document_Open()
    Options.UpdateLinksAtOpen = False
    End Sub

    For PowerPoint, we could set LinkFormat.AutoUpdate into ppUpdateOptionManual, then it would not prompt to update.

    If you want to set the property when Presentation opens, please create an add-in and use Auto_Open macro to registry event handlers. Please visit

    Use Events with the Application Object

    VBA Powerpoint - Auto run on open and run in the background

    Private Sub App_PresentationOpen(ByVal Pres As Presentation)
    For Each sld In Pres.Slides
        For Each sh In sld.Shapes
            If sh.Type = msoLinkedOLEObject Then
            sh.LinkFormat.AutoUpdate = ppUpdateOptionManual
            End If
        Next
    Next
    End Sub

    Regards,

    Celeste


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Friday, July 21, 2017 4:00 AM
    Moderator