Microsoft KB Archive/99366

{|
 * width="100%"|

XL: Solver Fails on Worksheet with Apostrophe in File Name

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0
 * Microsoft Excel for OS/2, version 3.0
 * Microsoft Excel for the Macintosh, versions 3.0, 4.0, 5.0

-

SYMPTOMS
The Solver add-in macro included with Microsoft Excel returns an error message and fails if you use it on a worksheet that contains an apostrophe (') in the file name.

WORKAROUND
To work around this problem, rename the document so that it does not contain an apostrophe in its name.

MORE INFORMATION
If you try to use Solver on a worksheet that contains an apostrophe in its filename, you receive one of the following error messages.

  Microsoft Excel version 5.0 ---

Set Target Cell must be a single cell on the active sheet.

Microsoft Excel version 4.0

Set Cell must be a cell on the active sheet

Microsoft Excel version 3.0 for Windows and Microsoft Excel version 3.0 for OS/2

Solver: An unexpected internal error occurred ($M$100). 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.

Microsoft Excel version 3.0 for the Macintosh -

Solver: An unexpected internal error occurred ($M$115). 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.

Steps to Reproduce Problem
  On a new worksheet, type the following values:

A1:     1 A2:     2 A3:     3 A4:     4 A5:     =A1*A2*A3*A4  From the File menu, choose Save As. Enter a filename that contains an apostrophe. For example, use the filename TEST'001.XLS (if you are using Microsoft Excel for Windows or Microsoft Excel for OS/2) or &quot;Today's Numbers&quot; (if you are using Microsoft Excel for the Macintosh). Save the file. From the Formula menu, choose Solver. In the Solver dialog box, set the following items to the indicated values:

Set Cell: $A$5

Equal to: Value of 100

By Changing Cells: $A$1:$A$4 Select the Solve button to begin solving the problem.

After a few seconds, one of the above error messages should be displayed. If you go back into the Solver dialog box, you will see that the $A$5 Set Cell entry has been changed to a #REF! error value.