XL97: Excel Hangs Opening Scenario Manager on a Protected Sheet

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

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

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. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

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.

REFERENCES

For more information about scenarios, click the Index tab in Microsoft Excel Help, type the following text:

   Scenarios, creating