Home → Troubleshooting → @RISK for Excel: Other Issues → #NAME Errors in Place of Distribution Functions
Applies to:
@RISK for Excel 4.x–7.x
RISKOptimizer 1.0 and 5.x
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.
Excel or your workbook may be in Manual Calculation mode. See "Does Excel ever change my calculation mode on its own?", the second section of "Calculation Changed to Manual by a Simulation?"
To fix this, set Excel calculation to Automatic:
If you prefer to keep Excel in Manual Calculation mode, press Ctrl+Alt+F9 to force all cells, including @RISK distributions, to recalculate.
If switching to Automatic Calculation or forcing a recalculate didn't work, run a simulation with one iteration.
If that also didn't work, change "=" to "=", forcing all formulas to recalculate:
Important: Once you have resolved the #NAME errors, save your workbook.
If you have any other workbooks set to manual mode, the problem may recur when you open them, and you will need to use the same solution on those workbooks.
Last edited: 2017-07-18