Open Excel Solver Add-in: Enable and Use It

To open Solver in Excel for Microsoft 365 on Windows, enable the Solver Add-in at File > Options > Add-ins, choose Excel Add-ins in the Manage box, select Go, check Solver Add-in, and choose OK. Solver then appears on the Data tab; open it there to set up an optimization model.

What Excel Solver Does

Solver is an optimization tool: it changes selected worksheet values to find the best result for a formula while respecting limits you specify. The formula being optimized is the objective; the cells Solver is allowed to change are the variable cells; and limits such as available labor, budget, or storage are constraints.

For example, a small workshop might want to choose how many units of two products to make. It can maximize total contribution while keeping labor and material use within available amounts. Solver is useful when many combinations are possible and trial and error would be slow. It does not decide whether your assumptions are realistic: it only solves the mathematical model represented by the worksheet.

Enable Solver on Windows

Open Excel’s File tab and select Options.
In Excel Options, select Add-ins.
At the bottom, set Manage to Excel Add-ins, then select Go.
Check Solver Add-in in the list and select OK. If Excel asks to install or activate the feature, accept the prompt.
Return to the worksheet, select Data, and choose Solver, usually in the Analyze group.

This turns on the Solver add-in for Excel; it does not create a new worksheet or put a Solver button inside a cell. If you later stop seeing the command, check the add-ins list again. An Office update, a changed Excel profile, or a disabled add-in can make it necessary to enable it again.

Open Solver on Mac or Excel for the Web

In Excel for Microsoft 365 on Mac, use Tools > Excel Add-ins, select the checkbox for Solver Add-in, and confirm. Then look for Solver on the Data tab. Menu placement and wording can vary slightly by Excel release, so install available updates if the listed command is missing.

The built-in Solver add-in is not available in Excel for the web. Open the workbook in the desktop version of Excel to use it. A workbook can be viewed or edited in a browser, but that does not make the desktop Solver interface available there. If you are collaborating, agree on which desktop user will run Solver and save the resulting workbook for others.

Set Up a Simple Solver Model

A useful model needs formulas that connect the changing cells to the outcome and constraints. Consider a workshop producing products A and B. Put the quantities to make in B2:C2, unit contribution values in B3:C3 (35 and 20), labor hours per unit in B4:C4 (2 and 1), and material per unit in B5:C5 (3 and 2). Assume there are 100 labor hours and 160 units of material available.

With product quantities in B2:C2 and unit contributions in B3:C3, put the objective formula in D2: =SUMPRODUCT(B2:C2,B3:C3). It multiplies each quantity by its contribution and adds the results. With quantities in B2:C2 and labor coefficients in B4:C4, put =SUMPRODUCT($B$2:$C$2,B4:C4) in D4. With quantities in B2:C2 and material coefficients in B5:C5, put =SUMPRODUCT($B$2:$C$2,B5:C5) in D5. D4 and D5 then calculate the resources used.

To configure Solver, open Data > Solver and enter the following:

Set Objective: D2, then select Max because the goal is to maximize contribution.
By Changing Variable Cells: B2:C2.
Subject to the Constraints: D4 <= 100 and D5 <= 160. Add B2:C2 >= 0, or select the option that makes unconstrained variables non-negative.
Select a Solving Method: choose Simplex LP for this linear model. If quantities must be whole units, add an integer constraint for B2:C2.

For this example, a maximum is 40 units of A and 20 of B: labor use is 2×40 + 1×20 = 100, material use is 3×40 + 2×20 = 160, and the objective is 35×40 + 20×20 = 1,800. Select Solve and review the result before choosing to keep the Solver solution. If the model changes, solve it again; old results do not automatically optimize a revised model.

Choose the Right Solving Method

Solver offers methods for different kinds of formulas. Picking a method that matches the model matters: a result is only meaningful if the method can handle the relationships in the worksheet.

