If Excel Solver is not responding, first give it a moment: Solver may be calculating a difficult model rather than being stuck. If Excel remains unresponsive, use Solver’s Stop button if it is available, then check the Solver add-in, the model’s formulas and size, and the solving method before trying again.
Is Solver frozen or still working?
Solver searches for values in selected cells that make an objective formula reach a target while meeting your constraints. A model with many changing cells, complicated formulas, or difficult constraints can take much longer than a simple example. During a solve, Excel may display a Solver status dialog, show an unresponsive window, or appear to pause while calculations run. Those signs alone do not prove that the application has crashed.
Look for signs of progress before interrupting it. If the Solver status window is visible, read its message and use its Stop button to end the search safely. A changing objective value or changing variable values can indicate that it is still searching. If the whole Excel window is unresponsive and there is no visible status dialog, wait briefly and avoid repeatedly clicking the window; repeated input can queue up and make recovery more confusing.
Before stopping or closing Excel, consider whether the workbook contains unsaved work. If Excel becomes responsive again, save a copy before changing the model. If the application is genuinely hung, Windows Task Manager can close it, but ending the task can discard unsaved changes. Excel may offer recovered workbooks when restarted, but recovery is not guaranteed.
Check that the Solver add-in is available
On Excel for Microsoft 365 on Windows, Solver is a built-in Excel add-in that may need to be enabled. If Solver is missing from the Data tab or selecting it appears to do nothing, check the add-in before troubleshooting the model:
- Choose File > Options > Add-ins.
- At the bottom, set Manage to Excel Add-ins and select Go.
- Check Solver Add-in, select OK, then look for Solver on the Data tab.
If Solver is already checked, close and reopen the Solver Parameters dialog. If it still fails, return to the same add-ins screen, clear the check box, select OK, then enable it again. This reload can help when the add-in did not initialize correctly. In a work or school installation, an administrator may restrict add-ins; contact your organization’s support team if the setting is unavailable or changes do not persist.
Excel for Mac also offers Solver as an add-in, but its add-in controls differ: use Tools > Excel Add-ins and enable Solver Add-in. Excel for the web does not run the desktop Solver add-in. Open the workbook in the desktop app to use Solver rather than expecting the Data tab in a browser to provide the same feature.
Make the model smaller and easier to solve
A useful diagnostic is to test a smaller copy of the model. Keep the same basic structure, but reduce the number of changing cells or use fewer rows of sample data. If that copy solves, the original may be computationally demanding rather than broken. The standard Solver add-in supports up to 200 changing variable cells, so a model that exceeds that limit needs to be redesigned or handled with a different tool.
Also check whether each changing cell is genuinely needed. For example, if a production model has one decision cell for every product at every location, some cells may be fixed at zero or combined without changing the real business question. Fewer decision variables and fewer unnecessary constraints generally make the search easier to manage. Do not remove a real requirement merely to make Solver finish; simplify only where the model remains a faithful representation of the problem.
Large worksheet formulas can also make each Solver step expensive. A changing cell may feed hundreds or thousands of formulas, which then feed the objective and constraints. Try to avoid unnecessary layers of repeated calculations, and check for formulas that reference entire columns when a smaller range is sufficient. Volatile functions, such as RAND and NOW, can recalculate frequently and make a model harder to reproduce. Replace them with fixed input values during a solve if that is appropriate for the analysis.
Keep a record of the starting values in the changing cells. Solver may update them as it searches, and the final values may not be the values you started with. A copy of the workbook lets you compare results and recover the original setup if you need to revise the model.
Choose the solving method that fits the formulas
In Solver Parameters, the Select a Solving Method control offers methods suited to different kinds of models. Choosing an unsuitable method can lead to a long search, failure to find a result, or a result that is not useful.
- Simplex LP is intended for linear models: the objective and constraints must change linearly with the decision variables. It is often the right choice for allocation, blending, or scheduling models expressed with linear relationships.
- GRG Nonlinear is for smooth nonlinear models. A formula involving products of changing cells or other nonlinear relationships may require it. The result can depend on the starting values, and a local solution is not necessarily the best solution over every possible combination.
- Evolutionary can handle models with discontinuities or formulas that are not smooth, such as certain IF-based decision rules. It may require substantially more time and can return different results on different runs.
If the model is linear but Solver is set to GRG Nonlinear, switch to Simplex LP and check whether the solve becomes faster. Conversely, a formula with a changing-cell product is generally nonlinear, so treating it as a linear model can make the chosen method inappropriate. Solver’s method does not repair incorrect formulas or constraints: confirm that the model expresses the intended problem before interpreting any result.
Inspect formulas, references, and constraints
Solver can appear to stall when the model contains an error that prevents meaningful progress. In Solver Parameters, verify that Set Objective points to a single formula cell, By Changing Variable Cells contains the intended decision cells, and each constraint refers to the correct cells and relationship. A constraint that accidentally covers a much larger range than intended can make the search harder or make the problem infeasible.
Check that the objective and constraint formulas actually depend on the changing cells. If a formula points to the wrong range or contains a hard-coded value, changing the decision cells may not change the objective at all. Also inspect for error values such as #VALUE!, #REF!, or #DIV/0! in cells used by the objective or constraints. Correct those errors in the worksheet first; Solver cannot optimize a formula that does not calculate to a usable value.
Try the model manually with a few different starting values. If the objective does not change, the decision cells may not be connected to it. If a constraint formula produces an error for some values, the search may fail when it reaches those values. Starting from a feasible set of values—one that already satisfies the constraints—can help, particularly with nonlinear models. For an integer or binary decision problem, confirm that the intended integer or binary constraints are present, rather than expecting Solver to infer them.
Review calculation settings and Solver limits
Excel’s calculation mode can affect how quickly the model updates. On Windows, check File > Options > Formulas and look at Workbook Calculation. Automatic calculation is the usual choice for a Solver model because formulas need to update as changing cells change. Manual calculation can leave displayed values out of date unless recalculation is triggered, which can make it difficult to judge what Solver is doing. If you change this setting, consider the needs of the whole workbook, not just Solver.
Solver Parameters includes Options for controlling its search. Depending on the selected method, options can include a time limit, iteration limit, precision, and convergence settings. A very low time or iteration limit can stop a model before it finds a useful result; a very generous limit can leave a difficult search running for a long time. Increase limits only after confirming that the model is correctly configured and that waiting longer is likely to help.
Precision and convergence are not the same as a guarantee of a perfect answer. They control aspects of Solver’s stopping criteria, and very tight tolerances can require extra work without making a practical result meaningfully better. If a result is close to the required target, compare the remaining difference with the scale and accuracy of your inputs. Do not interpret a numerical solution as proof that the underlying assumptions are correct.
Recover, retry, and prevent repeat hangs
If Solver is still running but you need to stop it, use Stop in its status dialog when possible. After Excel responds, save a separate copy, note the objective and changing-cell values, and simplify or correct one aspect of the model at a time. Changing the solving method, removing an unnecessary constraint, and reducing the number of variables are separate tests; changing all of them at once makes it harder to identify the cause.
If Excel has crashed, reopen it and look for a Document Recovery pane or recovered version. Save recovered work under a new name before continuing. If the problem happens in several workbooks, not just one, restart Excel and check whether other add-ins or a damaged installation may be involved. If only one workbook causes the problem, focus first on that workbook’s formulas, data size, and Solver setup.
For repeatable work, save a clean starting copy, document the solving method and important constraints, and keep a small test case. That makes it easier to distinguish a Solver problem from a model that is simply too complex. If a genuine model needs more than the standard add-in’s variable limit or repeatedly exceeds practical solve times, consider redesigning the model or using a purpose-built optimization tool rather than allowing Excel to run indefinitely.
Frequently Asked Questions
Why does Excel say Solver is not responding?
Solver may be calculating a demanding model, especially one with many changing cells, nonlinear formulas, or difficult constraints. It can also stop responding because of an add-in initialization problem or an error in the workbook. Check the status dialog, then test a smaller copy and verify the model inputs.
How long should I wait for Solver?
There is no single reliable wait time: a small linear model may finish quickly, while a large nonlinear search can take much longer. If the status dialog shows progress, give it time appropriate to the workbook. If there is no progress or Excel remains frozen, stop safely when possible and investigate the model rather than repeatedly launching Solver.
How do I stop Solver without closing Excel?
When Solver displays its search-status window, select Stop. Once Solver stops, Excel should return control and let you inspect the result or revise the setup. If the entire application is unresponsive and the Stop control cannot be reached, ending Excel through Task Manager is a last resort and may lose unsaved work.
Can I use Solver in Excel for the web?
The desktop Solver add-in is not available to run in Excel for the web. Open the workbook in Excel for Windows or Mac and enable the Solver add-in in that desktop version. You can still store and share the workbook online, but use the desktop app for the Solver operation.
Does Solver always find the best answer?
No. Results depend on the model, starting values, method, and stopping criteria. Nonlinear methods can find a local solution rather than a global best, and an incorrect or incomplete model can produce a technically valid but unsuitable result. Check feasibility and assumptions before relying on the answer.
Related
- Excel Remove Duplicates: How It Works and When to Use It
- Excel Remove Duplicates Greyed Out? Fixes That Work
- Excel Remove Duplicates from a Table Without Losing Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Can You Make One Page Landscape in Word?Yes. In Microsoft Word for Microsoft 365 on Windows, insert a Next Page section break before and after…
- How to Insert a Line Break in Word (Not a New Paragraph)To insert a line break in Microsoft Word without starting a new paragraph, place the cursor where the…
- Excel Hyperlink Shortcut: How to Add a LinkTo add a hyperlink in Excel for Microsoft 365 on Windows, select a cell and press Ctrl+K. Choose…
- Free Debt Snowball Spreadsheet for Google Sheets: SetupYes. You can make a free debt snowball spreadsheet in Google Sheets by listing each debt, its current…
- Delete a Page in Word Using Ctrl+G: Step-by-Step GuideTo delete a page in Word with Ctrl+G on Windows, press Ctrl+G, enter \page in the Go To…
- Google Sheets Iframe Embed: How to Publish and Use ItTo embed a Google Sheet in a webpage, open it in a browser and choose File > Share…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.