Article ID: 173311
Article Last Modified on 8/6/2002
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q173311
SYMPTOMS
In Microsoft Excel, if you try to open Scenario Manager, you may receive one of the following error messages.
Microsoft Windows 95 or Microsoft Windows 98
If you click Details, you receive an error message similar to the following:
Microsoft Windows NT 4.0
Excel may unexpectedly quit without displaying an error message.
Microsoft Windows 2000
If you view the Application Log in the Event Viewer, you see a message similar to the following:
where Date
and Time
are the date and time when the error occurred.
CAUSE
This problem may occur when all of the following conditions are true:
- You create a scenario and select the Hide check box. -and-
- You protect the worksheet, and select the Scenarios check box in the Protect Sheet dialog box. -and-
- You only have one scenario in the worksheet.
RESOLUTION
To prevent this problem, create more than one scenario in your worksheet. Selecting the Hide option will not cause Excel to stop responding if you create two or more scenarios.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem no longer occurs in Microsoft Excel 2000.
MORE INFORMATION
When you select the Scenarios check box in the Protect Sheet dialog box, you cannot do the following:
- View scenarios that are hidden.
- Make changes to or delete scenarios that are protected.
However, you can edit the values in the changing cells if the cells are not protected. You can also add new scenarios.
REFERENCES
For more information about scenarios, click the Index tab in Microsoft Excel Help, type the following text:
Scenarios, creating
and then double-click the selected text to go to the "Create a scenario" topic.
Additional query words: XL97 manager
Keywords: kberrmsg kbbug kbfix KB173311