XL97: Excel Hangs Opening Scenario Manager on a Protected Sheet

ID: Q173311

The information in this article applies to:

Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel, if you try to open Scenario Manager, you may receive the following error message:

This program has performed an illegal operation and will be shut down.
If the problem persists, contact the program vendor.

If you click Details, you receive an error message similar to the following:

Excel caused an invalid page fault in module Excel.exe at 0137:3021b740.

NOTE: If you are using Microsoft Windows NT 4.0, Excel may unexpectedly quit without displaying an error message.

CAUSE

This problem may occur when all of the following conditions are true:

You create a scenario and select the Hide check box.

You protect the worksheet, and select the Scenarios check box in the Protect Sheet dialog box.

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 xlui
Version : WINDOWS:
Platform : WINDOWS
Issue type : kbbug