Also available in Spanish: "La fórmula ... no pudo ser paseada correctamente"

Applies to: @RISK 6.x and Up

Error:

"The formula formula could not be correctly parsed", or "The formula formula, from cellreference, could not be correctly parsed."

Background:

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

As @RISK traces backward from your outputs to the underlying distribution functions, it may encounter Excel formulas it cannot interpret—for example, formulas using INDIRECT( ).

• See Precedent Checking (Smart Sensitivity Analysis for the full list of unsupported functions.

Solution:

To prevent the warning and allow the simulation to continue, you can disable Smart Sensitivity Analysis for this workbook.

1. Open Simulation Settings
2. Go to the Sampling tab, and set Smart Sensitivity Analysis to Disabled.
3. Click OK and save the file.

Smart Sensitivity Analysis can be enabled or disabled on a per-workbook basis, and you may also configure the default behavior in Application Settings for new models.

These options are available in versions 6.x through 7.x (excluding @RISK 5.0.0).