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

View products that this article applies to.

This article was previously published under Q256002

↑ Back to the top

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.

↑ Back to the top

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.

↑ 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

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.

↑ Back to the top

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.

↑ Back to the top