Excel Solver Add-In: The Complete Guide to Installing, Configuring, and Using Solver for Optimization
Master the Excel Solver add-in with this complete guide covering installation, configuration, GRG Nonlinear, Simplex LP, and real optimization examples.

If the Solver add-in is missing, unlisted, or failing, first confirm it is ticked under File > Options > Add-ins > Manage: Excel Add-ins > Go (Tools > Excel Add-ins on Mac), and use Browse if it is not listed. If Solver runs but reports "could not find a feasible solution" or "linearity conditions not satisfied", the problem is the model, meaning constraints, bounds or the chosen solving method, not the add-in. Practice with the free Excel practice test on PracticeTestGeeks (500+ questions with answer explanations).
The excel solver add in is one of the most powerful yet underused tools bundled with Microsoft Excel, transforming the spreadsheet from a simple calculation engine into a full-featured optimization platform. Whether you are a finance analyst trying to minimize portfolio risk, an operations manager balancing production schedules, or a student tackling linear programming homework, Solver finds the best possible answer to problems that would otherwise require expensive specialized software. It works by adjusting decision variables you specify until an objective cell reaches a maximum, minimum, or specific target value while honoring every constraint you define.
Solver ships with desktop Excel but remains hidden by default. Users must explicitly enable it through the Add-Ins dialog before the command appears on the Data tab. This gatekeeping reflects its specialized nature, but enabling it only takes a few clicks once you know where to look. After enabling, you gain access to three distinct solving engines, each tuned for a different class of problem from linear programming to smooth nonlinear functions to evolutionary algorithms for truly chaotic relationships.
Microsoft states that you can specify up to 200 variable cells in Solver, which is enough for most business scenarios. Solver is free, and portions of its code are copyright Frontline Systems, per Microsoft's documentation. The native version, however, comfortably handles capital budgeting, transportation routing, employee scheduling, blending problems, regression curve fitting, and dozens of other classic operations research applications without any additional cost or licensing.
One reason Solver feels intimidating is that it borrows vocabulary from mathematical optimization rather than everyday spreadsheet work. Terms like objective function, decision variables, binding constraints, dual values, and reduced costs can scare off casual users. In reality, these concepts map cleanly to familiar Excel ideas. The objective is just a formula cell you want optimized. Decision variables are the inputs Solver is allowed to change. Constraints are simple cell comparisons such as B5 less than or equal to 1000. Once you see the translation, the dialog box becomes friendly.
Beyond solving the problem, the add-in can produce Answer, Sensitivity, and Limits reports when you use the Simplex LP or GRG Nonlinear method (Evolutionary produces Answer and Population reports). These reports reveal which constraints are actively pinching the solution, how much the objective would improve if a constraint were relaxed by one unit, and the range over which the optimal solution remains stable. For decision makers, sensitivity analysis is often more valuable than the optimal answer itself because it shows where to invest additional resources or which inputs deserve the most attention.
This guide walks through everything from the initial activation steps to advanced techniques like writing VBA macros that automate Solver runs across multiple scenarios. You will learn how to choose between the GRG Nonlinear, Simplex LP, and Evolutionary engines, how to diagnose the dreaded "Solver could not find a feasible solution" message, and how to model integer and binary variables for problems that require yes-or-no decisions. By the end you will treat Solver as a routine analytical companion rather than an obscure menu item.
If you want the full picture, the excel solver add in guide walks through it step by step.
Related reading: excel solver add in covers the next step in more detail.
If you want the full picture, the excel solver add in guide walks through it step by step.
Microsoft Excel: upcoming dates and official changes
- Jun 30, 2026: Certiport retired the Microsoft Office Specialist 2016 certifications, including MOS Excel 2016, on June 30, 2026. The Microsoft 365 Apps and Office 2019 Excel exams are still available. (certiport.pearsonvue.com)
- Updated Oct 16, 2026: Delivery is now Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) (previously Proctored live-in-the-application exam via Certiport Authorized Testing Centers).
- Updated Oct 16, 2026: Eligibility is now No formal prerequisites; about 150 hours of instruction and hands-on experience recommended (previously No formal prerequisites; ~150 hours of instruction and hands-on experience recommended (Associate)).
- Updated Oct 16, 2026: Time limit is now 50 minutes (60 minutes seat time) (previously 50 minutes (60 minutes seat time)).
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
- The MOS Excel (Microsoft 365 Apps) exam has 33 to 37 questions. (certiport.pearsonvue.com)
- The MOS Excel Expert (Microsoft 365 Apps) exam has 23 to 27 questions. (certiport.pearsonvue.com)
- Microsoft Office Specialist Excel exams last 50 minutes, with 60 minutes of total seat time. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- The passing score for Microsoft Office Specialist Excel exams is always 700 on Certiport's 1 to 1000 scaled score. (certiport.pearsonvue.com)
- After failing a Microsoft Office Specialist Excel exam, candidates must wait 24 hours before the first retake and 48 hours before each later retake, and there is no annual limit on attempts. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Microsoft Office Specialist Excel certifications earned on or after September 23, 2025 are valid for five years; those earned earlier do not expire. (certiport.pearsonvue.com)
- The Microsoft Office Specialist Excel exam is proctored and delivered live in the Excel application through Certiport Authorized Testing Centers, either in person or remote-proctored. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Microsoft recommends that candidates for the MOS Excel Associate (Microsoft 365 Apps) certification have about 150 hours of instruction and hands-on experience with Excel. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Candidates get their MOS Excel score report as soon as they finish the exam, and it can also be viewed in their Certiport profile. (certiport.pearsonvue.com)
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
Microsoft Excel Exam at a Glance
| Item | Detail | Official source |
|---|---|---|
| Number of questions (Excel Associate (MO-210)) | 33-37 questions | certiport.pearsonvue.com |
| Number of questions (Excel Expert (MO-211)) | 23-27 questions | certiport.pearsonvue.com |
| Time limit | 50 minutes (60 minutes seat time) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Passing score | 700 on a 1โ1000 scale | certiport.pearsonvue.com |
| Retake policy | Wait 24h after 1st fail, 48h before each later retake; no annual limit | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Validity | Valid 5 years (earned on/after Sept 23, 2025) | certiport.pearsonvue.com |
| Delivery | Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Eligibility | No formal prerequisites; about 150 hours of instruction and hands-on experience recommended | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Score release | Score report at end of exam; also in Certiport profile | certiport.pearsonvue.com |
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
Free Excel Study Tools
Interactive Excel resources on PracticeTestGeeks, free to start:
- Free Excel Questions and Answers โ 16 questions with instant scoring and answer explanations
- Excel flashcards โ review key terms and concepts card by card
- Excel study guide โ topic-by-topic overview of what the exam covers
- Excel cheat sheet โ one-page printable summary for last-minute review
Excel Solver by the Numbers
Solver result messages and what to check
| SolverSolve return value | Message shown | What to check |
|---|---|---|
| 3 | Stopped at the maximum iteration limit | Raise Iterations under Options |
| 4 | The Objective Cell values do not converge | Add realistic upper and lower bounds |
| 5 | Solver could not find a feasible solution | Check constraints for conflicts; VBA ReportArray 1 = Feasibility report |
| 7 | Linearity conditions required by this LP Solver are not satisfied | Switch to GRG Nonlinear or remove nonlinear formulas; ReportArray 1 = Linearity report |
| 8 | The problem is too large for Solver to handle | Reduce variable cells (limit 200) |
| 9 | Solver encountered an error value in a target or constraint cell | Fix the #REF!, #VALUE! or other error in the cell |
| 10 | Stopped at the maximum time limit | Raise Max Time under Options |
| 18 | All variables must have both upper and lower bounds | Bound every variable cell |
| 20 | Lower and upper bounds on variables allow no feasible solution | Recheck bounds against constraints |
Sources: Microsoft Learn, SolverSolve and SolverFinish functions; Microsoft Support, "Load the Solver add-in in Excel." The "What to check" column is guidance, not Microsoft text.

