Excel Solver Not Finding a Solution? Troubleshoot It

How-to basics · Updated November 21, 2026

If Excel Solver is not finding a solution, first check that the objective cell depends on the changing cells, the constraints are consistent, and the selected solving method fits the formulas in your model. Solver can report that a model is infeasible, fail to converge, or return a result that looks wrong; each outcome points to a different problem.

What Solver’s message is telling you

Solver is an optimization add-in, not a general-purpose error checker. It searches for values in selected cells that make an objective cell as large, as small, or as close as possible to a specified value while satisfying the constraints you set. A message that it could not find a feasible solution means it could not find values meeting all the stated requirements. That may indicate contradictory constraints, but it can also result from a poor model setup or an unsuitable method.

Other messages can indicate that Solver stopped before reaching a satisfactory result, reached a limit, or found a solution that meets its stopping criteria. A completed search does not automatically prove that the answer is meaningful: check the resulting cell values and confirm that they satisfy the real-world requirements. If Solver returns a result but it is not the best possible one, the model may also have multiple local optima or a method that is not appropriate for the problem.

  • No feasible solution: Look for conflicting limits, incorrect cell references, or variable bounds that rule out every combination.
  • Unsuccessful or incomplete search: Check the solving method, starting values, and search limits.
  • A surprising result: Verify that the objective and constraints represent the question you intend to solve.

Check the Solver model from the top down

In Excel for Microsoft 365 on Windows, open the Data tab and choose Solver. If Solver is missing, enable the add-in through File > Options > Add-ins. At the bottom, select Excel Add-ins in the Manage box, choose Go, and select Solver Add-in. Then return to the Data tab.

In the Solver Parameters window, review the model in this order:

  1. Set Objective: Select the one cell containing the result to optimize. Choose Max, Min, or Value Of as appropriate.
  2. By Changing Variable Cells: Select every input Solver is allowed to adjust. These cells should actually feed into the objective, directly or through formulas.
  3. Subject to the Constraints: Check each limit, comparison sign, and cell reference. A constraint intended as “at least 10” should not accidentally be entered as “less than or equal to 10.”
  4. Make Unconstrained Variables Non-Negative: Decide whether negative values are genuinely allowed. If quantities cannot be negative, enforce non-negativity here or with explicit constraints.
  5. Select a Solving Method: Choose a method that matches the structure of the calculations, not just the one that happens to be selected.

A frequent setup mistake is choosing a displayed output cell as the changing cell instead of the input that drives it. Another is leaving a required decision cell out of the changing range. If the objective does not change when you alter the selected variables manually, Solver cannot optimize it. Check the worksheet formulas and references before changing Solver options.

Choose the right solving method

The method selector matters because different algorithms make different assumptions about your model. Solver’s three common methods are Simplex LP, GRG Nonlinear, and Evolutionary.

  • Simplex LP is for linear models: the objective and constraints are linear combinations of the changing cells. It is usually the right choice for straightforward allocation, production, or transportation models. Multiplying a decision variable by a fixed coefficient is linear; multiplying one changing variable by another is not.
  • GRG Nonlinear is intended for smooth nonlinear formulas. It can work well when small changes in the inputs produce gradual changes in the results. Because nonlinear problems can have more than one local optimum, different starting values may lead to different answers.
  • Evolutionary can handle models with discontinuities or formulas that change in jumps, such as some models involving IF logic or discrete choices. It searches in a different way and may take longer; results can depend on the search settings and starting model.

For example, a model that maximizes a linear sum of unit profits subject to linear resource limits is a natural Simplex LP problem. A formula involving a changing variable raised to a power may need GRG Nonlinear if it is smooth. A model where a decision triggers a sharp yes-or-no change may need Evolutionary or a reformulation. Choosing the wrong method can make a valid model appear difficult or prevent Solver from finding the answer you expect.

Find conflicting or impossible constraints

When Solver says there is no feasible solution, examine whether the requirements can all be true at once. For instance, a variable cannot simultaneously be constrained to be at least 12 and at most 8. Less obvious conflicts can arise from several resource limits, minimum targets, integer requirements, or formulas that convert inputs into the constrained results.

A useful diagnostic is to temporarily remove one constraint at a time, solve again, and note which removal makes a solution possible. This is a test, not a final fix: restore the constraint and determine whether its value, sign, or cell reference is wrong. You can also calculate the smallest possible and largest possible values of a constrained result by hand or in separate worksheet cells. If a required target falls outside that range, no Solver method can satisfy it.

Check units and scale as well. A capacity entered as 500 when the worksheet uses thousands, or a percentage entered as 5 instead of 5%, can make the model seem impossible. Confirm that upper and lower bounds are not reversed, that equality constraints are intentional, and that integer or binary restrictions are truly required. Adding an unnecessary integer restriction can make a model harder to solve.

