Workbook.ForceFullCalculation Property (Excel)
Returns or sets the specified workbook to forced calculation mode. Read/write.
Version Information
추가된 버전: Excel 2007
Syntax
식 .ForceFullCalculation
식 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 (NxM), 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