Edit

Share via

Workbook.ForceFullCalculation property (Excel)

  • Article

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

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.