Excel.Workbook.ForceFullCalculation.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Workbook.ForceFullCalculation property (Excel)	vbaxl10.chm199264	vbaxl10.chm199264	Excel.Workbook.ForceFullCalculation	76f46d18-79e3-9828-d126-e221ae1a8157	05/29/2019	medium

Workbook.ForceFullCalculation property (Excel)

Returns or sets the specified workbook to forced calculation mode. Read/write.

Syntax

expression.ForceFullCalculation

expression An expression that returns a Workbook object.

Return value

Boolean

Remarks

If the workbook is in the forced calculation mode, dependencies are ignored and all worksheets are marked to calculate fully every time a calculation is triggered. This setting remains in effect until Excel is restarted.

Setting the ForceFullCalculation property to True will increase the calculation times for data tables in proportion to the size of the data table. Given an NxM data table, the calculation time will increase by about base time x (N x M) so that a 3x4 data table may take about 12 times as long to calculate if this property is set to True.

Example

The following example sets the active workbook to forced calculation mode.

ActiveWorkbook.ForceFullCalculation = True

[!includeSupport and feedback]