Enable the equation solver Add-in in Excel 2010

Let’s say that, you want to solve certain number of equations in the Excel application. Unless and until the Add-in for solving equations is not enabled in the application, you cannot solve equations and a #NAME! Error will be displayed in a cell when you try solving equations in that particular cell. In this tutorial, you will be guided on how to enable the Add-in for solving equations in Excel 2010 Application.

1) Click on the “File” tab and then on the ‘Options’ tab.


Figure 1



2) In “Excel Options” window, click on the “Add-ins” tab.


Figure 2



3) Under the “Add-ins” tab, choose ‘Excel Add-ins’ option from the drop down list of the ‘Manage’ box and click on the ‘Go’ button.


Figure 3



4) Now, in the ‘Add-ins’ dialogue box thus opened, select the check box that says “Solver Add-in” and click on the ‘OK’ button.


Figure 4



So this is how you can enable the Add-in for solving equations in Excel 2010 Application.



Read Other Applications