I have an optimization application using Excel Solver. I'm in an updating mode coming from 2010 or 2013 using MS 365 Excel and Solver.
I'm seeing a couple of things:
- some of the solver variable constraints appear to be missing when I review the list - which is a very tough thing to do because the constraints appear in random order.
- the setup requires that the variables all have minimum and maximum constraints. Some are INTEGER so this applies to them also. Some are BINARY so it doesn't.

Is there anything that will help review and set up the constraints? Is there any way to enter a set of structured constraints created externally?