Re: Solver Error

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi !

I just want to say I have encountered the same problem,

"Solver: An unexpected internal error occurred, or available memory was
exhausted"

It happened to me using both the italian and the english version,moreover I
have used Excel 2002 v. 10.67;
sometimes it was sufficient to update the solver references, then save and
try again; if it doesn't work try to close the program and start it
again...today I could solve this problem three times but I don't know why!

L.

"Madhavan" wrote:

> Hi
> Very first time when i ran, the Msgbox gave me False...From then on it gives
> me True everytime...I suppose it should give TRUE as per what u say...
> But this does not solve my problem...
> Yeah...ofcourse i included the SOLVER.Auto_Open at the beginning of my code...
> What other possibilities u feel are there to solve this problem...?
> Thanks,
> Madhavan.R
>
>
> "Dana DeLouis" wrote:
>
> > Hi. That is interesting. Did you run your code with the following line at
> > top?
> > The line just deletes a small *** within Solver, and re-builds it. I've
> > never really understood why it needs to be re-built each time Solver is
> > loaded normally...perhaps it updates some internal DLL references or
> > something. I'd be curious on your reply, as this sometimes happens with
> > later versions of Excel as well, However, I've not experienced this issue
> > with Office 2003.
> >
> > Sub Your_Code()
> > SOLVER.Auto_open ' No harm, re-build it anyway...
> >
> > '// Your code here...
> > '// etc...
> > End Sub
> >
> > Perhaps at a later time, you can test it with the following:
> >
> > Sub YourCode()
> > If Not SOLVER.AutoOpened Then SOLVER.Auto_open
> > '// Your Solver routine below...
> > '// etc...
> > End Sub
> >
> > --
> > Dana DeLouis
> > Win XP & Office 2003
> >
> >
> > "Madhavan" <Madhavan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:9001746E-82C0-4FBD-853D-E1C061D21037@xxxxxxxxxxxxxxxx
> > > Hi Dana DeLouis,
> > > Thanks for the initiative.
> > > The Message box gives me the message "False".
> > > I use english version of Excel.
> > > Curious for your reply...
> > > Madhavan.R
> > >
> > >
> > > "Dana DeLouis" wrote:
> > >
> > >> Hi. This will not solve your problem, but could you do me a favor and
> > >> run
> > >> this at the start of your macro. I'd be curious what your MsgBox says.
> > >> Thanks.
> > >>
> > >> Sub Your_Code()
> > >> MsgBox SOLVER.AutoOpened 'Display Flag
> > >> SOLVER.Auto_open ' No harm, re-build it anyway...
> > >>
> > >> '// Your code....
> > >> End Sub
> > >>
> > >> Are you using the English version of Excel?
> > >> --
> > >> Dana DeLouis
> > >> Win XP & Office 2003
> > >>
> > >>
> > >> "Madhavan" <Madhavan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > >> news:5C9DA5DE-EDB9-4A49-AA9A-515B399F88F8@xxxxxxxxxxxxxxxx
> > >> > Thanks DucA for the updated link.
> > >> >
> > >> > But after contacting microsoft they say that the fix is available only
> > >> > on
> > >> > a
> > >> > chargeable basis. I could read the following sentence from the
> > >> > microsoft
> > >> > support page http://support.microsoft.com/gp/professionalboundary/zh-sg
> > >> > as "If a problem is determined by Microsoft to be the result of a
> > >> > defect
> > >> > in
> > >> > a Microsoft product, the customer will not be charged for that
> > >> > incident".
> > >> >
> > >> > Could anyone or any MVP's clarify me...
> > >> >
> > >> > Thanks,
> > >> > Madhavan.R
> > >> >
> > >> >
> > >> > "DucA" wrote:
> > >> >
> > >> >> Try this:
> > >> >>
> > >> >> http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B821430&Product=xlw
> > >> >>
> > >> >> its brand new! 06/08/05
> > >> >>
> > >> >> "Madhavan" escreveu:
> > >> >>
> > >> >> > Hi all,
> > >> >> > I'm getting the following error when i call solver from VBA.
> > >> >> >
> > >> >> > "Solver: An unexpected internal error occured, or available memory
> > >> >> > was
> > >> >> > exhausted."
> > >> >> >
> > >> >> > I use excel 2000 SP3 version. Is there any way to get rid of this
> > >> >> > problem?.
> > >> >> > Pls help me out.
> > >> >> > Thanks in advance,
> > >> >> > Madhavan.R
> > >> >> >
> > >>
> > >>
> > >>
> >
> >
> >
.

Quantcast