To accept the constraint and return to the Solver Parameters dialog box, click OK. To accept the constraint and add another, click Add. If you choose = for the relationship in the Constraint box, type a number, a cell reference or name, or a formula. If you click dif, alldifferent appears in the Constraint box. If you click bin, binary appears in the Constraint box. In the Cell Reference box, enter the cell reference or name of the cell range for which you want to constrain the value.Ĭlick the relationship ( =, int, bin, or dif ) that you want between the referenced cell and the constraint.If you click int, integer appears in the Constraint box. In the Solver Parameters dialog box, click Add. In the Subject to the Constraints box, enter any constraints that you want to apply by doing the following: You can specify up to 200 variable cells. The variable cells must be related directly or indirectly to the objective cell. Separate the non-adjacent references with commas. In the By Changing Variable Cells box, enter a name or reference for each decision variable cell range. If you want the objective cell to be a certain value, click Value of, and then type the value in the box. If you want the value of the objective cell to be as small as possible, click Min. If you want the value of the objective cell to be as large as possible, click Max. The objective cell must contain a formula. In the Set Objective box, enter a cell reference or name for the objective cell.

So I clicked 'Browse' on the bottom and select Solver.Xlam.Īfter this error pops up, the location it is looking for Solver.Xlam at resets to the previous location.Note: If the Solver command or the Analysis group is not available, you need to activate the Solver add-in. When I search on OSX I find the solver is at /Applications/Microsoft Office 2011/Office/Add-Ins. I realized that the address it thinks the solver is at is where the solver is on my PC, but not where it is on OSX. I went into the developer side, and went to Tools -> Reference, and found that Solver.Xlam is missing. I remembered this happening on the PC side before I enabled the solver, so I went into Tools -> Add-ins and then enabled the Solver.Xlam. When I tried to compile the project, it says 'Compile Error: Can't find Project or Library'. I then tried to use this same program on Excel 2011, and ran into an issue. I made sure it worked on both Excel 2010 and Excel 2013 for PC. I created a program in Excel 2010 on my PC that relies on the built-in solver for Excel.

Solver add in excel 365