Disable Sheet Calculation

Use this tool to explore the possible effect of combining sheets.

In cases where there is a significant workbook calculation overhead you may be able to simulate the effect of combining the sheets causing the bottleneck by enabling and disabling suspect worksheets and monitoring the effect on workbook wecalculation time.

NOTE: These settings are NOT saved when you save a workbook.

The example workbook used here has a workbook overhead of over 2 Minutes caused by circular worksheet cross-references.

Disabling these sheets reduces calculation time from 136 seconds to 11 seconds.

Subsequently a number of these sheets were merged, resulting in a substantial reduction in calculate time.