Excel Solver Reports: What They Show and How to Read Them

How-to basics · Updated November 21, 2026

Excel Solver does not include a standard report called an Outline report. After Solver finds a solution, it can create an Answer report, a Sensitivity report, or a Limits report on a new worksheet; each summarizes a different aspect of the optimization result.

What Excel Solver reports are for

Solver changes selected worksheet cells to optimize a target cell while respecting constraints you specify. A report is a snapshot of the result and, depending on its type, details the target, the changing cells, constraints, or sensitivity to changes in the model. Reports are useful for checking what Solver did and explaining a solution to someone who did not build the model.

They are not a substitute for checking the spreadsheet itself. A report reflects the objective, formulas, constraints, and solving method used when you ran Solver. If any of those are set up incorrectly, a neat-looking report can still describe the wrong problem. Solver reports also do not automatically update when you edit the model; run Solver again to produce a report for a new solution.

The three report names to look for are:

  • Answer: summarizes the final objective value, changing-cell values, and constraint status.
  • Sensitivity: provides sensitivity information for eligible continuous linear models, such as reduced costs and shadow prices.
  • Limits: shows how far changing-cell values can vary within their limits while the other model conditions are considered.

How to create a Solver report

In Excel for Microsoft 365 on Windows, open the workbook and choose Data > Solver. If Solver is missing, enable the add-in through File > Options > Add-ins. At the bottom of the window, choose Excel Add-ins beside Manage, click Go, select Solver Add-in, and click OK. On Excel for Mac, enable Solver through Tools > Excel Add-ins, then select Solver Add-in; the Solver command is available from the Data tab. Excel for the web does not run the traditional Solver add-in, so use desktop Excel for these reports.

Set the objective cell, choose Max, Min, or Value Of, identify the changing cells, and add the model’s constraints. Choose an appropriate solving method, then click Solve. If Solver finds a solution, the Solver Results dialog offers report choices, subject to the model and method. Select one or more reports and click OK. Excel adds each selected report as a separate worksheet in the workbook.

The dialog also asks whether to keep the Solver solution or restore the original values. Keeping the solution leaves Solver’s chosen values in the changing cells. Restoring the original values returns those cells to their pre-solve values, although the report still records the result Solver found. Save the workbook if you want to retain the reports.

What the Answer report contains

The Answer report is usually the best first report to select. It identifies the objective cell and its final value, lists the changing cells and their solution values, and summarizes constraints. Depending on the constraint, the report indicates whether it is satisfied and whether it is binding, meaning it is met exactly at the solution. A constraint that has room to spare is nonbinding.

For example, imagine a small workshop making two products. Let B2 and C2 hold the quantities of products A and B, and let B3 and C3 hold their respective profits per unit. With decision quantities in B2:C2 and profit rates in B3:C3, put this formula in D2 for total profit: =SUMPRODUCT(B2:C2,B3:C3). With resource-use rates for the two products in B5:C5 and quantities in B2:C2, put =SUMPRODUCT(B2:C2,B5:C5) in D5 to calculate use of resource one. If the corresponding rates are in B6:C6, put =SUMPRODUCT(B2:C2,B6:C6) in D6 for resource two.

Suppose profit per unit is $30 for A and $20 for B; resource-one use is 2 and 1 units per product; and resource-two use is 1 and 2. Set the available amounts in E5 and E6 to 100 and 80. Ask Solver to maximize D2 by changing B2:C2, subject to D5 being at most E5 and D6 being at most E6, with nonnegative decision quantities. Select Simplex LP because the objective and constraints are linear. The intersection of the two resource limits is 40 units of A and 20 of B: resource one is 2 × 40 + 20 = 100, and resource two is 40 + 2 × 20 = 80. Profit is 30 × 40 + 20 × 20 = $1,600. The Answer report makes those chosen quantities, the target value, and the status of both limits easier to inspect.

What the Sensitivity report tells you

A Sensitivity report helps answer a different question: how robust is the current linear solution to small changes in the model’s coefficients or resource limits? It commonly lists reduced costs for changing cells and shadow prices and allowable increases or decreases for constraints. These figures are useful for understanding the local effect of changing a profit rate or adding a little capacity, not for predicting every possible redesign of the model.

A shadow price describes the change in the optimal objective associated with a one-unit change in a constraint’s right-hand side, within the report’s allowable range and under the assumptions of the model. A zero shadow price often indicates that a constraint is not limiting the current optimum. A positive or negative value must be interpreted in context, including whether the objective is being maximized or minimized. Allowable ranges matter: outside them, the optimal basis may change, so the reported price cannot simply be extrapolated.

