Home → Troubleshooting → @RISK for Excel: Other Issues → #VALUE Errors When Opening Workbook
Applies to: @RISK, all releases
Sometimes I open my workbook and I see a lot of #VALUE errors, even though @RISK is running. I know my formulas are good, because I can run a simulation without getting #VALUE. What's wrong?
This is an artifact of Excel timing with some workbooks. (You can also see this, sometimes, in pure Excel workbooks.)
Press Ctrl+Alt+F9 to force Excel to recalculate everything.
On rare occasions, that's not enough, and you'll need to force Excel to rescan the workbook for dependencies by pressing Ctrl+Alt+Shift+F9.
If those don't help, you may have Trust Center settings that prevent @RISK from running. Please see Excel Macro Security Settings for guidance.
Last edited: 2017-12-14