Load the Solver Add-in

Show All

Hide All

In Excel 2010, many improvements have been made to the Solver add-in. Read a blog post or try Office 2010!

The Solver Add-in is a Microsoft Office Excel add-in (add-in: A supplemental program that adds custom commands or custom features to Microsoft Office.) 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.

1. Click the Microsoft Office Button , and then click Excel Options.
2. Click Add-Ins, and then in the Manage box, select Excel Add-ins.
3. Click Go.
4. In the Add-Ins available box, select the Solver Add-in check box, and then click OK.
1. Tip    If Solver Add-in is not listed in the Add-Ins available box, click Browse to locate the add-in.
2. If you get prompted that the Solver Add-in is not currently installed on your computer, click Yes to install it.
5. After you load the Solver Add-in, the Solver command is available in the Analysis group on the Data tab.