This means, of course, that Excel will take more time. Still if this bothers you I've set up an alternative solver model where I avoid this problem. Microsoft Customer Support Microsoft Community Forums ERROR The requested URL could not be retrieved The following error was encountered while trying to retrieve the URL: http://0.0.0.8/ Connection to 0.0.0.8 failed. After running solver everything is ok.

Last edited by Zacross; 03-16-2013 at 01:04 PM. or #DIV/0!, look for unanticipated values of the decision variables which lead to arguments outside the domains of your functions – such as a negative value supplied to SQRT. or #NAME?) in the cell calculating the objective (Target Cell) or one of the constraints. So whatever method you chose this should not matter to the result.

As this seems to solve your problem don't forget to mark your thread solved and if you like to give a rating to my answer click on the small star (bottom To look for a better solution, adjust the Convergence setting in the Solver Options dialog box so that Excel works at a higher level of precision. To guard against this last possibility, you should avoid using any defined names beginning with “solver” in your own application. ‹ Excel Solver - There is not enough memory available to I mean in itself it makes the differences huge since your model works and mine doesn't, but you do the exact same thing I did, just using another "way" to write

Besides you tell me there was nothing wrong with my setup, which makes me a bit curious to know why it isn't working... But that extra time might result in it finding a better solution. both solutions chooses 600 lb of compound 1 so both models give the same answer. You can get around this problem by setting a larger iterations value in the Solver Options dialog box.

I'll have to twist my mind to think differently and find other way to model the problems... You can often add constraints to avoid such domain errors; if you have trouble with a constraint such as $A$1 >= 0, try a constraint such as $A$1 >= 0.0001 instead.The I know where the "Div/0" come from. In essence, this message alerts you to the possibility that a better solution to your optimization modeling problem might exist.

Your cache administrator is webmaster. Save the work that Excel has already done by clicking the Keep Solver Results button when Excel displays this message. Using both the "Simplex LP" and the "GRG Nonlinear" solver you get the expected result i.e. What Do the Solver Error Messages in Excel Mean?

Your objective function might not make a lot of sense or might not be congruent with your constraint formulas. As I use Solver (Excel 2007) and you use Solver (Excel 2010) this must be the cause of the problem. Is solver that sensitive to the model? For important details, please read our Privacy Policy.

If you encounter this error, you've probably not correctly defined and described your optimization modeling problem. Alf Register To Reply + Reply to Thread « Previous Thread | Next Thread » Thread Information Users Browsing this Thread There are currently 1 users browsing this thread. (0 members In these cases, Solver typically displays a message or an error message that describes or discusses the trouble that it's having with your problem. I'll summarize quickly the actual problem in case the model I made make no sense to you without its context I must "build" a special chemical product with 3 Compound at

The time now is 04:20 AM. Solver cannot improve the current solution The message tells you that, well, Excel has calculated a rough, pretty darn accurate solution, but, again, you might be able to find a better Skip to main content Call Us: 888-831-0333 Contact Us Welcome CART Live Chat Help Desk HomeNewsBlogSolutionsProductsProduct OverviewAnalytic Solver PlatformRisk Solver PlatformPremium Solver PlatformXLMiner PlatformXLMiner SDK PlatformSolver SDK PlatformSolver EnginesRASON Analytics APIExamplesFinance You could also try to set (in Solver) $G$15 = $H$15.

For important details, please read our Privacy Policy. Solver good dog. I really have no idea why it would be just fine on excel 2007 and bug on 2010... Since you divide result by total volume (G15) your model is not linear anymore, mine is so I can use the "Simplex LP".

I didn't find any checkmark where you told me to check! I think you should try "Engine1" i.e. "Nonlinear GRG Solver" Perhaps you can upload some pictures of you Solver settings? Proposed as answer by P K Hari Saturday, February 04, 2012 12:30 PM Unproposed as answer by dbooksta Monday, February 06, 2012 3:30 PM Saturday, February 04, 2012 11:00 AM Reply Last edited by Zacross; 03-16-2013 at 11:34 AM.

Toggle navigation Search Submit San Francisco, CA Brr, it´s cold outside Learn by category LiveConsumer ElectronicsFood & DrinkGamesHealthPersonal FinanceHome & GardenPetsRelationshipsSportsReligion LearnArt CenterCraftsEducationLanguagesPhotographyTest Prep WorkSocial MediaSoftwareProgrammingWeb Design & DevelopmentBusinessCareersComputers Online Courses Please verify that all cells and constraints are valid (13). The "Div/0" error is cause by the fact that before you run solver G15 = 0. If you see this message, Solver doesn't have enough memory to solve the optimization modeling problem that you're working on.

up Excel Solver - New Messages in Excel 2010 and Excel 2011 › Product Catalog Excel Products (8) SDK Products (4) Solver Engines (12) Support Renewal (22) Consulting Help (2) Footer Oh, and one other thing: Make sure you're not using the word "solver" in any of your named variables. Friday, February 03, 2012 10:55 PM Reply | Quote All replies 1 Sign in to vote Generally, when you test a condition with solver and the report is out, your objective If you see #NUM!

However, this is supposed to be changed by solver, since G15 is determined by the Variable cells! (D3;E3;F3) However, when I launch solver (after having setup the objective, variable and constraints Please verify that all cells and constraints are valid." What could be the cause of this?http://www.guardianinsurance.com.au/Insurance.aspxPosted by maha22 on 20 Aug 2010Replies - Displaying 1 to 2 of 2Order Replies By: Solver has converged to the current solution The message tells you that Excel has found a solution but isn't particularly confident in the solution. And it's mad as heck.

Your only recourse is to attempt to free up memory, perhaps by closing any other open programs and any unneeded documents or workbooks. No optimal value for the objective function exists. There is not enough memory available to solve the problem The message is self-descriptive.