Edit

Share via

Application.Calculation property (Excel)

  • Article

Returns or sets an XlCalculation value that represents the calculation mode.

Syntax

expression.Calculation

expression A variable that represents an Application object.

Remarks

For OLAP data sources, this property can only return or be set to xlNormal.

Example

This example causes Microsoft Excel to calculate workbooks before they are saved to disk.

Application.Calculation = xlCalculationManual 
Application.CalculateBeforeSave = True

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.