Q127986 - XL5: GP Fault Using AutoFilter with Wrapped Text

XL5: GP Fault Using AutoFilter with Wrapped Text

The information in this article applies to:

Microsoft Excel for Windows, versions 5.0, 5.0c

SYMPTOMS

When you attempt to save a file that has an AutoFilter applied to it, and the filtered cells contain wrapped text, you may receive the following error message

An error has occurred in your application. If you choose Ignore, you should save your work in a new file. If you choose Close, your application will terminate.

followed by:

Excel caused a General Protection Fault in module EXCEL.EXE at 00C8:34F0"

CAUSE

When you save your file, you will receive the general protection (GP) fault if all of the following conditions are true:

You are using the AutoFilter feature to filter your list.

Your list contains cells with wrapped text.

You have filtered the records containing the wrapped text.

You have inserted a new row in the filtered range and filled down an existing record from the line above, and the line above is the row above as well.

NOTE: For more information about this condition, see the "More Information" section of this article.

WORKAROUND

To avoid receiving the GP fault, do any of the following:

Do not filter cells containing wrapped text.

Do not insert a new row in your filtered range if you have filtered the data containing the wrapped text.

Instead of filling your data down to the newly inserted row, copy and paste the data to the new row.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

This problem occurs only if the line above is the row above as well. For example, if a list contains the following entries

A1: fieldname
A2: longtext
thatwraps
A3: a
A4: a
A5: longtext
thatwraps
A6: longtext
thatwraps

and you apply the AutoFilter to find the long text, you get this:

A1: fieldname
A2: longtext
thatwraps
A5: longtext
thatwraps
A6: longtext
thatwraps

If you select A6 and insert a row, and you then fill down from A5 to the new blank A6, you will get the "circular references" error, and a GP fault will occur when you save the file.

If you select A5 and insert a row, then fill down from A2 to the new blank A5 (that is, if you fill down across the filtered-out rows), you do not receive an error message, and you can successfully save the file.

Additional query words: 5.00c

Keywords :
Version : WINDOWS:5.0,5.0c
Platform : WINDOWS
Issue type :
Technology :