HomeTroubleshooting@RISK for Excel: SimulationCalculation Changed to Manual while Browsing Results?

4.4. Calculation Changed to Manual while Browsing Results?

I have set Excel calculation to Automatic, but after I ran a simulation I saw that calculation was changed to Manual. The Browse results window is open; does that change calculation mode?

Yes, that's by design. To make browsing work properly, @RISK has to put Excel into Manual calculation mode. If you were in Automatic calculation before Browse Results, you will be in Automatic again when you close that window, or if you change it from a callout to a floating window. (To make that change, click the last icon at the bottom — see illustration.)

Note also that Excel may change calculation mode when you open a workbook, and the change persists even after that workbook is closed. See Calculation Changed to Manual by a Simulation?

Last edited: 2015-06-26

This page was: Helpful | Not Helpful