Export (0) Print
Expand All
Expand Minimize

Workbook.CalculationVersion Property

Gets a number that indicates the version of Excel that the workbook was last fully recalculated by. The rightmost four digits are the minor calculation engine version number, and the other digits (on the left) are the major version of Microsoft Office Excel.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in microsoft.office.tools.excel.dll)

public virtual int CalculationVersion { get; }

Property Value

A number that indicates the version of Excel that the workbook was last fully recalculated by. The rightmost four digits are the minor calculation engine version number, and the other digits (on the left) are the major version of Microsoft Office Excel.

If the workbook was saved in an earlier version of Excel and if the workbook has not been fully recalculated, then this property returns 0.

The following code example uses the CalculationVersion property to display the version of Excel in which the workbook was last fully recalculated.

private void DisplayCalculationVersion()
{
    if (this.CalculationVersion == 0)
    {
        MessageBox.Show("This workbook has not been calculated.");
    }
    else
    {
        MessageBox.Show("This workbook was last calculated in version " +
            this.CalculationVersion);
    }
}

Show:
© 2014 Microsoft