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
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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for