How to Install and Activate the Solver Add-In
Open Excel Options
Navigate to Add-Ins
Enable Solver Add-In
Locate Solver on the Ribbon
Verify with a Quick Test
Once Solver appears on the Data tab, opening it reveals the Solver Parameters dialog, the command center for every optimization task. The dialog is divided into regions that match the anatomy of an optimization problem. At the top sits the Set Objective field, where you point Solver at the single cell containing the formula you want pushed to its best possible value. Just below are three radio buttons labeled Max, Min, and Value Of, letting you tell Solver whether to maximize profit, minimize cost, or hit an exact target number.
The next region is the By Changing Variable Cells field. Here you enter the cell or range that Solver is permitted to modify in search of the optimum. These cells should already contain starting values that feed into the objective through your formulas. Solver will overwrite them repeatedly during its iterations, so always save a copy of the original numbers before solving. You can list non-contiguous ranges by separating them with commas, which is useful when decision variables are scattered across the worksheet.
Beneath the variable cells field lives the Subject to the Constraints list box, where you add the inequalities and equalities that bound the problem. Clicking Add opens a small sub-dialog with three fields: Cell Reference, the comparison operator, and the Constraint value. The operator dropdown includes the familiar mathematical symbols plus three special keywords. The int keyword forces a cell to be an integer, bin restricts it to binary 0 or 1, and dif tells Solver that all cells in a range must be different values, a powerful feature for assignment problems.
Below the constraints list you find the Make Unconstrained Variables Non-Negative checkbox. Ticking this is equivalent to adding a constraint that every decision variable must be greater than or equal to zero, a common requirement in business modeling where you cannot produce negative units or hire negative employees. Leaving the box unchecked allows negative values, which matters in financial models that involve short positions, debt, or losses. Decide deliberately based on the meaning of your variables.
The Select a Solving Method dropdown is where you pick the engine. GRG Nonlinear is the default and works for smooth functions with derivatives. Simplex LP is the fastest choice when every relationship in the model is strictly linear. Evolutionary handles non-smooth functions with IF statements, lookups, or step-change formulas but at the cost of slower runtimes. Choosing wrong does not break the model, it simply leads to worse answers or longer waits, so pick deliberately.
Finally, the Options button reveals settings such as Max Time, Iterations, Constraint Precision, Multistart and Integer Optimality. Most users never need to touch them, but knowing they exist helps when default behavior produces strange results. For example, raising the Max Time setting helps with large integer programs that need extra search effort, and lowering Constraint Precision helps when constraint boundary rounding causes Solver to declare infeasibility.
The Load and Save buttons at the bottom let you store complete Solver configurations as ranges on the worksheet. This is invaluable when a workbook contains multiple optimization scenarios. You can build a dashboard with five different load buttons that swap between marketing budget allocation, inventory reorder points, staffing schedules, blending ratios, and production mix, all using the same underlying data but with different objectives and constraint sets.

