Yes, Excel Solver can be slow, especially when each trial solution forces a large workbook to recalculate or when the model includes nonlinear formulas, integer choices, or difficult constraints. The most effective fixes are to simplify the formulas Solver must recalculate, choose the right solving method, and check whether the model is correctly set up before raising Solver’s time or iteration limits.
Why Excel Solver can take a long time
Solver does not usually find an answer by changing cells just once. It proposes values for the changing cells, recalculates the worksheet, checks the objective and constraints, and then decides what values to try next. A model that recalculates quickly may finish in seconds; the same Solver settings can take much longer when each recalculation involves thousands of formulas or a complicated calculation chain.
Runtime also depends on the problem itself. A smooth model with a clear direction toward a better result can be relatively easy. A model with many possible combinations, several local optima, or no feasible solution may require much more searching. Adding binary or integer restrictions can make a problem considerably harder because Solver must account for discrete choices as well as the objective.
- Workbook cost: Volatile functions, long chains of dependent formulas, large lookup ranges, and repeated calculations can make every Solver trial expensive.
- Model difficulty: Nonlinear relationships, discontinuities, and many integer decisions can make it harder to identify a good solution.
- Model setup: Incorrect cell references, redundant constraints, or a mismatched solving method can waste time or prevent progress.
- Stopping settings: A high time or iteration limit gives Solver permission to keep searching longer; it does not guarantee that the model will find a better answer.
How Solver searches for a solution
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, choose Excel Add-ins in the Manage box, select Go, and check Solver Add-in. Excel for the web does not run the built-in Solver add-in; use desktop Excel for this workflow. On Mac, enable Solver through Tools > Excel Add-ins, then use the Solver command on the ribbon if available in your Excel version.
In the Solver Parameters dialog, you identify an objective cell, choose whether to maximize, minimize, or set it to a value, specify changing cells, and add constraints. Solver then uses the selected engine. Picking the engine that matches the formulas matters: a method intended for smooth nonlinear problems is not a good substitute for a linear model’s method, and neither is designed to handle every kind of discontinuity equally well.
- Simplex LP: Use this for a linear model, where the objective and constraints are linear combinations of the changing cells. It is often the appropriate choice for product mix, shipping, or resource allocation models with linear costs and limits.
- GRG Nonlinear: Use this for smooth nonlinear models. It can be suitable when formulas curve gradually, but results can depend on the starting values and the model may have local optima.
- Evolutionary: Consider this for models with discontinuous or nonsmooth relationships, or where the other methods are unsuitable. It searches more broadly and may take substantially longer.
Check what is actually taking time
First distinguish a slow Solver search from a slow workbook. Before opening Solver, change one input cell that affects the model and see how quickly the objective and constraint cells update. If ordinary recalculation is already slow, Solver will repeat that cost many times. If recalculation is quick but Solver runs for a long time, the search method, constraints, or problem complexity are more likely causes.
Next, inspect the Solver status message and the worksheet values when it stops. A message that it found a solution is different from a message that it stopped at a time or iteration limit, or could not find a feasible solution. Infeasibility is not simply slowness: it means Solver could not find values satisfying all the stated constraints under its search. Check whether limits conflict, whether the changing cells have sensible bounds, and whether the objective and constraints point to the intended cells.
Try a small diagnostic run with a lower time or iteration limit, then compare the returned values with the starting values. If the objective improves quickly and then barely changes, extra search may have diminishing returns. If it does not improve at all, investigate the model and method rather than assuming that a larger limit will fix it. Save a copy before making substantial changes to a workbook or its Solver setup.
Ways to speed up the worksheet calculations
Because Solver repeatedly recalculates the worksheet, reducing the cost of one calculation can make a noticeable difference. Focus first on formulas that feed the objective and constraints, not on unrelated formatting. A large workbook does not automatically mean a slow model; the important question is how much work is triggered by recalculating the cells Solver depends on.
- Replace unnecessarily broad references with ranges that cover the data actually used. For example, formulas that search or aggregate an entire column may do more work than formulas limited to the relevant rows.
- Reduce repeated calculations. If the same complex expression appears in many formulas, calculate it once in a helper cell or range and refer to that result where appropriate.
- Review volatile functions, such as
OFFSETandINDIRECT. These can cause additional recalculation when the workbook changes. Keep them only where their behavior is needed. - Remove obsolete formulas from large ranges and avoid unnecessary links to other workbooks, especially if those workbooks are closed or stored on a slow location.
- Keep the Solver model focused. Move unrelated reports or presentation calculations out of the dependency chain for the objective and constraints where practical.
Manual calculation mode can be useful for some large workbooks, but it is not a universal Solver speed switch. It can leave displayed values out of date, and Solver needs correct calculated results to evaluate a solution. If you change calculation settings, understand how the workbook and Solver interact in your version, recalculate deliberately, and verify the final worksheet values before accepting a result.
Make the model easier to solve
Clear model structure helps both performance and troubleshooting. Keep decision variables in a defined range, place the objective in one identifiable cell, and make each constraint’s calculated value easy to inspect. Use bounds to rule out impossible values, such as negative quantities when the real decision is a nonnegative production amount. Do not add bounds that exclude valid answers.
For example, suppose a small shop chooses quantities of two products. With quantities in B2:B3 and unit margins in C2:C3, the objective cell B4 can contain =SUMPRODUCT(B2:B3,C2:C3). If the quantities are 20 and 10 and the margins are 5 and 8, respectively, B4 returns 180. Solver can maximize B4 by changing B2:B3, subject to any genuine material, labor, or demand limits. This compact layout makes it easier to check whether a constraint is calculated from the intended cells.
Use the simplest faithful mathematical representation. If a model is linear, selecting Simplex LP and expressing the relationships linearly is usually preferable to introducing unnecessary nonlinear formulas. Avoid rounding decision variables inside formulas unless rounding is truly part of the real-world rule; rounding can create flat regions or jumps that make optimization harder. For whole-number decisions, use Solver’s integer or binary constraints only where the problem genuinely requires them.
Set Solver options with care
Solver’s Options dialog includes settings such as maximum time, iterations, precision, and convergence; the available controls depend on the selected solving method. A time or iteration limit can prevent an unbounded wait, but increasing either one merely allows more searching. It cannot repair an incorrect model, turn a nonlinear relationship into a linear one, or guarantee a global optimum.
Precision controls how closely constraints must be satisfied, so changing it changes the tolerance for constraint violations. Do not loosen it just to make a run finish faster unless that tolerance is acceptable for the actual problem. Similarly, a convergence setting affects when a search may be treated as no longer improving enough to continue. Use the defaults as a starting point, and change settings only when you understand the effect on the answer.
Before a long run, set a reasonable limit and save the workbook. Keep track of the starting values and the Solver method, because those details can matter in nonlinear problems. When Solver returns a result, choose whether to keep it only after checking the objective, all constraints, and whether the values make practical sense.
When Solver is not the right tool
Excel’s built-in Solver is useful for many individual optimization tasks, but it is not designed to make every large or complex optimization problem fast. The standard add-in has practical model-size limits, and performance can degrade well before a model reaches any formal limit. If a model has many decision variables, extensive integer decisions, or a large number of scenarios, a specialized optimization product or a purpose-built application may be more appropriate.
For a problem that is genuinely linear, a dedicated linear programming solver may handle larger models more efficiently. For repeated planning runs, consider whether the work can be automated or whether a system designed for optimization is a better fit. If you are considering a third-party add-in or service, check its supported model types, size limits, licensing terms, and how it handles workbook data. A different tool is not automatically faster; the model formulation and calculation workload still matter.
Frequently Asked Questions
Why does Excel Solver keep running without finishing?
Solver may be exploring a difficult search space, recalculating a slow workbook, or trying to satisfy conflicting or restrictive constraints. Check the selected method, the status message, the objective and constraint formulas, and the time or iteration limit.
Will adding more time make Solver faster?
No. A higher time limit lets Solver search longer before stopping, but it does not make each calculation faster or guarantee a better answer. Simplify the model and verify that the selected method fits the problem first.
Which Solver method is fastest?
There is no universally fastest method. Simplex LP is the method to consider for linear models, GRG Nonlinear for smooth nonlinear models, and Evolutionary for certain nonsmooth or discontinuous models. The correct formulation and method matter more than choosing a method by speed alone.
Does Excel Solver work in Excel for the web?
The built-in Solver add-in is a desktop Excel feature and cannot be run in Excel for the web. Open the workbook in the desktop version of Excel to use that add-in.
Why does Solver give a different answer when I run it again?
For nonlinear models, starting values and local optima can affect the result; methods that search broadly can also explore different candidate solutions. Check that each answer satisfies the constraints and compare objective values rather than assuming every run must return identical changing-cell values.
Related
- Excel Remove Duplicates While Keeping the Oldest Date
- Excel Remove Slicer: How to Delete or Clear One
- Excel Remove Everything but Duplicates: Keep Repeats
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Change Cell Color in ExcelTo change a cell’s background color in Excel for Microsoft 365 on Windows, select the cell or range,…
- Import CSV Files Into Excel: Steps and TipsYes. In Excel for Microsoft 365 on Windows, you can open a CSV file directly or import it…
- List of Customers in Excel: 10 Practical Customer ListsTo make a customer list in Excel, add clear column headings, enter one customer per row, then choose…
- Excel Column Fixed: Keep It in Place While ScrollingTo keep an Excel column visible while you scroll, select View > Freeze Panes > Freeze First Column.…
- Debt Snowball Budget Spreadsheet: Build and Use OneA debt snowball budget spreadsheet lists debts from the smallest balance to the largest, sets a monthly amount…
- Excel Import CSV Data: Steps, Settings, and FixesTo import CSV data into Excel for Microsoft 365 on Windows, open a blank workbook, select Data >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.