XL97: Deleting Sheet and Closing Workbook Causes Crash

• Microsoft Excel 97 for Windows

SYMPTOMS

When you close a workbook in Microsoft Excel 97, you receive one of the following error messages:

   EXCEL caused an invalid page fault in module EXCEL.EXE at
   014f:300a05e7.

   -or-

   EXCEL caused an invalid page fault in module EXCEL.EXE at
   0137:300a05e7.

CAUSE

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

• One of the sheets in the workbook contains a drawing object or AutoShape, and you copy the drawing object or Autoshape by clicking Copy on the Edit menu.

      -and-
  

• You delete the sheet that contains the copied object.

      -and-
  

• You closed the workbook without saving it.

WORKAROUND

To prevent this problem from occurring, do either of the following:

• Save the workbook before you close it.

      -or-
  

• Clear the copied drawing object or AutoShape from the clipboard. To do this, use the following steps:

        1. Select any cell in a worksheet.
  

        2. On the Edit menu, click Copy, and then, press ESC.
  

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 copy a drawing object or Autoshape in Microsoft Excel 97, a pointer to the copied object is stored in the clipboard. If you delete the sheet that contains the copied object, and then close the workbook without saving it, the pointer refers to an object on a nonexistent sheet. This may cause you to receive either of the error messages.