excel 2024: compile error in hidden module solvercode
Aug 20, 2025 · Solved. Basically, after editing my solver.xlam, I commented out every line Excel complains about (4 lines in total, each time it uses dlgSolverParameters.refObj or .refVariables). …
excel - Solver.xlam is missing? - Stack Overflow
I have performed below steps to fix Solver.xlam is missing 1 - File -> Options -> Add-Ins 2 - Click on the add ins tab then select "Manage Excel Add-Ins" at the bottom --- "GO" Enable these 4 options -> OK …
EXCEL: Solver constraints - Stack Overflow
Jan 29, 2020 · At this point I get some solver outputs that make 4 of the 5 zero, and allocates 1000 to the 1 cell. I would like to know how do I add another constraints that tells the solver that, say at least …
excel - Solver add-in error, solver32.dll not found and unexpected ...
Oct 30, 2019 · Check if solver add-in is enabled. Go to File tab > Options > Manage Excel Add-ins (Go button at the bottom of the window) and check if the Solver is enabled. If it is then try to uncheck all …
excel - How to use solver add-in with binary constraints - Stack Overflow
Oct 24, 2021 · Despite having binary constraints, solver consistently considers non-integer values in column C. I would very much appreciate some assistance to determine how to best configure the …
Adding constraints with VBA to the solver tool - Stack Overflow
Sep 6, 2011 · I am trying to add some new constraints to my excel VBA solver solution and am getting some odd behavior when I run the code. I want to do the following for a minimization problem and …
excel - How to delete Solver (SOLVER.XLAM) code - Stack Overflow
Jul 9, 2018 · Solver is Excel add-in. If you want to remove it go to Excel Application > Options > Search for add-ins > Press something like 'go to' button > un-check Solver on the list (I can't give you exact …
Reaching maximum number of solver variables? - Stack Overflow
Sep 21, 2017 · Excel solver has a limit of 200 variable cells. If you hit any more than 200 adjustable cells, you will see this message. You have 2 options: Reduce the number of adjustable cells, by …
How to use "or" in Excel Solver constraint - Stack Overflow
I am adding a constraint to Excel Solver. The constraint is saying an input data at location A3 must be either 0 or between 3 and 8. How could I add this constraint in Excel Solver since I could ...
Excel Solver not obeying binary constraint - Stack Overflow
Aug 25, 2009 · I created a model in Excel to use in conjunction with Solver. It mostly works. The only problem is that Solver is not really treating the cells constrained as binary properly. When it's done …