No: Microsoft’s Solver add-in cannot be run in Excel for the web, so you can’t set up or execute a Solver optimization in the browser. You can work with many parts of a Solver workbook online, but to run Solver—or change its model settings—open the file in the desktop version of Excel for Windows or Mac.
What Solver does in Excel
Solver is an optimization tool for finding the best value for a formula while respecting limits you specify. You choose an objective cell, such as total profit or total cost; identify cells Solver may change; and add constraints that describe what is allowed. Solver then searches for values that meet the constraints and improve the objective.
This is different from a regular formula calculating a result from values you already chose. A formula can tell you the profit from a production plan, for example, but it does not decide how many units to produce. Solver searches for quantities that maximize profit without exceeding available materials, labor, budget, or other limits.
Solver is also not the same as Excel’s Goal Seek feature. Goal Seek adjusts one input to reach a specified result in one formula. Solver can change multiple inputs and handle multiple constraints. These are desktop Excel tools; the browser version does not provide the full Solver workflow.
What you can and cannot do in the browser
Excel for the web is useful for viewing and editing workbooks, changing worksheet values, and recalculating supported formulas. Those abilities do not amount to running Solver. The Solver command and its configuration dialog are not available in the browser, and a browser user cannot ask Microsoft’s Solver add-in to find a new optimum.
You may be able to open a workbook that was previously set up with Solver and edit its ordinary worksheet cells. The formulas can show the results for the current inputs, but those results are not necessarily optimal after you change the inputs. The browser also does not provide the desktop Solver controls for inspecting or updating the model. If the model settings matter, use desktop Excel rather than assuming that a workbook’s visible results tell the whole story.
Some third-party products advertise optimization or Solver-like features in a browser. Those are separate products, not proof that Microsoft’s Solver add-in runs in Excel for the web. Check the provider, supported file types, privacy terms, pricing, and compatibility with your workbook before relying on one.
A small example: choosing a production mix
Suppose a workshop makes products X and Y. Each X earns $40 and uses two units of machine capacity and one unit of labor. Each Y earns $30 and uses one unit of machine capacity and two units of labor. The workshop has 100 machine-capacity units and 80 labor units. The question is how many of each product to make to maximize profit without exceeding either limit.
In a worksheet, put the quantities of X and Y in A2:B2, their unit profits in A3:B3, and the objective formula in C2. With that layout, enter =SUMPRODUCT(A2:B2,A3:B3) in C2. At quantities of 40 for X and 20 for Y, the formula returns 2,200: 40 × $40 plus 20 × $30.
For the constraints, put the machine-capacity use in A5 and labor use in A6. With quantities in A2:B2, machine coefficients of 2 for X and 1 for Y, and labor coefficients of 1 for X and 2 for Y, use =2*A2+B2 in A5 and =A2+2*B2 in A6. At 40 and 20, these return 100 and 80, respectively, so both resource limits are met exactly.
In desktop Solver, maximize C2 by changing A2:B2, then add constraints that A5 is less than or equal to 100, A6 is less than or equal to 80, and the quantities are nonnegative. This model has a best solution of 40 units of X and 20 of Y, for a profit of $2,200. If products must be made in whole units, add an integer constraint to the quantity cells; this example’s solution is already whole-numbered.
How to run Solver in desktop Excel
For Microsoft 365 Excel on Windows, first enable the built-in add-in if Solver is not already on the Data tab:
- Select File > Options > Add-ins.
- At the bottom, set Manage to Excel Add-ins, then select Go.
- Select the Solver Add-in checkbox and choose OK. If prompted, allow Excel to install or load the add-in.
- Open the Data tab and select Solver.
In the Solver Parameters dialog, set the objective cell, choose Max, Min, or a target value, and select the cells Solver may change. Add each constraint using worksheet cells that calculate the quantities you want to limit. Choose a solving method appropriate to the model, then select Solve. For a linear model such as the production example, Simplex LP is generally the appropriate method. Nonlinear or discontinuous models may need another method, and the result can depend on the model’s structure and settings.
On Excel for Mac, the Solver add-in is also available in desktop Excel. Enable it through Tools > Excel Add-ins, select Solver Add-in, and then look for Solver on the Data tab. Menu wording and dialog layout can vary somewhat by version. These steps are for desktop Excel, not the Excel browser.
Working with a Solver workbook across devices
A practical workflow is to build and solve the model in desktop Excel, save the workbook to OneDrive or SharePoint, and then use Excel for the web for tasks that do not require running Solver. For example, a teammate can update source data or review charts in the browser. When the inputs change, however, do not treat an old Solver result as newly optimized. Reopen the workbook in desktop Excel and run Solver again to refresh the decision variables.
Before relying on a browser edit, consider keeping a copy of the original and checking the workbook in desktop Excel afterward. This is especially useful when a model is business-critical, has many constraints, or uses add-ins and features beyond ordinary worksheet formulas. Saving a workbook in the browser is not a substitute for confirming that the Solver model still behaves as intended in the desktop app.
Alternatives when you only have a browser
If installing or opening desktop Excel is not an option, the right alternative depends on how much optimization the problem needs. For a simple one-input question, you may be able to calculate a few candidate scenarios directly in the sheet and compare their results. For example, a table of possible quantities can show the resulting cost or profit, provided you check that each scenario meets the constraints. This is manual analysis, not Solver, and it can miss the best answer if the number of possibilities is large.
- Use desktop Excel: Best when you need Microsoft Solver’s changing cells, objective, constraints, or solving methods.
- Compare a small number of scenarios: Reasonable for a short list of choices that you can check systematically.
- Use a suitable optimization service: Consider this only after checking that it supports your model and that sharing the data is acceptable.
- Ask a desktop Excel user to solve it: Send a clearly labeled copy with the objective, decision cells, and constraints documented, then review the returned workbook.
For large or sensitive models, avoid putting confidential information into an unfamiliar online solver. Also make sure a proposed alternative supports the kind of constraints you need, such as integer quantities or nonlinear relationships. A tool that only handles linear models may not produce a valid answer for a more complex problem.
Common Solver limitations and mistakes
Solver can optimize only the model represented by the worksheet and the settings you provide. It cannot infer what “best” means, which constraints are important, or whether an input is realistic. A missing constraint can produce an answer that is mathematically optimal but unusable in practice. In the example, forgetting the labor limit would allow Solver to recommend a production mix that the workshop cannot make.
Check these points before trusting a result:
- Confirm that the objective cell calculates the measure you actually want to maximize or minimize.
- Verify that every decision variable is included in the changing-cell range.
- Check units and constraint directions: a capacity limit is usually “less than or equal to,” while a minimum requirement is usually “greater than or equal to.”
- Add nonnegative, integer, or other restrictions where the real problem requires them.
- Review Solver’s result message and test whether the returned values make practical sense.
Some models have no feasible solution because their constraints conflict; others can have multiple equally good solutions or require careful method selection. Solver is a numerical search tool, not a guarantee that the model reflects reality. If a result seems surprising, inspect the formulas and assumptions before changing the answer manually.
Frequently Asked Questions
Can I add the Solver add-in to Excel for the web?
No. Microsoft’s built-in Solver add-in is for desktop Excel and cannot be enabled from Excel for the web. A separate third-party browser tool may offer similar features, but it is not the same add-in.
Can I open a Solver workbook in a browser?
You can generally use Excel for the web to open and edit supported worksheet content in a workbook. But the browser does not provide the Solver dialog or run the Solver model. Use desktop Excel to inspect settings and solve the model.
Does Solver work in Excel for Mac?
Yes, Solver is available in desktop Excel for Mac. Enable it from Tools > Excel Add-ins, then select Solver Add-in. That is different from Excel for the web, which does not run the add-in.
Can Goal Seek replace Solver online?
Not as a browser-based workaround: Excel for the web does not provide the full desktop Goal Seek tool either. Even in desktop Excel, Goal Seek handles a single input and target, whereas Solver can optimize multiple changing cells under constraints.
Will Excel for the web recalculate a Solver answer after I change an input?
It can recalculate supported worksheet formulas, but recalculating is not the same as rerunning Solver. The decision cells may retain their old values, so the displayed objective may no longer be optimal. Run Solver again in desktop Excel after changing model inputs.
Related
- Why Is Excel Not Letting Me Transpose Data?
- Row Example in Excel: How Rows Work and How to Use Them
- ISERROR in Excel: How It Works and When to Use It
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Can You Split One Cell in Excel? What Actually WorksNo—Excel cannot divide one individual grid cell into two smaller cells without changing the worksheet’s row-and-column structure. You…
- Excel Split Cell Shortcut: The Fastest Ways to Separate DataIn Excel for Microsoft 365 on Windows, there is no single dedicated key that splits a cell; the…
- How to Freeze X and Y Axes in Excel at the Same TimeTo keep a worksheet’s top row and leftmost column visible while you scroll, select cell B2, then choose…
- Location Heat Map in Excel: Create One Step by StepYes. In Excel for Microsoft 365 on Windows, you can create a location heat map with 3D Maps:…
- Excel Data Model on Mac: What Works and What Doesn’tExcel for Mac does not include Power Pivot, so you cannot create, manage, or refresh a full Excel…
- Hanging Indent in Word: A Simple Step-by-Step GuideTo add a hanging indent in Word, select the paragraph or paragraphs, open the Paragraph settings, and choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.