Excel Solver - Sensitivity Analysis

Copper Contributor

Hi friends! I am working on a linear optimization programming problem for school. I need to perform a sensitivity analysis on my models but the option is not coming up where it should under reports. Is there a solution for this?

4 Replies

Hi @ammesaros 


I understand sensitivity report is not available if you have an integer constraint. A sensitivity analysis can be performed only for models with continuous variables.

Try and check Ignore Integer Constraints checkbox under Solver Options and see if it works







This did help but unfortunately, it changed the optimal solution. It will be good enough to show our professor though. Thank you so much. @wumolad 

You are welcome


HI, I have the exact same problem, did you solve it?@ammesaros