Home > Forum Home > Planning and Managing Projects > Solver error in Excel 2010 Share

Solver error in Excel 2010

Excel Help for Solver Error In Excel 2010 in Planning and Managing Projects


Forum TopicPost Reply Login

Solver Error In Excel 2010

Rate this:
(3/5 from 1 vote)
ConfusedI have Excel 2010 and whenever I try to use the Solver it gives me an error message:

"Error in model. Please verify that all cells and constraints are valid."

What could be the cause of this?

http://www.guardianinsurance.com.au/Insurance.aspx
 Posted by on
 
Replies - Displaying 1 to 3 of 3Order Replies By: Most Recent | Chronological | Highest Rated
Sad
Rate this:
(3/5 from 1 vote)
This message indicates that the conditions specified by the model to solve is not in a valid form when passed to the underlying Solver32.dll for processing. This can occur if the wrong version of either Solver.xla or Solver32.dll is installed or if (more likely) if the values of certain hidden defined names used by the Solver have been modified either manually or via VBA programming. To avoid this type of error, make sure that there are no defined names beginning with "solver" in the spreadsheet.
 Excel Business Forums Administrator
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
Hello there,

You may take help of...

http://peltiertech.com/Excel/SolverVBA.html

Hope you will able to sort out your issue.

Regards,
Kynthia Melissa
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
In Excel 2010 and later, go to File > Options
Click Add-Ins, and then in the Manage box, select Excel Add-ins.
Click Go.
In the Add-Ins available box, select the Solver Add-in check box, and then click OK.
After you load the Solver Add-in, the Solver command is available in the Analysis group on the Data tab.

Greetings,
Peter
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Solver error in Excel 2010 in the