Find Solver Parameters in Excel and Understand Each One

To find Solver parameters in Excel for Microsoft 365 on Windows, open the worksheet you want to optimize, select Data > Solver, and inspect the fields in the Solver Parameters dialog box. If Solver is missing, enable the Solver Add-in first. The dialog shows the objective cell, variable cells, constraints, solving method, and related options that define what Solver will calculate.

Solver is an Excel add-in for finding a best result while respecting limits you set. You might use it to maximize profit, minimize cost, or find values that meet a target. Before opening it, have a worksheet model in place: a formula that calculates the result, cells Solver is allowed to change, and any limits those cells must follow. The steps below also explain where saved settings live and what to check if the dialog is empty.

What You’ll Need

A desktop version of Excel with the Solver Add-in available. These steps use Excel for Microsoft 365 on Windows. Excel for the web does not provide the full desktop Solver add-in; open the workbook in the desktop app to use it.
A worksheet containing an objective formula and one or more cells that Solver can change. Add constraints to the worksheet or plan the limits you will enter in Solver.
Permission to install or enable the add-in, if it is not already active. On a work or school computer, an administrator may control add-ins.

Step-by-Step

Open the correct worksheet. Solver parameters are associated with the active worksheet, so first select the sheet containing your model. If a workbook has several sheets, do not assume the settings shown on one sheet apply to another. Solver can retain a model for each worksheet; switching sheets can therefore show different objective cells, variable cells, and constraints.
Enable Solver if you cannot see it. In Windows Excel, select File > Options > Add-ins. At the bottom of the window, set Manage to Excel Add-ins and select Go. Check Solver Add-in, then select OK. If Windows asks to install or configure the feature, allow it to finish. Return to the worksheet and look on the Data tab for Solver, usually in the Analysis group. If the add-in is not listed, check your Office installation or ask your administrator.
Use the Mac route if applicable. In Excel for Mac, select Tools > Excel Add-ins, check Solver Add-in, and select OK. Then open the Data tab and choose Solver. The names and placement of controls can vary slightly between releases, but the Solver Parameters dialog contains the same core model inputs. If you are using Excel for the web, open the file in desktop Excel instead; the web app does not run the standard desktop Solver add-in.
Open the Solver Parameters dialog. Select Data > Solver. The dialog’s upper section contains Set Objective, the Max, Min, and Value Of choices, and By Changing Variable Cells. The middle section lists Subject to the Constraints. The lower section contains the option to make unconstrained variables non-negative and the Select a Solving Method menu. These are the main parameters people mean when they ask where to find Solver settings.
Identify the objective cell and goal. Set Objective should point to one worksheet cell whose value represents the result you want to optimize, usually a formula. Choose Max to seek the largest value, Min to seek the smallest, or Value Of to make the cell reach a specified number. For example, a budgeting model might use a formula cell for total net benefit and choose Max. Confirm that the cell reference belongs to the active sheet and is not a text label or a blank cell.
Check the variable cells. By Changing Variable Cells should list the numeric input cells Solver is allowed to adjust. These could be production quantities, investment amounts, or quantities of ingredients. You can type a range or select the cells directly on the worksheet. Include every decision cell needed by the model, and exclude formulas or fixed assumptions that Solver must not change. If the range includes cells from another sheet, use a valid reference and check that it points to the intended cells.
Review the constraints one by one. The Subject to the Constraints box shows each limit, such as a cell being less than or equal to a capacity, equal to a target, or greater than or equal to a minimum. Select a constraint and choose Change to inspect it, or choose Add to create one. The left side is generally a cell or range, the middle is a relation such as <=, =, or >=, and the right side is a value, cell, or range. Integer and binary restrictions are also available through the relation menu. Make sure the constraint references the cells your model actually uses.
Inspect non-negativity and the solving method. The Make Unconstrained Variables Non-Negative checkbox prevents changing cells without another lower bound from going below zero when it is checked. Decide whether zero is a valid minimum for your model. In Select a Solving Method, choose Simplex LP for a linear model, GRG Nonlinear for a smooth nonlinear model, or Evolutionary for models with discontinuities or other difficult relationships. Select Options for additional method-specific controls, such as limits and convergence settings. These controls can differ by Solver release, so change them only when you understand their effect.
Preserve or run the model deliberately. If you only need to find the parameters, review the dialog and select Close or Cancel rather than Solve. If you want Solver to calculate a solution, select Solve and then choose whether to keep the Solver solution or restore the original values. Solver models are normally associated with the worksheet and saved with the workbook. Use the Save/Load control in the dialog to store a model in a worksheet cell range when you need to preserve or switch between alternative models; follow the prompts to select the range.