Reduced cost indicates how much an objective coefficient would need to improve, in the relevant direction, before a currently unused decision variable becomes attractive in the solution. The exact interpretation depends on the optimization setup and sign conventions shown in the report. Treat the report as a guide to changes around the current optimum, not as a guarantee that the same solution structure remains best after large changes.

Excel generally makes Sensitivity reports available for continuous linear models solved with Simplex LP. They are generally unavailable for models with integer or binary constraints and for nonlinear models solved with another method. If the report is absent, check the solving method and whether the model includes integer restrictions; do not assume that every successful Solver run can produce one.

What the Limits report shows

The Limits report examines the changing cells and the objective value at lower and upper limits for those cells, subject to the model’s constraints. It can help show the range over which a decision variable might move and how the target would look at the reported boundary. That makes it useful for exploring a variable’s feasible range, but it is not the same as a full sensitivity analysis.

In particular, a Limits report does not tell you the marginal value of each resource in the way a linear-programming Sensitivity report does. Nor does a listed limit mean that changing a variable independently is operationally wise: linked decisions, business requirements, and assumptions outside the spreadsheet may matter. Read the limits alongside the Answer report and the actual constraint definitions.

Choosing a report and interpreting it responsibly

Choose a report based on the question you need to answer. For a basic record of the result, select Answer. For a qualifying linear model where you want to assess changes in coefficients or resource availability, select Sensitivity. To inspect ranges for changing-cell values and related target values, select Limits. You can select multiple reports when Solver offers them, and each appears on its own worksheet.

  • Use Answer to verify the chosen values and whether each constraint is met or binding.
  • Use Sensitivity to examine local effects of changes in a continuous linear model.
  • Use Limits to review the reported lower and upper ranges for decision cells.
  • Use the original worksheet to confirm that formulas, units, and constraints represent the real problem.

Before relying on a result, check that the units agree. For instance, do not compare hours in one resource constraint with minutes in another unless the model converts them consistently. Confirm that every required decision variable is included, that bounds are intentional, and that the objective formula refers to the right cells. If quantities must be whole numbers, add integer constraints; understand that doing so can change which reports Solver makes available.

Common report problems and misconceptions

No report appears: Solver may not have returned a solution, or that report may not be available for the selected method and model. Read the Solver Results message, confirm that the model is correctly specified, and try the applicable solving method. For a linear model, Simplex LP is generally the appropriate method; nonlinear and evolutionary problems require different methods.

The Sensitivity option is missing: this is commonly because the model is not a continuous linear model solved with Simplex LP, or because it includes integer or binary restrictions. A missing report does not by itself mean that Solver failed; it can mean the requested analysis is not applicable.

A constraint is binding, but the solution still seems wrong: binding only means the constraint is reached exactly at the reported solution. It does not mean the constraint was entered correctly or that the solution is useful. Check the formula, inequality direction, and cell references in the Solver Parameters dialog.

The report disagrees with the current worksheet: reports are snapshots of a Solver run. If you edited input cells or ran Solver again, an older report may no longer describe the current model. Give report tabs clear dates or labels, or delete outdated report sheets after confirming they are no longer needed.

Frequently Asked Questions

Does Excel Solver have an Outline report?
No. The standard Solver report choices are Answer, Sensitivity, and Limits. If someone asks for an outline, they may mean a summary of the Solver results; the Answer report is usually the closest match.

Where does Excel put Solver reports?
Excel creates a new worksheet in the workbook for each report you select in the Solver Results dialog. The report is a worksheet, not a separate file.

Why can I not select a Sensitivity report?
Sensitivity reports are generally limited to continuous linear models solved with Simplex LP. Integer or binary constraints, or a nonlinear solving method, can make this report unavailable.

Can I make more than one Solver report?
Yes. Select the available report types in the Solver Results dialog before clicking OK. Excel creates a separate worksheet for each selected report.

Do Solver reports update when I change the model?
No. A report records the results of a particular Solver run. Edit the model and solve it again to create reports that reflect the changed inputs and solution.

Practical takeaway

For most users asking what an Excel Solver report is, start with the Answer report: it shows the solution, objective value, and constraint status. Add Sensitivity when the model is an eligible continuous linear problem and you need to study local changes; use Limits to examine reported ranges for decision variables. There is no standard Outline report, and the report’s usefulness depends on a correctly built model and a clear understanding of what each result does—and does not—say.

Related

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.