XL5: Cannot Delete Records After Using AutoFilter

ID: Q114315

5.00 WINDOWS kbusage

The information in this article applies to:

Microsoft Excel for Windows, version 5.0

SYMPTOMS

In Microsoft Excel version 5.0, if you delete records from a data list when you are using the AutoFilter feature and your data list range contains hidden columns, extra records will be deleted.

WORKAROUND

To work around this problem, when using the AutoFilter, unhide all columns before you delete any rows in the filtered range.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel version 5.0 for Windows. This problem has been corrected in Microsoft Excel version 5.0c for Windows.

REFERENCES

"User's Guide," version 5.0, Chapter 21, "Filtering a List Using AutoFilter"

For more information about AutoFilter, choose the Search button in Help and type:

   AutoFilter command (Data menu)

KBCategory: kbusage KBSubcategory: xlwin

Additional reference words: 5.00 Auto Filter

Keywords          : xlwin 
Version           : 5.00
Platform          : WINDOWS

Last Reviewed: September 15, 1996