Solver error in Excel 2010

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

Solver Error In Excel 2010

Rate this: (3/5 from 1 vote)

	I 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 maha22 on 20 Aug 2010

Replies - Displaying 1 to 3 of 3

Order Replies By: Most Recent | Chronological | Highest Rated

	Standard Solver error message 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 Excel Helper on 21 Aug 2010

	Solver error in Excel 2010 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 Kynthia Melissa on 04 Feb 2011

	Solver error in Excel 2010 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 petergroft on 29 Dec 2022

Displaying page 1 of 1