Microsoft KB Archive/172357

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 10:06, 21 July 2020 by X010 (talk | contribs) (Text replacement - """ to """)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

XL5: Error Using PivotTable in Workbook Saved by MS Excel 97

The information in this article applies to:

  • Microsoft Excel for Windows, versions 5.0, 5.0c


In Microsoft Excel version 5.0 or 5.0c, if you make any changes to a PivotTable, such as pivoting the PivotTable or selecting a different page field, you may receive the following error message:

This program has performed an illegal operation and will be shut down. If the problem persists, contact the program vendor.

If you click Details, you receive an error message similar to the following:

EXCEL caused a general protection fault in module EXCEL.EXE at 0002:00000e2e.


This problem may occur if the following conditions are true:

  • You create the PivotTable and the workbook that contains it in Microsoft Excel 5.x.
  • You open the workbook in Microsoft Excel 97, and then resave it in the Microsoft Excel 5.0/95 Workbook (*.xls) format.
  • You reopen the workbook in Microsoft Excel 5.x and make a change to the PivotTable.


To work around this problem reopen the workbook in Microsoft Excel 97, delete the original PivotTable, and then create a new PivotTable that uses the same source data. When you do this, you can save the workbook in the Microsoft Excel 5.0/95 Workbook (*.xls) format and use the PivotTable in Microsoft Excel 5.x without receiving the error messages described in the "Symptoms" section in this article.


Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: XL97 ipf gpf pivot table crash

Keywords : kberrmsg xlloadsave xlgpf xlpivot
Version : WINDOWS:5.0,5.0c
Platform : WINDOWS
Issue type : kbbug
Technology :

Last Reviewed: October 5, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.