Applies to: @RISK, all releases

Error:

"#VALUE" in one or more cells

 

Cause:

This can be an artifact of Excel timing with some workbooks.

 

Solutions:

1. Press Ctrl+Alt+F9 to force Excel to recalculate the formulas.
2. If this doesn't help, you can force Excel to rescan the workbook for dependencies by pressing Ctrl+Alt+Shift+F9.
3. If 1 and 2 both fail, you may have Trust Center settings that are preventing @RISK from running. 
   1. See Excel Macro Security Settings for guidance.