Look at Sheet A in lp.xls and to use Solver do Tools and then Solver. Different Solver formats) you will get the Solver model as below: but where now we have highlighted (clicked on) two of the Reports available - Answer and Sensitivity. Click OK and you will find that two new sheets. This brief video explains the components of LP Sensitivity Analysis using an Excel Solver Report. A few questions were also answered based on the following L. Compusoft winner design 11 cracked version crack. Free quickbook license and product numbers.

manun123

New Member

Excel Solver Sensitivity Report Missing

Joined: Apr 18, 2021

Excel Solver For Mac Nt Generating Sensitivity Reports

Messages: 1

Office Version

Platform

Windows

Hi all,
I have the following problem:
I have created an Excel file which is supposed to minimize a cost function under certain constraints using the solver. (The solver is controlled via VBA and calulates the correct result, no problem.) BUT if I then want to accept the solver solution and click on the limits report to generate it, the column width of my sheet is changed and also the values from some cells are deleted. This does not happen with the other reports (Answer and Sensitivity).
Has anyone had the same porblem before or would know a solution to this?
My only idea would be to program a little macro that sets the original column width and re-inserts the deleted values.. but unfortunately I find this solution a bit unsatisfactory.
Thanks a lot and best regards
Manu