_Workbook.AccuracyVersion Property

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

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

public:
 property int AccuracyVersion { int get(); void set(int value); };

public int AccuracyVersion { get; set; }

Public Property AccuracyVersion As Integer

Property Value

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.

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: 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.

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