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

ID: Q131256

The information in this article applies to:

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.

You can now copy the chart.

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.

Additional query words: 5.00 5.00a 5.00c 7.00 7.0a XL7 XL5

Version           : WINDOWS:5.0,5.0c,7.0,7.0a; MACINTOSH:5.0,5.0a
Platform          : MACINTOSH WINDOWS
Issue type        : kbprb

Last Reviewed: February 4, 1998