This documentation is archived and is not being maintained.

Workbook.UpdateLinks Property

Gets or sets a value that indicates a workbook's setting for updating embedded OLE links.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in

public virtual XlUpdateLinks UpdateLinks { get; set; }

Property Value

One of the XlUpdateLinks values.

The following code example uses the UpdateLinks property to display how embedded OLE links are updated in the workbook.

private void DisplayLinkUpdateType()
    switch (this.UpdateLinks)
        case Excel.XlUpdateLinks.xlUpdateLinksAlways:
            MessageBox.Show("Links will always be updated.");
        case Excel.XlUpdateLinks.xlUpdateLinksNever:
            MessageBox.Show("Links will never be updated.");
        case Excel.XlUpdateLinks.xlUpdateLinksUserSetting:
            MessageBox.Show("Links will update according " +
            "to the user settting.");