Microsoft KB Archive/96983

{| = Excel: Scenario Returns #REF! or #Invalid Value! =
 * width="100%"|

Last reviewed: September 12, 1996

Article ID: Q96983 The information in this article applies to:
 * Microsoft Excel for Windows, versions 4.0 and 4.0a

SUMMARY
In Microsoft Excel version 4.0, the Scenario Manager add-in macro may return a #REF! error value for cell references and an #Invalid Value! error value for the current cell when you attempt to add a scenario. This problem occurs when the filename of the document contains an apostrophe.

Workaround
To work around this problem, rename the document so that it does not contain an apostrophe.

MORE INFORMATION
Scenario Manager will not function correctly when the filename of the document (either bound or unbound) contains an apostrophe.