Forum Discussion
ammesaros
May 13, 2020Copper Contributor
Excel Solver - Sensitivity Analysis
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. ...
wumolad
May 13, 2020Steel Contributor
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
Cheers
- ammesarosMay 13, 2020Copper Contributor
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
- Adelaide0622Jan 31, 2023Copper Contributor
HI, I have the exact same problem, did you solve it?ammesaros