Why Excel Solver Does Not Show a Sensitivity Report & How to Fix It
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.

- 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.
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.
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.
Go to the 'Data' tab on the Excel ribbon and click on 'Solver' in the Analyze group to open the Solver Parameters dialog box.
Review the 'Subject to the Constraints' box. Look for any constraints that force a variable to be an integer ('int') or binary ('bin').
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.
Ensure the solving method is set to 'Simplex LP', click 'Solve', and select 'Sensitivity' from the Reports list in the Solver Results dialog.

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. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install the Software: Run the installer and follow the on-screen instructions to set up WPS Office on your device.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing Excel workbooks to continue your data analysis seamlessly.

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.




