View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MSM MSM is offline
external usenet poster
 
Posts: 8
Default Excel 2007 Solver Internal Error When Generating Answer Report

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.