PSS ID Number: 147185
Article Last Modified on 10/22/2000
The information in this article applies to:
- Microsoft Excel for Windows 95 7.0
This article was previously published under Q147185
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: KB147185
Technology: kbExcel95 kbExcel95Search kbExcelSearch kbExcelWinSearch