Workbook.CalculationVersion (Excel)

Returns the information about the version of Excel that the workbook was last fully recalculated by.

If the workbook was saved in an earlier version of Excel, and if the workbook hasn't been fully recalculated, this property returns 0.

Dim lngCalculationVersion As Long
lngCalculationVersion = ActiveWorkbook.CalculationVersion