Excel solver limits report destroys sheet from which it is generated

manun123

New Member
Joined
Apr 18, 2021
Messages
1
Office Version
  1. 365
Platform
  1. 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
 

Attachments

  • After generating the report.PNG
    After generating the report.PNG
    44.4 KB · Views: 20
  • Before generating the report.PNG
    Before generating the report.PNG
    45.2 KB · Views: 16

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top