Excel 2002 Stops Responding After You Save File in Excel 97-2002 & 5.0/95 Workbook Format

View products that this article applies to.

This article was previously published under Q284866

Thank You for Your Help!

Microsoft thanks you for taking the time to send us information about the program error that you just experienced. After investigating error reports provided by users like you, our engineers devised a workaround for this problem. This article contains information that may help you avoid experiencing this problem again in the future.

Back to the top

Error Signature

This article addresses a crash problem that can have the following error signature:

App Name      App Version      Module Name      Module Version    Offset
--------------------------------------------------------------------------
Excel.exe     10.0.2614.0      Excel.exe        10.0.2614.0       00143390

Expand all | Collapse all

SYMPTOMS

In Microsoft Excel 2002, when you try to save a file in Microsoft Excel 97-2002 & 5.0/95 Workbook format, Excel 2002 stops responding and displays the following error message, and your file is not saved.

Microsoft Excel has encountered a problem and needs to close. We are sorry for the inconvenience.

To see what data this error report contains, click here.

When you view the data in the error report, the report contains an error signature similar to the error listed at the beginning of this article.

Back to the top

CAUSE

This behavior occurs when all of the following conditions are true:

The file contains a PivotTable.

-and-
The file is password protected.

-and-
You changed the file's encryption type from Weak Encryption (XOR) to either Office 97/2000 Compatible or RC4 since the last time that you saved the file.

Back to the top

WORKAROUND

To work around this problem, follow these steps:

Open the encrypted file.
On the Tools menu, click Options.
Click the Security tab, and then click Advanced.
In the Encryption Type dialog box, select the encryption type that you want, and then click OK.
Click OK again.
On the File menu, click Save As. In the Save as type list, select Microsoft Excel Workbook (*.xls), and then click Save.
On the File menu, click Save As. In the Save as type list, select Microsoft Excel 97-2002 & 5.0/95 Workbook (*.xls), and then click Save.

Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Back to the top

MORE INFORMATION

The Office Error Reporting dialog box appears when an error occurs that results in a fatal event in the program. The dialog box includes a button to send the information about the fatal event to Microsoft. Microsoft gathers information about these types of events in a database to try to identify the cause. For more information about the Microsoft Data Collection Policy, visit the following Microsoft Web site:

http://oca.microsoft.com/en/dcp20.asp (http://oca.microsoft.com/en/dcp20.asp)

For additional information, click the following article numbers to view the following articles in the Microsoft Knowledge Base:

283768 (http://support.microsoft.com/kb/283768/EN-US/ ) OFFXP: End User Privacy Policy in Application Error Reporting

289508 (http://support.microsoft.com/kb/289508/EN-US/ ) HOW TO: View the Error Signature from Office Application Error Reporting If Program Quits Unexpectedly

Back to the top