Others

Why Excel Solver Does Not Show a Sensitivity Report & How to Fix It

Steve KSteve K Nov 10, 2026 871 views

Question details

The user needs to know why Excel Solver generates an Answer Report but fails to provide a Sensitivity Report when solving optimization problems, and how to resolve this limitation.

How to Fix Excel Solver Not Showing a Sensitivity Report
Product
Microsoft Excel
Device & OS
not provided
Scenario
Solving an optimization problem using the Simplex LP method in Excel Solver.
Observed behavior
Excel returns an Answer Report but the option to generate a Sensitivity Report is missing from the Solver Results dialog.
Before you start

Ensure your optimization model is fully set up and that you are using the Simplex LP solving method, as non-linear models have different reporting behaviors.

Solution 1Recommended

Remove Integer or Binary Constraints

Excel Solver cannot generate a Sensitivity Report if the optimization model contains integer (int) or binary (bin) constraints.

Sensitivity analysis relies on continuous variables to calculate shadow prices and reduced costs. When variables are strictly forced to be whole numbers or binary choices, these mathematical calculations become impossible, prompting Excel to disable the Sensitivity Report option.

1
Open Solver Parameters

Go to the 'Data' tab on the Excel ribbon and click on 'Solver' in the Analyze group to open the Solver Parameters dialog box.

2
Locate Integer Constraints

Review the 'Subject to the Constraints' box. Look for any constraints that force a variable to be an integer ('int') or binary ('bin').

3
Remove or Modify Constraints

Select the integer or binary constraint and click 'Delete', or click 'Change' to modify it to a standard continuous inequality (<= or >=) if your model allows for fractional results.

4
Solve and Generate Report

Ensure the solving method is set to 'Simplex LP', click 'Solve', and select 'Sensitivity' from the Reports list in the Solver Results dialog.

Remove Integer or Binary Constraints
Mathematical Limitation: This is not a bug in Excel but a standard mathematical limitation of Linear Programming. You can only get a sensitivity report for models with continuous variables.
Free Microsoft Office alternative

Need a Free, Powerful Spreadsheet Tool? Try WPS Office

While standard solver add-ins share similar mathematical limitations across platforms, WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Excel for your daily data analysis and optimization needs.

  1. 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
  2. 2. Install the Software: Run the installer and follow the on-screen instructions to set up WPS Office on your device.
  3. 3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing Excel workbooks to continue your data analysis seamlessly.
Fully compatible with Microsoft Excel (.xlsx, .xls) files, ensuring no data formatting is lost.Built-in advanced data analysis tools to help solve complex calculation models effortlessly.Lightweight architecture ensures fast performance, even when processing large datasets.Familiar user interface requires zero learning curve for users switching from Microsoft Office.
microsoft office alternative - wps office

Frequently Asked Questions

What is a Sensitivity Report in Excel Solver?

A Sensitivity Report provides detailed information about how changes in the objective function coefficients or constraint right-hand sides affect the optimal solution. It includes key metrics like shadow prices, reduced costs, and allowable increases or decreases.

Can I get a Sensitivity Report with the GRG Nonlinear method?

Yes, you can generate a Sensitivity Report using the GRG Nonlinear method, provided the model does not include integer or binary constraints. However, the report will provide different mathematical metrics compared to the Simplex LP method.

Why is 'Sensitivity' completely missing from my Solver Reports list?

The 'Sensitivity' option disappears from the Reports list in the Solver Results dialog if your model contains 'int' (integer) or 'bin' (binary) constraints, or if the Solver failed to find a feasible optimal solution.