XL2000: Excel Crashes When You Add Calculated Field to a PivotTable (256002)


The information in this article applies to:

  • Microsoft Excel 2000
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.

REFERENCES

For more information about creating calculated fields in your PivotTable report, click Microsoft Excel Help on the Help menu, type create a calculated field in a pivottable or pivotchart report in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:9/25/2003
Keywords:kbbug kbpending KB256002
©2003 Microsoft Corporation. All rights reserved.