Simplex LP is for linear models, where changing a variable has a consistent proportional effect on formulas. The product example is linear.
GRG Nonlinear is intended for many smooth nonlinear models. Nonlinear formulas may have more than one local optimum, so a found solution is not necessarily the best possible across every combination.
Evolutionary can be useful for more complex or discontinuous relationships, including models with formulas that change abruptly. It may take longer and results can depend on its options and starting values.

Integer or binary requirements are constraints, not a separate solving method. Use an integer constraint when a decision represents whole objects, such as people or machines, and a binary constraint when it must be either zero or one. These restrictions can make a problem harder to solve, so begin with the simplest valid model and add only requirements the real decision needs.

Solver Compared with Goal Seek and Scenarios

Goal Seek works backward from one target formula result by changing one input cell. It is a better fit for a question such as “What quantity makes this total equal 500?” when there are no several-variable trade-offs to manage. Solver can change multiple cells and account for multiple constraints while maximizing or minimizing an objective.

Scenario Manager stores and compares sets of input values. It is useful when you already have a few cases to compare, such as low, expected, and high demand. Solver instead searches for a solution based on the model and limits you give it. Neither tool replaces careful checking of formulas or assumptions.

Cost, Availability, and Model Limits

The standard Solver Add-in is supplied with desktop Excel and generally does not require a separate purchase when you have a licensed desktop version that includes Excel. Availability can depend on how Office was installed or managed by an organization. If the checkbox is missing or activation fails, check with your Microsoft 365 administrator or use Office’s repair or update options rather than downloading an add-in from an unfamiliar site.

The included add-in is intended for typical worksheet optimization, not every large-scale industrial problem. Very large models, specialized algorithms, or repeated automated optimization may call for a dedicated optimization package or a different modeling tool. Before choosing one, check that it supports your Excel version, the model’s variable and constraint types, and your organization’s security requirements.

Common Solver Problems and Fixes

Solver is missing from Data: revisit File > Options > Add-ins and enable it through Manage: Excel Add-ins > Go. On Mac, check Tools > Excel Add-ins.
Solver reports no feasible solution: inspect constraints for contradictions, incorrect cell references, or limits that are too restrictive. Temporarily remove a constraint to identify which one prevents a solution, then restore and correct it.
The result looks wrong: confirm the objective cell contains a formula, the changing cells are the intended inputs, and the constraint formulas measure the correct quantities. Check units too: hours should not be compared with minutes unless converted.
Solver stops at an unexpected answer: verify that the selected method fits the formula type. For nonlinear or discontinuous models, test reasonable starting values and review the Solver options; multiple local solutions can exist.
Whole-number decisions are fractional: add an integer or binary constraint where appropriate. Simply formatting a cell to show zero decimal places does not make its underlying value a whole number.

Keep a copy of important inputs before solving. Solver changes variable cells, and accepting its result replaces their prior values. A simple safeguard is to duplicate the worksheet or save a separate workbook version before experimenting with a consequential model.

Frequently Asked Questions

Where is Solver in Excel?
After enabling the Solver Add-in, open the Data tab and select Solver. It is commonly placed in the Analyze group. If the command is absent, check that the add-in is enabled in Excel’s add-ins settings.

Is Excel Solver free?
The standard Solver add-in is included with desktop Excel and ordinarily has no separate add-in fee. You still need access to a desktop Excel license, and organization-managed installations may restrict optional add-ins.

Can I use Solver in Excel online?
No, the built-in Solver add-in does not run in Excel for the web. Use the desktop version of Excel for Windows or Mac to open the Solver interface and solve the model.

Why does Solver say it cannot find a feasible solution?
Usually the constraints cannot all be satisfied at once, or a formula or cell reference does not represent the intended limit. Check the units and bounds, then test the constraints individually to locate the conflict.

Does Solver change my worksheet values?
Solver changes the selected variable cells when it produces a solution and you choose to keep it. Save a copy first if you need to preserve the original inputs; you can also choose to restore the original values after solving.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.