Skip to content

Latest commit

 

History

History
42 lines (25 loc) · 922 Bytes

Excel.Application.Calculation.md

File metadata and controls

42 lines (25 loc) · 922 Bytes
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Application.Calculation property (Excel)
vbaxl10.chm133084
vbaxl10.chm133084
Excel.Application.Calculation
5ae7f2dd-e79a-a4ee-f701-2fff1b77f499
04/04/2019
medium

Application.Calculation property (Excel)

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

[!includeSupport and feedback]