Microsoft Excel Practice Test Questions
Prepare for the Microsoft Excel exam with our free practice test modules. Each quiz covers key topics to help you pass on your first try.
Microsoft Excel Excel Basic and Advance
Microsoft Excel Exam Questions covering Excel Basic and Advance. Master Microsoft Excel Test concepts for certification prep.
Microsoft Excel Excel Formulas
Free Microsoft Excel Practice Test featuring Excel Formulas. Improve your Microsoft Excel Exam score with mock test prep.
Microsoft Excel Excel Functions
Microsoft Excel Mock Exam on Excel Functions. Microsoft Excel Study Guide questions to pass on your first try.
Microsoft Excel Excel MCQ
Microsoft Excel Test Prep for Excel MCQ. Practice Microsoft Excel Quiz questions and boost your score.
Microsoft Excel Excel
Microsoft Excel Questions and Answers on Excel. Free Microsoft Excel practice for exam readiness.
Microsoft Excel Excel Trivia
Microsoft Excel Mock Test covering Excel Trivia. Online Microsoft Excel Test practice with instant feedback.
Solver Methods Compared: Which Engine Fits Your Model
GRG Nonlinear stands for Generalized Reduced Gradient and is the workhorse method for smooth nonlinear problems. It uses calculus-based gradient information to climb toward an optimum, which means it converges quickly when the underlying functions are continuous and differentiable. Typical applications include curve fitting, portfolio optimization with quadratic risk terms, and production models with diminishing returns where revenue functions involve exponents or logarithms.
The main limitation of GRG is that it finds local optima, not necessarily global ones. If your objective has multiple peaks, GRG will climb the nearest one and stop. To mitigate this, enable the Multistart option in the GRG settings, which tests multiple starting points. Multistart adds runtime but gives Solver more chances to escape a poor local optimum.
Should You Use Excel Solver or Dedicated Optimization Software?
- +Free add-in for desktop Excel
- +Tight integration with existing spreadsheet models and dashboards
- +Handles linear, nonlinear, and non-smooth problems in one tool
- +Produces Answer, Sensitivity, and Limits reports on request (Simplex LP and GRG)
- +Easy collaboration since other Excel users can open your model
- +Supports integer, binary, and all-different variable constraints
- +VBA automation lets you batch run many scenarios
- โStandard Solver accepts up to 200 variable cells
- โEvolutionary engine offers no guarantee of finding the global optimum
- โMultiple optima or degeneracy can cause inconsistent results across runs
- โNot available in Excel for the web or on mobile
- โRequires careful model setup to avoid hidden nonlinearity that breaks Simplex LP

