Microsoft KB Archive/68811

Solver Err Msg: An Unexpected Internal Error Occured… PSS ID Number: Q68811 Article last modified on 02-26-1993 PSS database name: W_eXceL

3.00 | 3.00

WINDOWS | MACINTOSH

Summary:

When you are working in Excel 3.0 in workgroup mode, Solver will return an error after you have entered the desired parameters in the Solver dialog box. Solver displays the following error message:

Solver: An unexpected internal error occurred ($M$51). Please verify that your model is correctly entered and all cells contain numeric values. If this does not correct the error, please report it to your regular Microsoft Excel support contact.

More Information:

To use Solver on a particular spreadsheet in a workgroup, disable workgroup mode. This can be done by selecting another sheet and then reselecting the desired sheet.

Alternatively the desired sheet can be selected through the Windows/Workgroup dialog box.

Both these methods will remove you from workgroup mode until another workgroup is created.

Note: This information also applies to Microsoft Excel for the Macintosh version 3.0.

Additional reference words: 3.0 3.00

Copyright Microsoft Corporation 1993.