In Excel for Microsoft 365 on Windows, find Solver on the Data tab, in the Analysis group. If it is not there, enable the Solver Add-in through File > Options > Add-ins, then choose Excel Add-ins beside Manage and select Go.
Where Solver appears in Excel for Windows
Once enabled, Solver is a command on the far-right side of the Data tab, usually within the Analysis group. Selecting it opens the Solver Parameters dialog, where you describe the goal for the worksheet and the conditions it must meet. The command may be easy to miss if the Excel window is narrow; widening the window or checking the far-right end of the ribbon can help.
Solver is an Excel add-in, not a worksheet function. You do not type a Solver formula into a cell, and it is not normally a separate tab. Instead, it reads formulas and values already in your workbook, then searches for values in selected cells that optimize a result. The add-in is included with desktop Excel, but it may not be enabled in a particular installation.
How to enable the Solver Add-in
On Windows, enable Solver with these steps:
- Select File > Options.
- In Excel Options, choose Add-ins.
- At the bottom, next to Manage, select Excel Add-ins, then click Go.
- In the Add-ins dialog, check Solver Add-in and select OK.
- Return to the worksheet and open Data. Look for Solver in the Analysis group.
Excel may take a moment to load the add-in. If Windows asks whether to install or enable it, follow the prompt. The checkbox may already be selected; in that case, close the dialog and check the Data tab. If Solver is not listed in the add-ins dialog, confirm that you are using the desktop Excel application and that your Office installation includes the component. In a workplace, an administrator may control which add-ins are available.
Finding Solver on Mac or in Excel for the web
In desktop Excel for Mac, the Solver Add-in is enabled from Tools > Excel Add-ins. Select the checkbox for Solver Add-in and confirm. After it loads, look for Solver on the Data tab. Ribbon labels and layout can vary somewhat between Excel releases, so the Tools menu is the useful place to start if the button is missing.
Solver is not available as the standard Solver Add-in in Excel for the web. A workbook can be opened and edited in a browser, but to run the desktop Solver feature, open the file in Excel for Windows or Mac. Excel mobile apps are not a substitute for the desktop add-in either. If you need to use Solver regularly, check that you have access to desktop Excel before building a workflow that depends on it.
What Solver does and what it needs
Solver is an optimization tool. It changes values in designated worksheet cells, called decision variables, to maximize or minimize a formula cell called the objective, or to make that formula equal a specified value. You can add constraints that restrict the values Solver may use. For example, a production plan might maximize total contribution while staying within material and labor limits.
A basic model therefore needs three parts:
- An objective cell: a formula that calculates the result you want to improve, such as total profit, time, or distance.
- Changing cells: cells whose values Solver is allowed to adjust, such as quantities to produce or amounts assigned to projects.
- Constraints: limits or requirements, such as total use being less than available supply, or a decision variable being a whole number.
Solver does not decide what makes business sense. It searches the model you give it. A missing constraint, incorrect formula, or unrealistic input can produce a mathematically valid answer that is unusable in practice.
A small production-planning example
Suppose a worksheet plans two products. Put the quantities to make in B2:B3, their contribution per unit in C2:C3, their material use per unit in D2:D3, and their labor use per unit in E2:E3. Enter contribution values of 30 and 20, material use of 2 and 1, and labor use of 1 and 2. The available material is 100 units and available labor is 80 hours. The quantities are the changing cells, and total contribution is the objective.
With quantities in B2:B3 and contribution per unit in C2:C3, enter this formula in B4 to calculate total contribution:
=SUMPRODUCT(B2:B3,C2:C3)
With quantities in B2:B3 and material use per unit in D2:D3, enter this formula in F4 to calculate material consumed:
=SUMPRODUCT(B2:B3,D2:D3)
With quantities in B2:B3 and labor use per unit in E2:E3, enter this formula in G4 to calculate labor used:
=SUMPRODUCT(B2:B3,E2:E3)
Open Solver and set the objective to B4, choose Max, and set the changing variable cells to B2:B3. Add the constraints F4 less than or equal to 100 and G4 less than or equal to 80. If products cannot be made in fractional quantities, also constrain B2:B3 to be integers. For this example, if fractional quantities are allowed, a best solution is 40 units of the first product and 20 of the second: it uses exactly 100 material units and 80 labor hours, and returns a total contribution of 1,600. If whole units are required, the integer constraint makes Solver search for a feasible whole-number plan instead.
For this simple example, select Simplex LP as the solving method because the objective and constraints are linear. Choose Solve to run the model. In the results dialog, you can keep the solution in the worksheet or restore the original values. Check the resulting quantities and resource totals rather than assuming the settings were entered correctly.
Choosing a solving method
The solving method matters because different kinds of formulas have different mathematical properties. The method selector is in the Solver Parameters dialog; choosing one that fits the model can affect whether Solver finds a useful result.
- Simplex LP is for linear models, where the objective and constraints are linear expressions in the changing cells. A typical allocation or product-mix model may fit.
- GRG Nonlinear is intended for smooth nonlinear models, such as a formula involving changing cells multiplied together or used in a nonlinear function.
- Evolutionary can handle models with discontinuities or less smooth relationships, although a search may take longer and results can depend on settings and starting values.
These methods do not make a poor model reliable. If Solver reports that it cannot find a solution, check for contradictory constraints or cells that are not linked to the objective. If it finds an answer that seems unexpectedly poor, verify that the formulas, variable cells, and method match the problem. A linear model with integer requirements may still use the Simplex LP method with integer constraints, but the search can be more involved than a continuous linear model.
Solver versus Goal Seek and manual calculation
Goal Seek is a simpler tool for finding one input that makes one formula reach a target. For example, it can change a price cell until a revenue formula equals a target amount. It does not provide Solver’s general system of changing cells and multiple constraints. Find Goal Seek through Data > What-If Analysis > Goal Seek in Excel for Windows.
Use Solver when the question involves choosing values to optimize a result, especially when several inputs can change or there are resource limits. For a small model with a direct algebraic answer, a normal formula or manual calculation may be clearer. Solver is useful when the relationships and constraints are numerous enough that comparing every possible combination by hand is impractical.
Common problems when Solver is missing or will not run
- The Solver button is absent: enable the add-in using the Excel Add-ins dialog, then check the Data tab again. Make sure you are in desktop Excel rather than a browser or mobile app.
- The objective or changing cells are rejected: confirm that the objective is a formula cell and that the changing cells contain values Solver can adjust. The objective formula should depend, directly or indirectly, on those changing cells.
- Solver says no feasible solution exists: review each limit and its units. For example, a requirement to use at least 120 units cannot coexist with a maximum supply of 100 units.
- The answer looks unrealistic: add real-world limits that are absent from the model, such as nonnegative quantities, production capacity, minimum commitments, or whole-number requirements. Check whether the objective is set to Max, Min, or a target value as intended.
- The result changes from one run to another: nonlinear or evolutionary models may have multiple local or approximate solutions. Review the method and options, test sensible starting values, and compare the result with other plausible solutions.
Solver can overwrite the changing-cell values when it returns a solution. Save a copy of important workbooks before experimenting with a model, and consider recording the original values if you need to compare scenarios.
Availability and practical limits
The standard Solver Add-in is generally included with desktop Excel and does not require a separate Solver purchase for ordinary use, though access to Excel itself depends on your Microsoft license or organization. Separate commercial optimization products exist, but they are not required just to enable the built-in add-in. Advanced products may offer capabilities or scale beyond the standard tool; check their own terms and compatibility rather than assuming they are part of Excel.
Solver is designed for optimization models, not as a general-purpose forecasting or data-cleaning feature. Its practical limits depend on model size, structure, and settings. Large or complicated models may take time, and a successful run does not prove that the model represents reality. Document assumptions, use realistic input data, and validate results independently when the outcome matters.
Frequently Asked Questions
Where is Solver in Excel?
In desktop Excel for Windows, go to Data and look in the Analysis group. If it is missing, enable Solver through File > Options > Add-ins > Manage: Excel Add-ins > Go, then select Solver Add-in.
Is Solver already installed in Excel?
The standard Solver Add-in is included with desktop Excel, but it may not be enabled. Use the Excel Add-ins dialog to select it. If the option is unavailable, check your Excel installation or ask your organization’s administrator.
Can I use Solver in Excel online?
The standard Solver Add-in cannot be run in Excel for the web. Open the workbook in desktop Excel for Windows or Mac to use Solver.
How do I add Solver on a Mac?
In desktop Excel for Mac, open Tools > Excel Add-ins, select Solver Add-in, and confirm. Then look for Solver on the Data tab.
Why does Solver show no solution?
Often the constraints conflict, the changing cells do not affect the objective, or a formula or limit is incorrect. Check that a feasible set of values can satisfy every constraint before running Solver again.
Related
- Marked Scatter Plot in Excel: Create and Format One
- Matrices in Excel Solver: When It Helps and When It Doesn’t
- Lock a Slicer in Excel: Keep It in Place and Usable
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Shortcut Key for Yesterday’s Date in Excel: What WorksExcel does not have a dedicated keyboard shortcut that inserts yesterday’s date. In Excel for Microsoft 365 on…
- How to Hyperlink Text in ExcelTo hyperlink text in Excel for Microsoft 365 on Windows, enter the words you want displayed in a…
- Excel Data Validation: Create a Yes-or-No DropdownYes—Excel can use Data Validation to limit a cell to Yes or No, usually with a dropdown list.…
- How to Check Double Spacing in WordTo check whether text is double-spaced in Word, place the cursor in a paragraph or select the paragraphs,…
- How to Share a Calendar in Outlook 365 with OthersTo share an Outlook 365 calendar, open Calendar, select the calendar you own, choose Share or Share Calendar,…
- Flowchart in PowerPoint: Create, Connect, and FormatYes. In Microsoft PowerPoint for Microsoft 365, make a flowchart by choosing Insert > Shapes, selecting symbols from…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.