Excel Solver Setup Checklist Before You Click Solve
- โVerify the Solver add-in is enabled under File then Options then Add-Ins
- โIdentify a single objective cell containing a formula not a hard coded value
- โConfirm decision variable cells contain numbers and feed the objective formula
- โAdd lower and upper bounds for every decision variable to prevent runaway values
- โUse the int keyword for whole number variables like units produced or staff assigned
- โUse the bin keyword for binary yes or no decisions such as project selection
- โChoose Simplex LP only if every formula in the model is strictly linear
- โSave a copy of your starting values before running since Solver overwrites cells
- โTick the non-negative checkbox when negative values are physically impossible
- โRequest the Answer report after solving to inspect binding constraints and slack
Always normalize your constraint scales before running large optimizations
If one constraint involves numbers in the billions and another involves decimals near zero, Solver can struggle with numerical precision. Divide both sides of the large constraint by a common factor so all coefficients fall within a few orders of magnitude.
To make Solver concrete, consider a classic product mix problem. A small bakery produces three products, croissants, muffins, and bagels. Each item consumes flour, sugar, and labor in different proportions and yields a different profit margin. The owner has 50 pounds of flour, 20 pounds of sugar, and 12 labor hours available daily. Set up a spreadsheet with one column for each product, rows for the resource coefficients, and a profit row at the bottom. Solver finds the production quantities that maximize total profit subject to the resource caps.
The objective cell uses SUMPRODUCT to multiply quantity by profit per unit. The constraint cells use SUMPRODUCT to multiply quantity by resource consumption per unit, then compare those totals against the available resources. Add the integer constraint on quantities because you cannot bake half a croissant. Choose Simplex LP since every relationship is linear. Solver then returns the optimal mix, typically pushing the bakery toward the highest-margin product until a resource becomes the binding constraint.
A second example involves portfolio allocation across five stocks. The objective is to minimize the portfolio variance, calculated through a covariance matrix and the SUMPRODUCT of weights. The constraint is that the weights sum to exactly one and that each weight stays between zero and one. Because variance is a quadratic function, Simplex LP cannot handle it, so switch to GRG Nonlinear. Add a target return constraint that the weighted expected return equals a specified percentage. Solver delivers the minimum-variance portfolio for that return level, the cornerstone of modern portfolio theory.
A third real-world application is employee scheduling. Suppose a call center needs minimum staffing for each two-hour block across a 24-hour day. Employees work eight-hour shifts that start at various times. Decision variables are the number of employees starting at each shift time. The objective is to minimize total employees hired. Constraints ensure that the sum of overlapping shifts meets the minimum coverage requirement in every block. Mark all variables as integer because partial employees do not exist. Simplex LP handles this elegantly thanks to its branch-and-bound integer routine.
Transportation problems also yield to Solver naturally. Imagine three warehouses shipping to five retail stores with different unit shipping costs and supply and demand limits. Decision variables form a three-by-five matrix of shipment quantities. The objective minimizes total cost as SUMPRODUCT of quantities and unit costs. Supply constraints cap each warehouse row sum, and demand constraints meet each store column sum. The Solver result is the cheapest distribution plan, and the Sensitivity report reveals which routes would benefit most from negotiating better freight rates.
Curve fitting represents another fertile use case. Suppose you have noisy experimental data and want to fit an exponential decay curve of the form y equals A times e to the negative k t. Decision variables are the parameters A and k. The objective is to minimize the sum of squared residuals between observed y values and predicted values. Use GRG Nonlinear since the function is smooth but nonlinear. Solver returns the parameter estimates that best match the data.
The most frustrating Solver messages are vague. Solver could not find a feasible solution usually means constraints conflict, so loosen bounds one at a time. The objective cell values do not converge implies an unbounded problem, add upper limits to variables. Linearity conditions not satisfied means a nonlinear formula slipped into a Simplex LP model, switch engines or audit formulas for hidden multiplication of decision variables.
Beyond the dialog box, the real power of Solver emerges when you automate it through VBA. The Solver functions exposed to Visual Basic include SolverReset, SolverOk, SolverAdd, SolverChange, SolverDelete, and SolverSolve. With these you can build macros that loop through dozens of scenarios, recording each optimal answer to a results sheet. For example, a sensitivity sweep might run Solver one hundred times at different interest rate assumptions and chart how the optimal capital budget evolves.
To use Solver in VBA, first add a reference to Solver in the Visual Basic Editor under Tools then References. In the Visual Basic Editor you must establish a reference to Solver; if Solver is not listed under Available References, click Browse and open Solver.xlam. Once enabled, a typical automation routine clears any prior model with SolverReset, defines the objective with SolverOk, adds constraints in a loop with SolverAdd, then calls SolverSolve with the UserFinish argument set to True so no dialog interrupts the macro. Capture the returned integer status code to detect whether Solver succeeded, hit an iteration limit, or declared infeasibility.
Another advanced technique is using Solver in combination with the Scenario Manager. The Scenario Manager swaps input values in and out, and a small macro runs Solver after each swap. The result is a tidy table comparing optimal answers across business conditions like recession, baseline, and boom. Pair this with Excel charts and you can show executives how the recommended decision changes with the operating environment, a far more compelling story than any single optimization run.
For problems near the 200-variable limit, consider reformulating to shrink the model. Aggregating fine-grained variables into broader buckets often preserves optimality while drastically reducing problem size. Eliminating redundant constraints, replacing equalities with double inequalities only when necessary, and exploiting symmetry through substitution can all dramatically improve Solver performance.
Solver also pairs beautifully with data tables and what-if analysis. After finding an optimum, create a one-variable data table that varies a key constraint right-hand side and records the corresponding optimal objective. This produces a parametric sensitivity curve that visualizes diminishing returns, capacity bottlenecks, and the value of additional resources. Combined with conditional formatting, the result is a compact decision support sheet.
Multi-objective optimization is technically possible by weighting objectives or solving sequentially. For instance, you can first maximize revenue, then constrain the revenue to be no less than ninety-five percent of that maximum, and then minimize cost. This lexicographic approach delivers Pareto-efficient solutions on the revenue-cost frontier. Document each step carefully because the order of objectives matters and small changes in the relaxation percentage produce noticeably different recommendations.
Finally, version control matters more than people expect with Solver models. Because Solver overwrites variable cells with each run, careless workflow can destroy a carefully built scenario. Always keep a master template sheet with the original values, run Solver on a copy, and use named ranges so formulas remain readable even after large structural changes. Pair this discipline with thorough cell comments explaining the meaning of every constraint, and your Solver workbooks become maintainable assets rather than throwaway analyses.
The final layer of mastery is treating Solver not as a one-off calculator but as a repeatable analytical workflow. Begin every project by writing a one-paragraph problem statement that names the objective in plain language, lists the decision variables in business terms, and enumerates the constraints. Translating this statement into spreadsheet form forces clarity. If you cannot describe the problem cleanly in words, the resulting Solver model will be muddled and the optimal answer will be meaningless even if numerically correct.
Always validate Solver output against intuition before reporting it. If the optimal product mix concentrates everything on a single item, check whether that item really dominates economically or whether a constraint is missing. If the optimal portfolio puts ninety percent in one asset, verify that risk constraints reflect actual risk tolerance. Solver will obediently push toward extreme corners of the feasible region whenever the model allows, so common sense remains the final filter before publishing recommendations.
Build a standardized layout for Solver workbooks. Place inputs at the top, decision variables in a dedicated yellow-shaded block, constraints in a labeled table with current value and limit columns, and the objective in a single highlighted cell. This consistency saves time when revisiting old models and helps collaborators understand the structure quickly. Many consultants follow a one-page-per-model rule, forcing themselves to keep every Solver problem visible without scrolling, which improves both review and audit.
Document the rationale for the chosen solving engine and any non-default option settings in a cell comment next to the Solver button. Future you, opening the file in six months, will not remember why Multistart was enabled or why iteration limits were raised. A short note like uses Multistart due to multiple local optima in revenue function prevents wasted hours rediscovering the configuration. Treat Solver settings as code that deserves documentation, not as transient interface choices.
For training purposes, build a personal library of toy Solver problems with known optimal answers. Include the bakery product mix, a transportation problem, a portfolio variance problem, a scheduling problem, and a curve fit. Whenever Excel updates or you move to a new computer, run these models to verify Solver still works correctly. This catches add-in regressions, configuration drift, and stale templates before they impact real client deliverables. The library doubles as teaching material when onboarding new analysts.
Finally, recognize when Solver is the wrong tool. Problems with thousands of variables, integer programs with combinatorial complexity, or stochastic optimization with uncertain parameters often demand dedicated software. Excel Solver excels at clear, modest-scale problems where transparency matters more than raw horsepower. Knowing the boundary between what Solver handles gracefully and what requires escalation to Gurobi, CPLEX, or Python solvers like PuLP and Pyomo is a sign of true analytical maturity. Use the right tool for each problem and Solver will remain a trusted companion for years.
Mastering the Excel Solver add-in unlocks a category of analysis most spreadsheet users never attempt. From production planning to financial engineering, the same dialog box that lives quietly on the Data tab can answer questions worth millions of dollars to a business. Invest a weekend in working through five practical examples, and Solver becomes a reliable extension of your analytical instincts rather than an intimidating mystery hidden behind a checkbox.
Questions and Answers
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- learn.microsoft.com โ Retake policy, test delivery, time limit, eligibility ยท verified Oct 2026
- certiport.pearsonvue.com โ Exam format, score validity, passing score, score release, exam information ยท verified Oct 2026




