Workbook.ForceFullCalculation (Excel)

Returns or sets the specified workbook to forced calculation mode.

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.

ActiveWorkbook.ForceFullCalculation = True