Setting Up the Excel's Solver Add-in
To use solver:
Look under Excel's Tools menu for Solver.... If you find this listing, your worksheet is ready to use the Solver add-in, and you're finished with these instructions.
Check to see if the Solver Add in is available. From the Tools menu, select add-ins and scroll to see if the solver Add-In is available. If it is, check it off and you're done with these instructions.
Download and install the two Excel Solver Files. I suggest that you place them in the C:\Program Files\Microsoft Office\Office\Library\Solver directory. You'll need to create the directory.
The files are available at solver.xla and solver32.dll. After you have downloaded them, go back to the Tool/add-in area shown and select browse. Move to the area that you just placed the files and Solver. You will not need to do this again for the same computer.
Charlie