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:
If you click Details, you receive an error message similar to either of the following:
-or-
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.
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:
- On the File menu, click Save As. In the Save As dialog box, Click Options.
- In the Password To Open box, type the password you want to use, and then click OK.
- In the Confirm Password dialog box, type the same password again, and then click OK.
- In the File Name box, type a file name, and then click Save.
Additional query words: XL97 ipf
Keywords: kberrmsg kbbug kbchart KB172263