In Excel 2010, many improvements have been made to the Solver add-in.
Read a blog post or try Office 365!
The Solver Add-in is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel.
To use the Solver Add-in, however, you first need to load it in Excel.
Note: October 20, 2016: When you try to finalize a Solver solution, Excel 2016 gives an error that "File not found Solver32.dll." For a workaround that may get you unblocked while we work on a fix, see the article When you try to finalize a Solver solution, Excel 2016 gives an error that "File not found Solver32.dll".
In Excel 2010 and later goto File > Options
Note: For Excel 2007 click the Microsoft Office Button , and then click Excel Options.
Click Add-Ins, and then in the Manage box, select Excel Add-ins.
In the Add-Ins available box, select the Solver Add-in check box, and then click OK.
Tip If the Solver Add-in is not listed in the Add-Ins available box, click Browse to locate the add-in.
If you get prompted that the Solver Add-in is not currently installed on your computer, click Yes to install it.
After you load the Solver Add-in, the Solver command is available in the Analysis group on the Data tab.
Do you have a specific function question?
Help us improve Excel
Do you have suggestions about how we can improve the next version of Excel? If so, please check out the topics at Excel User Voice