Excel Solver Not Working? Fix Setup and Model Errors

If Excel Solver is not working, first make sure the Solver Add-in is enabled in desktop Excel, then check that your objective cell contains a formula and that your changing cells and constraints describe the problem correctly. Excel for the web cannot run the Solver Add-in, so open the workbook in the desktop app if Solver is missing there.

Start with the Solver Add-in and your Excel version

On Excel for Microsoft 365 on Windows, enable Solver by choosing File > Options > Add-ins. At the bottom, set Manage to Excel Add-ins and select Go. Check Solver Add-in, then select OK. If Excel asks to install or load the add-in, allow it. Solver should then appear on the Data tab, usually in the Analysis group. If it is already checked but missing, close and reopen Excel and check the add-ins list again.

On Excel for Mac, open Tools > Excel Add-ins, check Solver Add-in, and select OK. Solver is then available from the Data tab. Menu wording and placement can vary slightly by Excel release. In Excel for the web, the desktop Solver Add-in is not available to run; use Open in Desktop App. A workbook containing a Solver model can still be stored or viewed online, but that does not mean the web version can optimize it.

Solver is an included Excel add-in for supported desktop versions, not a separate paid feature. If your work or school computer blocks add-ins, installation may require an administrator. If the Solver Add-in option is absent or produces an installation error, check with your organization’s IT support rather than downloading an unofficial replacement.

Check the model before changing Solver settings

Many apparent Solver failures come from the spreadsheet model rather than the add-in. Solver needs an objective cell whose value changes as the decision cells change. The objective is usually a formula that depends, directly or indirectly, on the changing cells. A typed-in number will not update when Solver tests different decisions.

In Solver, review Set Objective, To, and By Changing Variable Cells. Set Objective should refer to one cell containing the result to maximize, minimize, or set to a particular value. The changing cells should be the actual input cells Solver is allowed to alter. Constraints should compare the relevant calculated cells with limits, such as resource used being less than or equal to resource available.

Confirm that every formula used by the objective and constraints calculates without errors such as #VALUE! or #REF!.
Make sure formulas actually refer to the changing cells. A formula pointing at a different row or a fixed value makes Solver’s changes appear ineffective.
Check that constraints use the intended direction: <= for a maximum limit, >= for a minimum requirement, and = only when an exact match is required.
If quantities cannot be negative, select Make Unconstrained Variables Non-Negative or add explicit lower-bound constraints.
Remove accidental text, merged-cell complications, or blank cells from the changing range; use a compact range of numeric decision cells where practical.

For example, if Solver changes B2 but the objective formula uses A2, the objective will not respond. Try changing one decision cell manually and see whether the objective and constraint formulas update as expected. That simple test often reveals a broken reference faster than changing Solver options.

Choose the solving method that matches the problem

The Solving Method selection matters because Solver uses different approaches for different kinds of models. Choose Simplex LP for a linear model: the objective and constraints are built from linear relationships, with no products of decision variables, powers of decision variables, or nonlinear functions of them. Linear models are often the easiest to diagnose and can produce a clear optimum when the constraints define a feasible region.

Choose GRG Nonlinear when formulas are smooth but nonlinear, such as a model involving a variable multiplied by itself or a smooth curve. GRG can converge to a local optimum, which may not be the best possible answer across the whole search space. Different starting values can sometimes lead to different results, so compare outcomes when the model is nonlinear and the stakes justify further checking.

Choose Evolutionary for models with discontinuities, IF-based decisions, or other relationships that do not work well with the smooth GRG method. It searches more broadly and can take longer; results can depend on settings and may not prove that a global optimum has been found. Integer or binary restrictions may also make a model harder to solve. Do not select a method simply because the previous one failed: first match it to the mathematics.

Fix common messages and stalled searches

If Solver says it cannot find a feasible solution, it may be that no values satisfy all the constraints at once. Check whether limits conflict, whether a required minimum exceeds an available maximum, or whether a cell reference points to the wrong limit. Temporarily inspect the constraints one at a time or calculate the minimum resource use needed to meet the requirements. Do not remove a real business rule merely to force Solver to return an answer.

If Solver reports that it cannot improve the current solution, that is not always proof of a global optimum. For nonlinear models, it may have reached a local solution or stopped based on its tolerances. Review the method, starting values, and formulas. For a linear model, verify that Simplex LP is selected and that the formulas really are linear. For an Evolutionary search, allow more time when appropriate and compare more than one run, while treating the outcome as a search result rather than a guarantee.

