Microsoft KB Archive/178523

= XL98: Err Msg: Solver: An Unexpected Internal Error Occurred =

Article ID: 178523

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q178523



SYMPTOMS
In Microsoft Excel 98 Macintosh Edition, if you use the Solver add-in to generate the Answer report, the Limits report, or the Sensitivity report, you may receive the following error message:

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



CAUSE
This error message occurs when the following conditions are true:
 * You select one or more reports in the Solver Results dialog box. -and-


 * A sheet in the workbook has the same name as the report that Solver creates (for example, "Answer Report 1"). -or-


 * The worksheet contains merged cells.



WORKAROUND
To work around this problem, rename or delete any sheets with names that Solver uses to create reports. The following table lists these names.   Sheet Names of Solver Reports -

Answer Report Sensitivity Report Limits Report The variable increments each time you generate Solver reports.

If your worksheet contains merged cells, remove the merged cells by following these steps:
 * 1) Select the merged cell.
 * 2) On the Edit menu, point to Clear, and then click Formats.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.



MORE INFORMATION
