Multiple-Workbook Models

Extreme speed can now run simulations on multiple workbooks. If you are running in Extreme speed and the workbook contains external references to cells in other closed workbooks, Crystal Ball obtains the current value from those workbooks. References to cells in other open workbooks are dynamically updated if those cells depend on one or more assumptions. If the external reference is part of a formula (not a simple external reference), this is not compatible with Extreme speed:

Example message: "Unable to interpret formula at cell location [Book1.xls]Sheet1!A1. (Code #5524 - Complex external reference)"
Workaround: If possible, consolidate all of the variables and formulas from a multiple-workbook model containing Crystal Ball data into a single workbook.