To Control a Region Calculation
To enable or disable an automatic update of all results in your worksheet, on the Calculation tab, in the Controls group, click Auto Calculation.
To stop all calculations that are in progress in your worksheet, on the Calculation tab, in the Controls group, click Stop All Calculations. This button is useful when you want to stop an ongoing calculation. When there are no ongoing calculations in the worksheet, Stop All Calculations is not available.
To recalculate all math regions in your worksheet, on the Calculation tab, in the Controls group, click Calculate Worksheet.
To recalculate all math regions that require recalculation from the first page of the worksheets until and including the last visible region in the worksheet, on the Calculation tab, in the Controls group, click Calculate Now.
To enable or disable calculation inside specific regions, select one or more regions, and then on the Calculation tab, in the Controls group, click Disable Region.
Was this helpful?