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

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.

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

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.

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.

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.

STATUS

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

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

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

283768 OFFXP: End User Privacy Policy in Application Error Reporting

289508 HOW TO: View the Error Signature from Office Application Error Reporting If Program Quits Unexpectedly