XL97: Page Fault Copying Worksheet That Contains a Chart

Last reviewed: January 7, 1998
Article ID: Q172263
The information in this article applies to:
  • Microsoft Excel 97 for Windows

SYMPTOMS

If you copy a worksheet in Microsoft Excel 97 with the Move or Copy command, 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 either of the following:

   EXCEL caused an invalid page fault in module EXCEL.EXE at
   0137:302d6c38.

   -or-

   EXCEL caused an invalid page fault in module <unknown> at
   0000:7c651f00.

CAUSE

This problem occurs when both of the following conditions are true:

  • The worksheet contains one or more embedded charts.

        -and-
    
  • The workbook that contains the worksheet is protected with a Password To Open.

NOTE: The Move or Copy command is available from the Edit menu, or from the shortcut menu obtained by right-clicking a sheet tab. This problem only occurs when you copy the worksheet; if you move the worksheet without creating a copy, the problem does not occur.

WORKAROUND

To work around this problem, use either of the following methods.

Method 1: Remove the Password from the Workbook

  1. On the File menu, click Save As. In the Save As dialog box, click Options.

  2. Delete any password in the Password To Open box, and then click OK.

  3. Click Save.

Method 2: Remove the Chart Before Copying

Remove the chart from the worksheet before you copy it. Once you have copied the worksheet, re-create the chart on each worksheet.

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

In Excel 97, you can protect a workbook with a password that must be entered each time you open the workbook. To do this, follow these steps:

  1. On the File menu, click Save As. In the Save As dialog box, Click Options.

  2. In the Password To Open box, type the password you want to use, and then click OK.

  3. In the Confirm Password dialog box, type the same password again, and then click OK.

  4. In the File Name box, type a file name, and then click Save.


Additional query words: XL97 ipf
Keywords : xlchart xlloadsave kberrmsg
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbbug


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: January 7, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.