All the models formed through the Math Programming add-in have the
solution option of the Solver add-in that comes with Excel. To use
this add-in it must be installed on your computer. If it is installed
the item "Solver" appears on the Tools menu of Excel. If
the item does not appear on the Tools menu, use the custom installation
procedure on the Excel CD to install it.
The 97-98 version of the Math Programming add-in has an option
to use the Solver add-in automatically. If this automatic option
is chosen and the Excel Solver is the method of solution, models
are automatically loaded into the Solver. Pressing the Solve button
on a model worksheet, automatically calls the Solver to obtain the
To use the automatic option, you must establish contact with the
Solver. If you attempt to create a model with the Excel Solver chosen,
the program will leave the model dialog with a message to establish
contact with Solver. To do this, choose the Solver item from the
Tools menu. The Solver dialog box should appear. Simply close the
dialog. This action creates the desired link. Further attempts to
build models will not be interrupted with the message. This is an
awkward procedure for establishing the automatic operation, but
I couldn't find a better way. If anyone has a suggestion for a better
procedure, please let me know.
The default option for Solver operation is Manual. At every session
in which you plan to use the Automatic option, you must first establish
the connection to the Solver by opening its dialog box. Then change
the option by clicking the automatic key in any of the math programming
This new feature was difficult to accomplish. Although I have tested
it, you may have difficulty on your computer. If so, switch to the
more reliable Manual option. Send me an e-mail detailing the situation
if failure occurs.
All the model dialog boxes have a button called Automatic. Clicking
on the button allows the choice between the Automatic and manual
options. The dialog boxes for the two selections are below. The
default option is the Manual Solver.