XL97: Deleting Sheet and Closing Workbook Causes Crash

ID: Q159002

The information in this article applies to:

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.

and Microsoft Excel 97 stops responding.

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.

After you use either of these methods, you can close the workbook without receiving any error messages.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

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.

Additional query words: XL97

Keywords          : kbualink97 xlloadsave xldraw 
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbbug

Last Reviewed: November 5, 1998