Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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 microsoft.office.tools.excel.dll)

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.");
            break;
        case Excel.XlUpdateLinks.xlUpdateLinksNever:
            MessageBox.Show("Links will never be updated.");
            break;
        case Excel.XlUpdateLinks.xlUpdateLinksUserSetting:
            MessageBox.Show("Links will update according " +
            "to the user settting.");
            break;
    }
}

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.