HomeTroubleshooting@RISK for Excel: Other Issues#NAME Errors in Place of Distribution Functions

8.4. #NAME Errors in Place of Distribution Functions

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

In @RISK or RISKOptimizer, I open a workbook that contains distribution functions. Instead of numeric values I see #NAME errors.

Sometimes a saved workbook will not have correct connections to @RISK. One or more of the following three methods will fix the problem. After fixing the problem, save the workbook and it should be fine the next time you open it.

  1. Set Excel calculation to Automatic:

    • In Excel 2007 or newer, click Formulas » Calculation Options » Automatic.
    • In Excel 2003 or earlier, click Tools » Options » Calculation » Automatic.
  2. Press Ctrl-Alt-F9 to force all cells to recalculate.

  3. If that didn't work, run a simulation with one iteration.

  4. If that also didn't work, change "=" to "=", forcing all formulas to recalculate:

    1. Open the Edit–Replace dialog (Alt-E, then E).
    2. Click Options.
    3. Find what: =
      Replace with: =
      Within: Sheet
      Look in: Formulas
      "Match entire cell contents" NOT checked
    4. Click Find All, then click Replace All.

Once you have resolved the #NAME errors, save your workbook.

Last edited: 2012-11-16

This page was: Helpful | Not Helpful