Palisade Knowledge Base

HomeTroubleshooting@RISK for Excel: Simulation"Out of stack space"

4.52. "Out of stack space"

Applies to:
@RISK 5.x

Problem: When I start a simulation, nothing happens for a while (Excel seems frozen), and if I wait long enough I get an error "Out of stack space".

@RISK 5.0 introduced a feature called Smart Sensitivity Analysis, also known as precedent checking.

Depending on the size or complexity of your model, this precedent checking may finish in a short or long time, or may fail to finish at all. The simplest workaround is to disable Smart Sensitivity Analysis for this model and revert to the @RISK 4.5 style of sensitivity analysis. To do this, click the Simulation Settings icon, select the Sampling tab, and change Smart Sensitivity Analysis to Disabled. Click OK and save the workbook.

The choice of enabling or disabling Smart Sensitivity Analysis can be made for each workbook, and you can also set it in Application Settings to apply to new models. These settings are available in @RISK 5.0.1 and above and in all releases of @RISK in The DecisionTools Suite 5.x. If you do not have this choice, please click Help » About @RISK to verify that you have @RISK 5.0.0, and in that case please visit to request an update to our current version.

last edited: 2010-03-15

This page was: Helpful | Not Helpful