Excel solver limits report destroys sheet from which it is generated

M

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

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
You must log in or register to reply here.

Similar threads

A
  • Question Question
Dynamically add new rows via VBA when using IFERROR TEXTJOIN and FILTER formulas from Table?
Replies
0
Views
508
AlfredDB
A
B
  • Question Question
Excel Solver | Need help resolving a constrained optimization problem
Replies
2
Views
2K
Majuba
M
M
  • Question Question
How do I pull data from another sheet (Sheet 2) into a column sheet 1 which matches data of another column
Replies
3
Views
560
Fluff
Fluff
R
  • Question Question
Generate dynamic templates with varying mandatory and non-mandatory fields depending on the product type chosen.
Replies
1
Views
1K
RajK2005
R
M
  • Question Question
VBA/Macros help for an Excel to Word document generator. Need to create and find/replace X tables, where X is the numberof rows TRUE in another sheet
2
Replies
10
Views
2K
NdNoviceHlp
NdNoviceHlp

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

Share this page

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