XL: Solver Fails on Worksheet with Apostrophe in File Name

• 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.

REFERENCES

"User's Guide 2," version 4.0, pages 79-113 "Solver User's Guide," version 3.0