Applies to:
@RISK for Excel 4.x and Up
RISKOptimizer 1.0 and 5.x

 

#NAME errors in @RISK

If you open a workbook with @RISK or RISKOptimizer and see #NAME errors instead of numeric values, possible causes include:

1. Time Series functions in Standard or Professional Edition:

• Time Series functions require @RISK Industrial Edition.

• To use them, contact the Sales Team to upgrade your license. You won’t need to reinstall; an Activation ID will convert your existing @RISK to Industrial Edition.

2. Excel in Manual Calculation mode:

• Check under Formulas » Calculation Options.

• Set it to Automatic to recalculate all @RISK functions.

• Alternatively, press Ctrl+Alt+F9 to force recalculation.

3. Force recalculation if needed:

• Run a simulation with one iteration.

• If still unresolved, use Find/Replace:

  • Press Alt+E, then E to open Replace

  • Find: = and Replace: =

  • Click Options → Within: Sheet, Look in: Formulas, leave "Match entire cell contents" unchecked

  • Click Find All, then Replace All

4. Save your workbook after fixing. If other workbooks are in Manual mode, the issue may recur, so repeat the steps as needed.