Excel Solver An Unexpected Internal Error Occurred
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Sat, 15 Oct 2016 10:24:38 GMT by s_wx1131 (squid/3.5.20)
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/solver-an-unexpected-internal-error-occurred-or/19672f1d-bdea-429b-be06-7416b2f17207 Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Solver: An unexpected internal error occurred, or available memory was exhausted http://stackoverflow.com/questions/26449529/solver-an-unexpected-internal-error-occurred-or-available-memory-was-exhausted up vote 2 down vote favorite I'm trying to use the solver from Excel in VBA but I'm having trouble. I keep getting the following error: "Solver: An unexpected internal error occurred, or available memory was exhausted." Now, I guess solver isn't out of memory as I can solve the same problem when using the solver dialog. Here's my code: Sub CoolSolverButton() SolverReset SolverOK setCell:=Range("$CK$203"), MaxMinVal:=1, ByChange:=Range("$BH$203:$BQ$222"), Engine:=2, EngineDesc:="Simplex LP" SolverAdd CellRef:=Range("$BH$203:$BQ$222"), relation:=5, FormulaText:="binary" SolverAdd CellRef:=Range("$BH$223:$BQ$223"), relation:=1, FormulaText:=Range("$BH$225:$BQ$225") SolverAdd CellRef:=Range("$BH$227:$BH$245"), relation:=1, FormulaText:=Range("$BI$227:$BI$245") SolverAdd CellRef:=Range("$BJ$227:$BJ$245"), relation:=1, FormulaText:=Range("$BK$227:$BK$245") SolverAdd CellRef:=Range("$BL$227:$BL$245"), relation:=1, FormulaText:=Range("$BM$227:$BM$245") SolverAdd CellRef:=Range("$BN$227:$BN$245"), relation:=1, FormulaText:=Range("$BO$227:$BO$245") SolverAdd CellRef:=Range("$BP$227:$BP$245"), relation:=1, FormulaText:=Range("$BQ$227:$BQ$245") SolverAdd CellRef:=Range("$BR$203:$BR$222"), relation:=2, FormulaText:=Range("$BT$203:$BT$222") SolverAdd CellRef:=Range("$BU$203:$BU$222"), relation:=2, FormulaText:=Range("$BW$203:$BW$222") SolverSolve UserFinish:=True SolverFinish KeepFinal:=1 End Sub Any ideas? Thanks! excel vba share|improve this question asked Oct 19 '14 at 10:22 Maxime Dehaene 112 try without Engine (should
Guest I get the following error when I run a VBA macro on a machine other than the one used to write the code: "Solver: An unexpected internal error occurred, or available memory was exhausted." The interesting thing is that when I open and run Solver http://www.pcreview.co.uk/threads/solver-an-unexpected-internal-error-occurred-or-available-memory.1005323/ from the menu, it initializes and works properly thereafter. I found an article describing a problem with Office 2000 that is quite similar (if not the same thing) but nothing for Office XP 2003. I suspect the problem has something to do with the initialization of Solver or perhaps a path. Guest, Mar 9, 2005 #1 Advertisements Tushar Mehta Guest Add the statement SOLVER.Auto_open before you attempt to do anything else with Solver. Hopefully, that will solve your problem. -- Regards, Tushar internal error Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article <>, says... > I get the following error when I run a VBA macro on a machine other than the > one used to write the code: > > "Solver: An unexpected internal error occurred, or available memory was > exhausted." > > The interesting thing is that when I open and run Solver from the menu, it > initializes and works properly thereafter. > > I found solver an unexpected an article describing a problem with Office 2000 that is quite > similar (if not the same thing) but nothing for Office XP 2003. > > I suspect the problem has something to do with the initialization of Solver > or perhaps a path. > > > Tushar Mehta, Mar 9, 2005 #2 Advertisements Guest Guest Re: Solver: An unexpected internal error occurred, or available me That does it! Thanks a lot for the help. Chad "Tushar Mehta" wrote: > Add the statement SOLVER.Auto_open before you attempt to do anything > else with Solver. Hopefully, that will solve your problem. > > -- > Regards, > > Tushar Mehta > www.tushar-mehta.com > Excel, PowerPoint, and VBA add-ins, tutorials > Custom MS Office productivity solutions > > In article <>, > says... > > I get the following error when I run a VBA macro on a machine other than the > > one used to write the code: > > > > "Solver: An unexpected internal error occurred, or available memory was > > exhausted." > > > > The interesting thing is that when I open and run Solver from the menu, it > > initializes and works properly thereafter. > > > > I found an article describing a problem with Office 2000 that is quite > > similar (if not the same thing) but nothing for Office XP 2003. > > > > I suspect the problem has something to do with the in