XL: App Error, Unexpected Close, or Hang Copying Chart Sheet

• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for Windows NT, version 5.0
• Microsoft Excel for Macintosh, versions 5.0, 5.0a

SYMPTOMS

In the versions of Microsoft Excel listed at the beginning of this article, when you copy a chart sheet, you may receive an application error, Microsoft Excel may close, or your computer may stop responding (hang).

CAUSE

These symptoms occur if the workbook in which the chart sheet is located is protected with a password.

RESOLUTION

To avoid these problems, follow the steps below to remove the password protection:

1. Open the file. When prompted, type in the password.

2. On the File menu, click Save As.

3. In the Save As dialog box, click Options.

4. In the Save Options dialog box, remove the password in the Protection Password box, and click OK.

5. Click Save. Click Yes when prompted to replace the existing file.

STATUS

Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed at the beginning of this article. The problem was corrected in Microsoft Excel 97 for Windows and Microsoft Excel 98 Macintosh Edition.