How to Enable Solver in Excel on Windows and Mac

To enable Solver in Excel for Microsoft 365 on Windows, choose File > Options > Add-ins, select Excel Add-ins beside Manage, click Go, check Solver Add-in, and select OK. On Mac, open Tools > Excel Add-ins, check Solver Add-in, and select OK. Solver will then be available from the Data tab. You need the desktop Excel app; the built-in Solver add-in cannot be run in Excel for the web.

Solver is an optimization tool: you give it a formula to maximize, minimize, or set to a particular value, then specify which cells it may change and any limits those cells must obey. It can help with tasks such as finding the lowest-cost production plan or the best mix of products under a budget. Enabling the add-in makes the Solver command available; you still need to prepare a worksheet and define a model before it can calculate a solution.

What You’ll Need

A desktop version of Microsoft Excel with permission to install or enable an included add-in. The steps below are for Microsoft 365 on Windows; the Mac steps are noted where they differ.
A workbook containing the values and formulas for the problem you want Solver to work on. For a model, plan which cell contains the result, which cells Solver may change, and what limits apply.
On a managed work or school computer, you may need your administrator to allow add-ins or install Office components.

Step-by-Step

Open the desktop Excel app and your workbook. Solver is an Excel add-in, so open the workbook in the installed Windows or Mac application rather than a browser. If you are in Excel for the web, use the option to open the file in the desktop app, if available. Save a working copy before building or changing a model, especially if the workbook is important.
Open the add-ins settings on Windows. Select File in the ribbon, then Options. In the Excel Options window, select Add-ins. This page lists active and inactive add-ins. At the bottom, find the Manage box, choose Excel Add-ins from its list, and click Go. Do not choose COM Add-ins for this setup; Solver is enabled through the Excel Add-ins list.
Turn on Solver for Windows. In the Add-ins dialog, find Solver Add-in and check its box, then click OK. Excel may show a progress message while it loads the component. Once it finishes, return to the worksheet and select the Data tab. Look for Solver, usually in the Analysis group near the right side of the ribbon. If the add-in is already checked, close the dialog and look for the command on Data.
Enable Solver on a Mac if that is your platform. In desktop Excel for Mac, open Tools > Excel Add-ins. Check Solver Add-in in the list and click OK. Allow Excel to load it if prompted. Then select the Data tab and look for Solver. Menu placement and wording can vary slightly between Excel releases, but the add-in is enabled through Excel Add-ins, not through the Windows File > Options dialog.
Prepare the worksheet model. Solver needs a target, or objective, cell that contains a formula, plus one or more cells whose values it can change. Build the worksheet so the formula responds to those changing cells. For example, a budget model might calculate total cost in one cell from quantities in other cells. Add any worksheet calculations you need before opening Solver; Solver works with the existing cell values and formulas rather than creating the model for you.
Open Solver and identify the objective. Select Data > Solver. In the Solver Parameters window, enter the reference for the formula cell in Set Objective. Choose Max to make its result as large as possible, Min to make it as small as possible, or Value Of to target a particular number. Confirm the selected cell really contains a formula that reflects the outcome you want; choosing an input cell by mistake will not optimize the intended result.
Choose changing cells and add constraints. In By Changing Variable Cells, select the input cells Solver is allowed to adjust. Add constraints for real-world limits, such as a maximum budget, nonnegative quantities, or a required total. To add one, click Add, set the cell reference and relation, enter the limit or reference cell, and confirm. Use realistic constraints: Solver can only respect requirements you express in the model.
Select a solving method and run the model. Choose Simplex LP for a linear model, GRG Nonlinear for a smooth nonlinear model, or Evolutionary for models with discontinuities or relationships that are not smooth. If unsure, start with the method that matches your worksheet’s structure; the default may not suit every problem. Click Solve, review the result in the Solver Results window, and choose Keep Solver Solution to retain it or Restore Original Values to discard it. You can reopen Solver to adjust settings and run it again.

Common Mistakes

