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

ID: Q147185

The information in this article applies to:

Microsoft Excel for Windows 95, version 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.

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

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.

This problem may also occur when you use a pivot table that accesses a Microsoft Excel list or database if you imported the data to the workbook from an external data source that contains negative zero values.

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.

Additional query words: Invalid Page Fault

Keywords : xlwin
Version : 7.00
Platform : WINDOWS
Issue type :