HomeTroubleshooting@RISK for Excel: Simulation"The formula ... could not be correctly parsed"

4.29. "The formula ... could not be correctly parsed"

Applies to: @RISK 5.x–7.x

At the start of simulation, I get the error message "The formula formula could not be correctly parsed", or "The formula formula, from cellreference, could not be correctly parsed."

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

As @RISK traces back from your @RISK outputs to your distribution functions, along the way it may find an Excel formula that it doesn't know how to interpret, such as one containing an Excel INDIRECT( ) function. (See Precedent Checking (Smart Sensitivity Analysis) for the complete list of formulas that Smart Sensitivity Analysis cannot handle.)

You can disable Smart Sensitivity Analysis for this model and revert to the @RISK 4.5 style of sensitivity analysis so that the simulation will proceed. 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 palisade.com/Updates to request an update to our current version.

Last edited: 2015-10-14

This page was: Helpful | Not Helpful