While Extreme speed can greatly decrease simulation run times, not all models are compatible with Extreme speed. When you start a simulation, Crystal Ball detects if the spreadsheet is compatible with Extreme speed and warns you if it is incompatible. If you choose, you can run the simulation in Normal speed using standard Microsoft Excel, or you can change the spreadsheet model to correct the incompatibility.
This section lists functions and formula constructs that are not compatible with Extreme speed and suggests workarounds. Besides the issues listed below, some differences may also exist due to undocumented Microsoft Excel behaviors, changes in the newest versions of Microsoft Excel, and so on. Also, small differences in the last few decimal places of certain built-in function values should be expected, due to minor algorithmic differences in the way formulas might be computed.
It is important to note that incompatibilities in functions and formula constructs only concern the cells involved in the calculation of a forecast cell. If there are incompatibilities in cells that are not part of that calculation path, these are not detected and the simulation is allowed to run.
This section discusses the following compatibility issues: