Autofilter Button list details
Posted by slich on April 02, 2001 2:35 PM
Every so often I notice that the drop down list for all autofilter buttons in a spreadsheet does not contain the usual listing of unique occurences in the column - it only shows "ALL", "TOP 10", "CUSTOM". Sometimes it shows "Blanks" and "Non-Blanks" with the other 3 but does not filter properly to display Non-Blanks. I can't see any reason why this would happen - I have a very basic spreadsheet, no merged cells, no formulas. The column I am sorting only has blanks or "X". The buttons on this same spreadsheet worked fine when used last week.
Does anyone know what causes this and how I can get the filter button lists on this spreadsheet to behave as usual?