This documentation is archived and is not being maintained.

_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)

int AccuracyVersion { get; set; }

Property Value

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

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.

Setting

Description

0

Use the latest, most accurate algorithms (default)

1

Use Microsoft Office Excel 2007 or earlier version algorithms

2

Use Microsoft Excel 2010 algorithms

Caution noteCaution

Setting the AccuracyVersion 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 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.

Functions affected

Functions not affected

BETADIST

AGGREGATE

BETAINV

BETA.DIST

BINOMDIST

BETA.INV

CHIDIST

BINOM.DIST

CHIINV

BINOM.INV

CHITEST

CEILING

CONFIDENCE

CEILING.PRECISE

CRITBINOM

CHISQ.DIST

CUMIPMT

CHISQ.DIST.RT

CUMPRINC

CHISQ.INV

ERF

CHISQ.INV.RT

ERFC

CHISQ.TEST

EXPONDIST

CONFIDENCE.NORM

FDIST

CONFIDENCE.T

FINV

COVAR

FTEST

COVARIANCE.P

GAMMADIST

COVARIANCE.S

GAMMALN

ERF.PRECISE

GAMMINV

ERFC.PRECISE

HYPGEOMDIST

EXPON.DIST

IPMT

F.DIST

IRR

F.DIST.RT

LOGINV

F.INV

LOGNORMDIST

F.INV.RT

NEGBINOMDIST

F.TEST

NORMDIST

FLOOR

NORMINV

FLOOR.PRECISE

NORMSDIST

GAMMA.DIST

NORMSINV

GAMMA.INV

PMT

GAMMALN.PRECISE

POISSON

HYPGEOM.DIST

PPMT

ISO.CEILING

STDEV

LOGNORM.DIST

STDEVP

LOGNORM.INV

TDIST

MOD

TINV

MODE

TTEST

MODE.MULT

VAR

MODE.SNGL

VARA

NEGBINOM.DIST

VARP

NETWORKDAYS.INTL

VARPA

NORM.DIST

WEIBULL

NORM.INV

XIRR

NORM.S.DIST

ZTEST

NORM.S.INV

PERCENTILE

PERCENTILE.EXC

PERCENTILE.INC

PERCENTRANK

PERCENTRANK.EXC

PERCENTRANK.INC

POISSON.DIST

QUARTILE

QUARTILE.EXC

QUARTILE.INC

RANK

RANK.AVG

RANK.EQ

STDEV.P

STDEV.S

T.DIST

T.DIST.2T

T.DIST.RT

T.DIST.RT

T.INV

T.INV.2T

T.INV.RT

T.TEST

VAR.P

VAR.S

WEEKDAY

WEEKNUM

WEIBULL.DIST

WORKDAY.INTL

Z.TEST

Show: