_Workbook.AccuracyVersion Property

Gets or sets whether certain worksheet functions use the latest accuracy algorithms to calculate their results.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property AccuracyVersion As Integer
    Get
    Set
'Usage
Dim instance As _Workbook
Dim value As Integer

value = instance.AccuracyVersion

instance.AccuracyVersion = value

int AccuracyVersion { get; set; }

Property Value

Type: System.Int32
Specifies which version of algorithms to use for certain worksheet functions.

Remarks

Read/write

By default, some of the worksheet functions from Microsoft Office Excel 2007 and earlier versions of Microsoft Excel use new algorithms that increase their accuracy. However, in some cases, the new algorithms decrease the performance of these functions relative to their performance in Microsoft Office Excel 2007 and earlier versions of Excel. To specify that these worksheet functions use the older algorithms to increase their performance, set the AccuracyVersion property to 1. The following table describes the possible settings for the AccuracyVersion property.

The following table summarizes which functions are affected by setting the AccuracyVersion property to 1. The functions that are listed in the "Functions not affected" column will always use the latest accuracy algorithms or were not changed in Excel 2010. For function names that include a period (.) in their names, to determine the name of the corresponding function implemented in VBA as a method of the WorksheetFunction object, substitute the underscore character ( _ ) for the period. For example, the VBA method that corresponds to the BETA.DIST function is the Beta_Dist(Double, Double, Double, Boolean, Object, Object) method.

See Also

Reference

_Workbook Interface

_Workbook Members

Microsoft.Office.Interop.Excel Namespace