[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]
Specifies whether certain worksheet functions use the latest accuracy algorithms to calculate their results.
Assemblies: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
By default, some of the worksheet functions from Excel 2007 and earlier versions of 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 Excel 2007 and earlier versions of Excel. To specify that these worksheet functions use the older algorithms to increase their performance, set the property to 1.
The following table describes the possible settings for the property.
Use the latest, most accurate algorithms (default)
Use Excel 2007 or earlier version algorithms
Use Excel 2010 algorithms
Setting the property to a value other than 0, 1, or 2 will result in undefined behavior.
The following table summarizes which functions are affected by setting the 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 method.
Functions not affected
This property appears in IntelliSense in Excel 2007 projects that target the .NET Framework 4. However, this property cannot be used in Excel 2007 projects.
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.