Microsoft KB Archive/256002

= XL2000: Excel Crashes When You Add Calculated Field to a PivotTable =

Article ID: 256002

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q256002



SYMPTOMS
When you add a calculated field to your PivotTable, Excel quits and you receive one of the following error messages.

Microsoft Windows 95 and Microsoft Windows 98
This program has performed an illegal operation and will be shut down.

When you click Details, you receive a message similar to the following:

EXCEL caused an invalid page fault in module EXCEL.EXE at 015f:300fbe4a.

When you click Close, the program quits.

Microsoft Windows NT
An Application Error has occurred and an application error log is being generated.

Microsoft Windows 2000
Excel has generated errors and will be closed by Windows. You will need to restart the program.



CAUSE
This problem occurs when you do the following:
 * You insert a calculated field into a PivotTable report.

-and-
 * The source data for the PivotTable report contains exactly 5,117 records.



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



MORE INFORMATION
A calculated field is a user-defined field in a PivotTable that can perform calculations using the contents of other fields in the PivotTable. Calculated field formulas can refer to one or more fields. For example, a calculated field named Profit that you define as:

=Sales-Expense

refers to two fields in the PivotTable named Sales and Expense.

