Hi. Ok.
1. From Solver's worksheet, Hit Alt + F11 to bring up vba editor.
2. Vba Editor Menu...Insert | Module
3. Paste a copy of Code into this module.

4. Vba Editor Menu... Tools | References... and select "Solver"
(This allows Solver to run)
5. Select anywhere in the code, and Hit F5 (Runs the Macro)

Save workbook.

This may not work, but... who knows. :~
There are certain things in Solver that require no spaces in the workbook
name, that's why I suggested it earlier.
Hopefully, this will spark an interest in learning Vba.
--
HTH :)
Dana DeLouis
Windows XP & Excel 2007


"Don S." wrote in message
...
Hi Dana,

That is strange and I would really like to adopt that as a workaround, but
I
know absolutely nothing about recording, writing or using vba macros.
Could
you walk me throught it or point me to a reference that I could use?

I would realy appreciate any help beyonfd he great help you have been with
this post.

Don S.
"Dana DeLouis" wrote:

Don. I was about to say I haven't seen this with xl 2007. However, I've
not used it much with xl 2007 yet.
I just loaded a very basic / simple Solver model, solved it, and asked
for
an Answer report. I also got the "Internal Error" message.
I tried all combinations of Reports, and got the same error.
With the Solver dialog box closed, I ran the following vba macro.
Weird...it generated all 3 reports with no problem.

Sub SolverRunOnly()
SolverSolve True
SolverFinish 1, Array(1, 2, 3)
End Sub

I cleaned up the worksheets, deleted reports, and Saved the workbook.
When I re-opened the workbook, I had no further problems.

Thinking that Solver's main internal sheet might be corrupt, I ran the
following on another Solver workbook, and it seemed to help.

Sub Solver_Reset_Sheet()
SOLVER.Auto_open
End Sub

I believe yoiu can also run the following as I think internally it does
the
same thing. (The code is a lttle weird, and probably a leftover from
years
ago...)

Sub Solver_Reset_Sheet_Old()
Dim B As Boolean
' A test, but actually doesn't call procedure....weird.
B = SOLVER.AutoOpened
End Sub

Again, just throwing out some ideas.
I'd be interested to hear any feedback. :0

--
HTH :)
Dana DeLouis
Windows XP & Excel 2007


"Don S." wrote in message
...
Dana,

I thought I had tried that, but I will try it again. Thanks.

Don S.

"Dana DeLouis" wrote:

Just throwing this out...
If you have a space in the workbook name, experiment by renaming your
workbook without any spaces.
Also, don't call your subroutine "Main" if it applies.
Again...just some ideas.

--
Dana DeLouis
Windows XP & Excel 2007


"Don S." wrote in message
...
MSM<

No. I still have the problem. I am not sure where else to look for
the
answer. I will be nedding this capability for a course I teach that
is
coming
up very soon now.

If you find an answer independent of this thread, I would really
appreciate
a note here. I will do the same.

I can't believe we are the only two that are being affected by
this!?


Don S.
"MSM" wrote:

Hi Don,

I am having the exact same problem.have you found a solution for
it?

Thanks for your help,
MSM

"Don S." wrote:

Hello,
I am running Excel 2007 under Vista. After running Solver, it
reaches a
solution. When I try to save either an Answer Report or a
Sensitivity
Report,
the following message appears "Solver: An unexpected internal
error
occurred,
or the available memory was exhausted". Opening the same
spreadsheet
in
Excell 2003 running under Win XP works properly.

Researching the problem, I found reference to the same error
wriiten
in
October 2000 in Article 173393. However, the workaround does not
seem
to
work. There are no merged cells on my worksheet, and there are no
other
sheets with the name Answer Report etc as discussed in the
srticle.

Since it works as it is supposed to in Excel 2003/Win XP, what do
I
do
or
what am I missing? Hopefully, this is the right group.

TIA

Don S.