If Solver appears to run forever, check for volatile or unusually complex formulas, a large changing range, and unnecessary constraints. Simplify a copy of the model and solve a smaller version first. If the status dialog offers a way to stop, use it rather than repeatedly clicking Solver. A large model with nonlinear, integer, or discontinuous relationships can require substantially more work than a small linear model.

If the answer is unexpected, inspect the final decision values and recalculate the objective and each constraint independently. Look for constraints entered in the wrong direction, unintended integer or binary limits, hidden assumptions about nonnegative values, and rounding in displayed cells. Formatting a value to show zero decimal places does not make the underlying number an integer; use an integer constraint when whole-number decisions are genuinely required.

Work through a small example

A small linear example helps distinguish an add-in problem from a model problem. Suppose a business makes products X and Y. Each unit of X earns 30 and uses two labor hours and one unit of material. Each unit of Y earns 20 and uses one labor hour and two units of material. There are 100 labor hours and 80 material units available. The goal is to maximize profit, with production quantities nonnegative.

Put the quantities for X and Y in B2:C2 and their unit profits, 30 and 20, in B3:C3. With those cell assignments, enter =SUMPRODUCT(B2:C2,B3:C3) in D2 for total profit. Put labor use per unit in B5:C5 as 2 and 1, and material use per unit in B6:C6 as 1 and 2. With production quantities in B2:C2 and labor coefficients in B5:C5, enter =SUMPRODUCT($B$2:$C$2,B5:C5) in D5. With the same quantity cells and material coefficients in B6:C6, enter =SUMPRODUCT($B$2:$C$2,B6:C6) in D6. Put available capacities 100 and 80 in E5 and E6.

Set D2 as the objective to Max, B2:C2 as the changing cells, and add constraints D5<=E5 and D6<=E6. Use Simplex LP and require nonnegative decision values. The intersection of the two resource limits is 40 units of X and 20 of Y: labor use is 2×40 + 20 = 100, material use is 40 + 2×20 = 80, and profit is 30×40 + 20×20 = 1,600. These values provide a check on the model; if Excel returns a different result, inspect the cell references, coefficients, and constraints before assuming Solver itself is broken.

Understand limits, saved settings, and reports

The standard Excel Solver add-in supports up to 200 variable cells. If a model exceeds that limit, reduce or restructure the decision range, or consider a purpose-built optimization tool. Adding many constraints or complex formulas can also make a model slower or more difficult even when it remains within the variable-cell limit.

Solver settings are associated with the worksheet and model, so save the workbook after setting up the problem. A successful run can offer reports such as Answer, Sensitivity, or Limits, but report availability depends on the model and solving method. For example, sensitivity analysis is intended for suitable linear models and is not a universal report for every nonlinear or integer problem. Read a report as a description of the solved model and its assumptions, not as a check that the assumptions themselves are correct.

When troubleshooting a valuable workbook, save a separate copy before making structural changes. You can also record the original decision values and Solver constraints. Solver is an optimization aid: it finds values according to the formulas and limits supplied, but it cannot determine whether those inputs represent reality or whether an omitted condition matters.

Frequently Asked Questions

Why is Solver missing from the Data tab?
On Windows, enable it through File > Options > Add-ins, set Manage to Excel Add-ins, select Go, and check Solver Add-in. On Mac, use Tools > Excel Add-ins. Excel for the web cannot run this desktop add-in.

Why does Solver change the cells but not the result?
The objective formula may not depend on the changing cells, or it may refer to a different range than expected. Change a decision cell manually and confirm that the objective and constraint formulas update before running Solver again.

What does Solver could not find a feasible solution mean?
It means Solver did not find values satisfying all the entered constraints. The limits may conflict, or a cell reference, inequality direction, or decision-cell range may be wrong. Check each constraint against the actual worksheet formulas.

Which Solver method should I use?
Use Simplex LP for linear objectives and constraints, GRG Nonlinear for smooth nonlinear models, and Evolutionary for discontinuous or difficult nonsmooth models. The right choice depends on the equations, not just on which method runs fastest.

Can I use Solver in Excel for the web?
No. The standard Solver Add-in runs in desktop Excel. Open the workbook in Excel for Windows or Mac to set up and run Solver, then save the workbook so its changes are available in the cloud copy.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.