Looking in the wrong add-in manager: On Windows, Solver is listed under Excel Add-ins, not COM Add-ins. If you opened the COM list, close it and choose Excel Add-ins in the Manage box before clicking Go.
Setting an objective that is not a formula: Solver needs a result that changes when its variable cells change. If the objective is a fixed number or a formula disconnected from the inputs, the model cannot meaningfully optimize it.
Leaving out important constraints: Without limits, Solver may choose values that are mathematically valid but impossible in practice, such as negative quantities or spending beyond the available budget. Add every relevant rule to the model.
Choosing a method that does not fit: Simplex LP is meant for linear relationships. A model with nonlinear formulas may need GRG Nonlinear or Evolutionary. If Solver reports no solution or returns an unexpected one, check both the formulas and the method.
Expecting identical results every time: Some models have multiple valid solutions, and some methods may find a local rather than a global optimum. Review the result against your requirements instead of assuming that any returned value is the only possible answer.

Tips

Label the model clearly. Put meaningful labels beside input, objective, and constraint cells. Clear headings make it easier to select the correct ranges in the Solver Parameters window and to understand the result later.
Start with a small, simple model. Test the objective and changing cells with a few inputs before adding every detail. Check that changing an input manually changes the objective in the expected direction. This catches broken references before you ask Solver to calculate.
Keep a copy of the original values. Solver can change the variable cells when you keep its solution. Save a separate version or record the starting values so you can compare outcomes and return to the original plan.
Use nonnegative settings when appropriate. Solver includes an option to make unconstrained variable cells nonnegative. You can use it when negative values are not meaningful, or add explicit constraints when different cells need different bounds. Do not apply it automatically if negative values are valid in your model.
Record the setup as well as the answer. Note the objective, changing cells, constraints, and solving method. This makes the workbook easier to check and rerun if assumptions change. A solution is only as useful as the assumptions and limits behind it.

Troubleshooting

Solver does not appear on the Data tab: Reopen File > Options > Add-ins > Manage: Excel Add-ins > Go on Windows, or Tools > Excel Add-ins on Mac, and confirm Solver Add-in is checked. Close and reopen the dialog after checking it. If the command still does not appear, restart Excel. On Windows, check that the Data tab is not customized in a way that hides the command. If you are using a work-managed installation, ask your administrator whether the add-in is blocked.

Solver Add-in is missing from the list: Make sure you are in the Excel Add-ins manager rather than the COM Add-ins manager. If it is not listed, your Office installation may need repair or the feature may be restricted by your organization. On Windows, use the installed Microsoft 365 or Office repair options available through Windows settings, then check the add-in list again. On a managed device, contact IT rather than downloading an add-in from an unknown source.

Solver runs but cannot find a solution: Check that the objective cell contains a formula, that the changing cells are the inputs used by that formula, and that the constraints do not contradict one another. For example, requiring a total to be both below one limit and above a larger limit makes a feasible solution impossible. Temporarily remove one constraint at a time to identify a conflict, then restore the rules that reflect the actual problem.

The result is unexpected or does not change: Verify that the formula references the intended cells and recalculates when you change an input manually. Confirm the objective direction is correct: Max, Min, or Value Of. Review the solving method, cell bounds, and any integer or binary restrictions you added. If you see a message about Solver not converging, try a sensible starting point, simplify the model, and check whether the selected method fits the formulas.

You are using Excel in a browser: The built-in Solver add-in is a desktop Excel feature and cannot be enabled or run in Excel for the web. Open the workbook in the desktop application to use it. If you only have browser access, ask whether a desktop license or an approved alternative is available; do not assume a third-party web add-in behaves exactly like Microsoft Solver.

Frequently Asked Questions

Is Solver included with Excel?
Solver is an add-in included with many desktop Excel installations, but it may not be active until you enable it. If it is missing from the add-in list, the Office installation or organizational settings may need attention.

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

Do I need to install Solver separately?
Usually not. For a standard desktop installation, enable Solver through the Excel Add-ins dialog. If it is absent, check the installation or ask your administrator before searching for a separate download.

Why can I see Solver but not get a useful answer?
Enabling the command does not build the optimization model. Set a formula-based objective, identify the cells Solver may change, add constraints, and select a suitable solving method. Incorrect references or conflicting limits can prevent a useful result.

Will enabling Solver change my workbook?
Enabling the add-in makes the Solver command available; it does not automatically optimize or rewrite your workbook. Running Solver can change the variable cells if you keep its solution, so save a copy or preserve the original inputs before solving.

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.