Troubleshooting Excel and Solver Foundation

Solver Foundation 3.0

This section contains tips for solving common problems that you might encounter when you use the Solver Foundation Excel add-in.

If you use the Automatic Editing Mode in the Modeling Pane, the comments may be removed from the OML code. To work around this issue, use Annotation to add metadata to a parameter, decision, constraint, or goal. For more information, see Optimization Modeling Language (OML).

For information and tips on solving non-linear models using Solver Foundation, see Solving Nonlinear Models using the Default Solver.