Home → Troubleshooting → @RISK for Excel: Other Issues → #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.
Set Excel calculation to Automatic:
Press Ctrl-Alt-F9 to force all cells to recalculate.
If that didn't work, run a simulation with one iteration.
If that also didn't work, change "=" to "=", forcing all formulas to recalculate:
Once you have resolved the #NAME errors, save your workbook.
Last edited: 2012-11-16