1. In the Solver Parameters dialog box, click Load/Save.
  2. When you save a model, enter the reference for the first cell of a vertical range of empty cells in which you want to save the model specifications. When you load a model, enter the reference for the entire range of cells that contains the model specifications.
  3. Click Save or Load.

TIPS

One set of model specifications — the most recent selections in the Solver Parameters and Solver Options — is maintained for each worksheet in your workbook. When you click the File tab and then click Save, the model selections for each worksheet where a Solver model was defined are saved automatically with the workbook. You can use the Load/Save button to define and save more than one set of Solver model specifications on a single worksheet, and load the model specifications you want at any time.