Workbook.AccuracyVersion (Excel)

Specifies whether certain worksheet functions use the latest accuracy algorithms to calculate their results.

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 AccuracyVersion property to 1. The following table describes the possible settings for the AccuracyVersion property.

ActiveWorkbook.AccuracyVersion = 1