HomeTroubleshooting@RISK for Excel: Other Issues#VALUE Errors When Opening Workbook

8.6. #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

This page was: Helpful | Not Helpful