XL7: Page Fault in Excel.exe When Open File with Pivot Table

• Microsoft Excel for Windows 95, versions 7.0

SYMPTOMS

When you open a Microsoft Excel 7.0 workbook that contains a pivot table, the following error message may appear:

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

   EXCEL caused an invalid page fault in module EXCEL.EXE at 0137:50375e112

CAUSE

This problem occurs when the following conditions exist:

• You open a workbook that contains a pivot table that accesses an external data source that has a negative zero value.

  -and-

• The negative zero value is in a field in the data source that contains less than 255 items.

WORKAROUND

Open the external data source and replace the negative zero values with zero values. Then, recreate the pivot table in a new workbook.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel for Windows 95, version 7.0a.

MORE INFORMATION

The code that Microsoft Excel uses to optimize the data in a column with less than 255 items incorrectly evaluates negative zero and zero values as the same value. When Microsoft Excel accesses the values again, there is one less item than Microsoft Excel originally processed.

The code that Microsoft Excel uses to optimize the data in a column with greater than or equal to 255 items correctly evaluates negative zero values.