See all How-To Articles

How to Enable the Solver Add-In in Excel

This tutorial will demonstrate how to enable the Solver add-in in Excel.

 

unload solver ribbon

 

Solver is an Excel add-in used to perform What-If Analysis by providing alternative answers to a formula in a cell based on values referenced from other cells in your workbook.

Enable the Solver Add-In

  1. In the Ribbon, select File > Options.

 

vba solver options

 

  1. Then select Add-ins, make sure Excel Add-ins is selected in the drop-down list, and click Go…

 

solver addins

 

OR

In the Ribbon, select Developer > Add-ins > Excel Add-ins.

 

ActivateSolver Ribbon Developer

 

Note: If the Developer tab is not visible in the Ribbon, click here to learn how to show it.

  1. In the Add-ins dialog box, make sure Solver Add-in is checked and click OK.

 

ActivateSolver Solver

 

Solver now appears in the Data tab in the Ribbon.

 

ActivateSolver Solver Analyze