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
  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