Make sure formulas connect inputs to results

Solver changes cell values; it does not rewrite worksheet formulas to make a model work. The objective and any calculated constraint cells must update when the changing cells change. Check for hard-coded totals, references to the wrong row, formulas that omit some variables, and cells containing text where a number is expected. Also check whether workbook calculation is set to automatic; with stale results, the worksheet may not reflect the current inputs consistently.

Here is a small linear example. With product quantities in B2:C2, unit contributions in B3:C3, and total contribution in D2, enter =SUMPRODUCT(B2:C2,B3:C3) in D2. If the quantities are 4 and 6 and the contributions are 40 and 30, the result is 340.

With resource use per unit in B4:C4 and total resource use in D4, enter =SUMPRODUCT(B2:C2,B4:C4) in D4. If the resource coefficients are 2 and 1, the same quantities use 14 units. A second resource can be calculated in D5 from coefficients in B5:C5 using =SUMPRODUCT(B2:C2,B5:C5); coefficients of 1 and 2 produce 16 units. In Solver, maximize D2 by changing B2:C2, and constrain D4 and D5 to be no greater than their capacity cells. The example is only meaningful if the quantities, contributions, and capacities use consistent units.

Review starting values and Solver options

Starting values can matter, especially for nonlinear problems. Enter plausible values in the changing cells before running Solver rather than beginning with extreme, blank, or invalid values. For a nonlinear model, try more than one reasonable starting point. If Solver repeatedly reaches a poor result from one start, another start may lead it toward a different solution; that does not, by itself, prove the second result is globally best.

In the Solver Parameters window, choose Options to review limits and tolerances. A strict precision or constraint tolerance can affect whether a nearly feasible result is accepted. A low iteration or time limit can stop a search early. Increase limits only when there is a reason to allow more search time; doing so will not correct a faulty formula or an impossible model. Automatic scaling can help with models whose values differ greatly in magnitude. Make one change at a time and compare the outcome so you know what affected the search.

For integer or binary decisions, verify that the restrictions are attached to the correct cells. Also consider whether the model can be simplified: fewer changing cells and clearer formulas can make diagnosis easier. Avoid rounding intermediate calculations unless the real problem requires rounding; rounding can create abrupt jumps and change the mathematical model Solver sees.

Know when to use another tool or reformulate

The built-in Solver add-in has a limit of 200 changing variable cells. A model larger than that may need to be reduced, split into smaller linked problems, or handled with another optimization tool. For smaller models, a cleaner formulation can also help: remove redundant constraints, calculate repeated expressions once in helper cells, and separate decision inputs from reported results.

Excel for the web does not run the desktop Solver add-in. Open the workbook in the desktop application to use Solver. On Mac, Solver is available as an Excel add-in; enable it from Tools > Excel Add-ins, select Solver Add-in, and then use Solver from the Data tab. Interface details can vary slightly by Excel release, but the model still needs an objective, changing cells, constraints, and an appropriate method.

If the problem is a simple one-variable calculation, Goal Seek may be enough. In desktop Excel, use Data > What-If Analysis > Goal Seek; it sets one formula cell to a target by changing one input. Goal Seek does not handle multiple changing cells and constraint sets like Solver does. For larger or specialized optimization models, dedicated optimization software may be more suitable than forcing a complex model into the add-in.

Frequently Asked Questions

Why does Excel Solver say there is no feasible solution?
Usually, at least one constraint conflicts with another or with the variable bounds. Check the constraint signs and cell references, confirm units, and test constraints one at a time to locate the conflict.

Which Solver method should I use in Excel?
Use Simplex LP for linear objectives and constraints, GRG Nonlinear for smooth nonlinear formulas, and Evolutionary for suitable discontinuous or jump-based models. If unsure, inspect how the objective and constraints depend on the changing cells.

Why does Solver return a different answer when I run it again?
Nonlinear or Evolutionary searches can be sensitive to starting values and settings, and a nonlinear model may have multiple good solutions. Check whether the results satisfy every constraint and try reasonable alternate starting values.

Can Excel Solver handle integer or binary values?
Yes. Add an integer or binary restriction to the appropriate changing cells in Solver. Use these restrictions only when the real decisions must be whole numbers or 0/1, because they can make the search more demanding.

Can I use Solver in Excel for the web?
No, the desktop Solver add-in is not available to run in Excel for the web. Open the workbook in desktop Excel for Windows or Mac and enable Solver if it is not already available.

Does a Solver solution prove it is the best answer?
Not in every model. A successful result should satisfy the stated model, but nonlinear searches can find local rather than global optima, and an incorrect model can produce a mathematically valid but irrelevant answer. Validate the result against the original problem.

Related

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.