Microsoft KB Archive/147185

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

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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© 2003 Microsoft Corporation. All rights reserved.