Excel Solver is not retaining correct constraints when solving

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Am using excel and visual basic to create a program to optimize a vehicle
routing problem. I can not get my model just right, so I have left out of VB
and am trying to fix my model. I am using Excel Solver Add-in for this, and I
noticed that after I attempt to have it solve the problem, the constraints
have changed.

PLease help....
 
Hi,

Just to make sure:
- by constants you mean cells containing a simple number ie no formula
- These constant cells are not listed in the "By Changing cells" box of the
Solver Parameters dialog. And this entry box doesn't contain any Named Range
including these cells . (if named ranges are used here, check by selecting
each of them in the Name box of excel that they don't include these cells.)

If all of the above is ok, please describe the problem you are trying to
solve in more details, as well as the solver parameters details.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA not adding elements to Solver model 0
Identical Solver for Many Worksheets 0
Set solver constraint not working in VB 6
Programming Solver 1
Excel Solver 4
Premium Solver Macro Problem 3
using Solver add-in 6
Issue with Solver in Macro 0

Back
Top