When you open Solver later, the dialog may show the last model saved for the active worksheet rather than a universal set of settings. That is why confirming the sheet name and the cell references matters, especially in a workbook with multiple optimization models.

Common Mistakes

Looking in the wrong place. Solver is on the Data tab after the add-in is enabled, not in the regular formula list. If it is absent, enable the add-in rather than searching through worksheet functions.
Using a value instead of a formula for the objective. Solver needs an objective that responds to changes in the variable cells. A typed number or unrelated formula will not produce a meaningful optimization.
Including the wrong changing cells. If the range contains fixed inputs, labels, or formula cells, Solver may change unintended values or report an invalid model. Select only the decision cells.
Forgetting a real-world limit. Solver does not automatically know that quantities must be whole numbers, that a budget cannot be exceeded, or that values must stay nonnegative. Add the required constraint or use the non-negativity option when appropriate.
Choosing a method that does not fit. A linear model is usually suited to Simplex LP. A smooth model generally calls for GRG Nonlinear, while a discontinuous or irregular model may need Evolutionary. A mismatched method can fail to find a useful result.
Assuming settings are shared across sheets. A model on one worksheet does not necessarily match the model on another. Verify the active sheet before interpreting a dialog’s contents.

Tips

Give objective, decision, and limit cells clear labels. It is easier to verify a Solver model when the worksheet explains what each referenced cell represents.
Before solving, change one decision cell manually and confirm that the objective formula updates as expected. Also check that constraints measure the quantities you intend to limit.
Keep a copy of the original workbook or record the starting values before running Solver, especially when the decision cells contain important assumptions.
For alternative scenarios, save each model to a different worksheet range with Save/Load and label the ranges. This can be easier to manage than repeatedly rebuilding a long list of constraints.
When you only need to inspect settings, avoid selecting Solve. Opening the dialog does not itself optimize the worksheet, and closing it without solving leaves the existing cell values alone.

Troubleshooting

Solver is not on the Data tab: Check File > Options > Add-ins, set Manage to Excel Add-ins, select Go, and enable Solver Add-in. If it is checked but still missing, close and reopen Excel. If Solver is not available in the list, repair or update Office, or contact the person who manages your installation. On Mac, check Tools > Excel Add-ins. In Excel for the web, switch to the desktop application.

The Solver Parameters dialog is blank or shows unexpected references: Confirm that the correct worksheet is active. A different sheet can have its own Solver model, and a new worksheet may not have any settings yet. If you previously saved an alternate model with Save/Load, use that control to load the model from its saved worksheet range. Do not overwrite a range containing a model you still need.

Solve reports that it cannot find a feasible solution: Inspect the constraints for contradictions, such as requiring a value to be above one limit and below a smaller limit. Check whether the objective and changing cells are linked by formulas. Review starting values and ensure they do not violate important requirements in a way the chosen method cannot resolve. Temporarily remove or relax one constraint at a time to identify the conflict, then restore the true business rule.

The answer looks wrong or does not change: Verify that the objective formula depends on the changing cells and that the correct worksheet cells are selected. Check the method and any integer or binary restrictions. If your model is nonlinear, Solver can converge to a local result that depends on starting values; try reasonable alternative starting values and compare outcomes. Review Solver’s completion message before choosing to keep a solution.

A saved model seems to have disappeared: Confirm that you saved the workbook after configuring Solver and that you are in the same worksheet. If you need multiple versions of a model, use Save/Load to store each one in its own range and save the workbook. If the file was converted to a format that does not preserve the required workbook features, reopen a compatible Excel workbook copy.

Frequently Asked Questions

Where exactly are Solver parameters in Excel?
Open the model’s worksheet and select Data > Solver. The Solver Parameters dialog contains the objective, changing cells, constraints, solving method, and options.

Why is Solver missing from my Excel ribbon?
The Solver Add-in may not be enabled. In Windows, go to File > Options > Add-ins, select Go beside Excel Add-ins, and check Solver Add-in. On Mac, use Tools > Excel Add-ins.

Are Solver parameters saved automatically?
Solver normally associates a model with its worksheet and stores it in the workbook. Save the workbook after making changes. Use Save/Load to put a model in a cell range when you want to keep or switch between alternate setups.

Can I view Solver settings without changing my worksheet?
Yes. Open the Solver dialog and inspect the fields, then close it without selecting Solve. Running Solver is the action that attempts to change the variable cells.

Which solving method should I choose?
Use Simplex LP for linear relationships, GRG Nonlinear for smooth nonlinear relationships, and Evolutionary for discontinuous or irregular models. If you are uncertain, review the formulas and model structure before changing methods.

Can I use Solver in Excel for the web?
The standard Solver Add-in is a desktop Excel feature. Open the workbook in Excel for Microsoft 365 on Windows or a supported desktop version on Mac to configure and run it.

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.