Yes—Excel includes Solver as an add-in, but it may not be enabled yet. In desktop Excel for Microsoft 365 on Windows, turn on the Solver Add-in through File > Options > Add-ins; Solver then appears on the Data tab. Excel for the web does not run the desktop Solver add-in.
What Excel Solver does
Solver is an optimization tool. It changes selected values in a worksheet to make a formula in another cell as large as possible, as small as possible, or equal to a target value, while obeying limits you specify. Those changeable values are called variable cells, and the limits are called constraints.
This makes Solver useful for questions that involve trade-offs. For example, a business might want to choose how many units of several products to make to maximize profit, given limits on labor and materials. A household could explore a budget allocation, while a logistics planner could assign shipments subject to capacity. These are not simply questions of calculating a result from fixed inputs: Solver searches for input values that meet the goal.
Solver is different from ordinary Excel formulas. A formula calculates an output from current inputs; Solver repeatedly adjusts inputs and recalculates the formula to find a solution. It is also distinct from the Analysis ToolPak, which provides statistical and engineering analysis tools rather than this kind of constrained optimization.
How to enable Solver in Excel for Windows
In the desktop version of Excel for Microsoft 365 on Windows, follow these steps:
- Select File > Options.
- Choose Add-ins in the Excel Options window.
- At the bottom, next to Manage, select Excel Add-ins, then select Go.
- Check Solver Add-in and select OK. If Windows asks whether to install or enable it, approve the prompt.
- Open the Data tab and look for Solver, usually in the Analysis group.
The first time you enable the add-in, Excel may take a moment to load it. If Solver Add-in is not listed in the dialog, check that you are using the desktop Excel application and that your Office installation is complete and up to date. A workplace administrator may also restrict add-ins; in that case, ask your IT team about the organization’s Office policy.
On Excel for Mac, open Tools > Excel Add-ins, select Solver Add-in, and confirm. The exact dialog appearance can differ between Mac releases, but the add-in is accessed from Excel’s Tools menu rather than the Windows File > Options route. Excel for the web and Excel mobile do not provide the desktop Solver command.
How a Solver model is set up
A basic Solver model needs three ingredients: an objective formula, variable cells Solver may change, and any constraints the result must satisfy. Before opening Solver, arrange the worksheet so those parts are easy to identify. The objective formula should depend on the variable cells; otherwise, changing them cannot improve the target.
Select Data > Solver to open the Solver Parameters dialog. Set the objective cell, choose Max, Min, or Value Of, and identify the changing variable cells. Then use Add to enter constraints, such as a resource-use cell being less than or equal to a capacity cell. You can also set variable cells to be integers or binary values when the decision requires whole numbers or yes/no choices.
For instance, a plan that produces fractional quantities might be mathematically optimal but impractical if products are sold only as whole units. An integer constraint can address that issue. It may, however, change the best result and make the search more demanding. Model decisions and restrictions carefully: Solver can optimize the model you give it, but it cannot determine whether your assumptions represent the real situation correctly.
Worked example: choosing a product mix
Suppose a small workshop makes products A and B. Each unit of A contributes $30 toward profit and uses 2 labor hours and 3 units of material. Each unit of B contributes $50 and uses 4 labor hours and 2 units of material. The workshop has 100 labor hours and 90 material units. Let B2:C2 hold the quantities of A and B, respectively; put unit profits in B3:C3, labor use per unit in B5:C5, and material use per unit in B6:C6.
With B2:C2 as the quantities and B3:C3 as the corresponding unit profits, enter this in B4 to calculate total contribution:
=SUMPRODUCT(B2:C2,B3:C3)
With B2:C2 holding quantities and B5:C5 holding labor hours per unit, enter this in D5 to calculate labor used:
=SUMPRODUCT(B2:C2,B5:C5)
With B2:C2 holding quantities and B6:C6 holding material per unit, enter this in D6 to calculate material used:
=SUMPRODUCT(B2:C2,B6:C6)
In Solver, set B4 as the objective and choose Max. Set B2:C2 as the changing cells. Add constraints D5 <= 100, D6 <= 90, and B2:C2 >= 0, then choose Simplex LP if the model is linear. With continuous quantities, the optimum is 20 units of A and 15 of B: labor use is 2 × 20 + 4 × 15 = 100 hours, material use is 3 × 20 + 2 × 15 = 90 units, and contribution is 30 × 20 + 50 × 15 = $1,350. If products must be whole units, add an integer constraint and solve again; the result may differ.
Choosing a solving method
The Solver dialog offers different methods because optimization problems do not all behave alike. Choosing a method that matches the worksheet model can make results more useful and help explain why a solution was or was not found.
- Simplex LP is for linear models: the objective and constraints are built from linear relationships between decision variables. The product-mix example is linear.
- GRG Nonlinear is intended for smooth nonlinear models, where formulas include nonlinear relationships but do not have abrupt jumps.
- Evolutionary can be suitable for models with discontinuities or relationships that are not smooth. It searches more broadly and may take longer; results can depend on search settings and may not be a guaranteed global optimum.
If you are unsure, inspect the formulas rather than choosing a method at random. Products of decision variables, powers, or functions that change abruptly can make a model nonlinear. Integer and binary restrictions also affect the problem. For an important decision, compare plausible solutions and test whether modest changes in assumptions change the answer substantially.
Why Solver may be missing or not working
If you cannot find Solver, first check which Excel you have open. The add-in’s Solver command is for desktop Excel; using Excel in a browser is a common reason the command is absent. In desktop Excel, return to the Add-ins settings and verify that Solver Add-in is checked, then look on the Data tab.
If Solver opens but produces no useful answer, check the model before changing settings. Common issues include an objective cell that is a typed number instead of a formula, variable cells that do not affect the objective, a wrong constraint direction, or a capacity entered in the wrong units. Confirm that every formula points to the intended cells and that the starting values are reasonable.
Solver can also report that it cannot find a feasible solution when the constraints conflict. For example, a model might require at least 80 labor hours of production but impose a maximum of 60. Review the limits and, if appropriate, temporarily remove constraints one at a time to identify the conflict. Conversely, a model may be unbounded if it has no effective limit on a variable that can keep improving the objective.
Finally, check the method and the model’s scale. A nonlinear or integer model can take longer than a small linear one, and Solver’s standard Excel add-in is designed for worksheet-sized problems rather than every large industrial optimization task. Save a copy of the workbook before major revisions, and retain the final decision values and assumptions so the result can be reviewed later.
Solver versus other Excel tools and alternatives
Goal Seek is a simpler tool for finding one input value that makes a formula reach a specified result. It does not provide Solver’s general set of multiple changing cells and constraints. Data Tables show how formula outputs vary across one or two input variables; they are useful for sensitivity analysis, but they do not search for the best feasible combination.
For a model with a single straightforward target and one changing input, Goal Seek may be easier. For comparing outcomes across a grid of assumptions, a Data Table may be clearer. Solver is the better fit when there are several decisions and meaningful limits, such as maximizing margin while staying within multiple resource capacities.
Excel’s built-in add-in is sufficient for many classroom, planning, and small business models. If a problem exceeds its practical size or needs specialized optimization features, third-party Solver products or dedicated optimization software may be options. These may have separate licensing, capabilities, and compatibility requirements, so check the provider’s current details before relying on a particular feature. Do not assume that a workbook’s Solver model will run in every spreadsheet program or in Excel for the web.
Frequently Asked Questions
Is Solver included in Excel?
Solver is available as an Excel add-in in desktop Excel, but it may need to be enabled. It is not the same as a separate worksheet function. Availability can depend on the Excel application, platform, and organization settings.
Why can’t I see Solver in Excel?
It may not be enabled, or you may be using Excel for the web, which does not run the desktop add-in. On Windows, enable it through File > Options > Add-ins, then Manage: Excel Add-ins > Go. On Mac, check Tools > Excel Add-ins.
Does Solver work in Excel for the web?
No. Solver’s desktop add-in does not run in Excel for the web. Open the workbook in the desktop Excel application to use the add-in, if it is available and enabled there.
What is the difference between Solver and Goal Seek?
Goal Seek adjusts one input to reach a specified formula result. Solver can adjust multiple variable cells, optimize a target by maximizing or minimizing it, and apply constraints to the solution.
Do I need to pay extra for Excel Solver?
The standard Solver Add-in is included with desktop Excel rather than sold as a separate add-in purchase. Specialized third-party optimization tools may charge separately, and workplace or school licensing can affect which Excel applications you can use.
Related
- Excel Circular Reference Cannot Be Listed? How to Find It
- Excel Circular Reference Greyed Out? Find the Cause
- Excel Named Range Scope Greyed Out? How to Change It
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Mail Merge in Word From Excel: Step-by-Step GuideTo mail merge in Word from an Excel file, prepare a clean list with one recipient per row,…
- Google Sheets: Count Unique Values in a Column EasilyTo count distinct values in a Google Sheets column, use =COUNTUNIQUE(A2:A) when the data starts in A2. To…
- Find and Replace Numbers in Excel: A Practical GuideTo find and replace numbers in Excel for Microsoft 365 on Windows, press Ctrl+H, enter the number in…
- Excel Text to Columns: Split Names, Dates, and Other DataIn Excel for Microsoft 365 on Windows, select the cells in one column, then choose Data > Text…
- Insert Row Below in Excel: Steps, Shortcuts, and FixesTo insert a row below a particular row in Excel for Microsoft 365 on Windows, select the row…
- How to Get Text to Wrap in Excel Without Changing ColumnsTo get text to wrap in Excel, select the cell or cells, then choose Home > Wrap Text.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.