Article ID: 172263
Article Last Modified on 10/22/2000
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q172263
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.
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
- On the File menu, click Save As. In the Save As dialog box, click
Options.
- Delete any password in the Password To Open box, and then click OK.
- 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. This problem no longer occurs in
Microsoft Excel 2000.
Additional query words: XL97 ipf
Keywords: kberrmsg kbbug kbchart KB172263