Part V: Analyzing Data with Excel
770
Caution
When you close the Solver Results dialog box (by clicking either OK or Cancel) the Undo stack is cleared. In
other words, you cannot undo any changes that Solver makes to your workbook. n
More about Solver
Before presenting more complex examples, this section discusses the Solver Options dialog box.
From this dialog box, you control many aspects of the solution process, as well as load and save
model specifications in a worksheet range.Usually, you want to save a model only when you’re using more than one set of Solver parameters
with your worksheet. This is because Excel saves the first Solver model automatically with your
worksheet (using hidden names). If you save additional models, Excel stores the information in the
form of formulas that correspond to the specifications. (The last cell in the saved range is an array
formula that holds the options settings.)It’s not unusual for Solver to report that it can’t find a solution, even when you know that one
should exist. Often, you can change one or more of the Solver options and try again. When you
click the Options button in the Solver Parameters dialog box, Excel displays the Solver Options
dialog box, shown in Figure 37.8.FIGURE 37.8You can control many aspects of how Solver solves a problem.