Auto-filter selection

J

Jason W

When I attempt to use auto filter whether selecting just the header row or
selecting the entire columns and rows or just the exact range, the autofilter
drop down box only selects the rows through 1001. I try this on another file
and it will grab the full number of rows.

I'm not sure why this is happening, but have noticed it happening seemiingly
sparaticly recently.

The file is saved as a MS Excel 97/2000 Workbook.

I noticed this becaue I generated the data in alphabetical order and when I
create an autofilter I notice that only the names through H are included in
the filter.

Any help appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 1
Macro/VB coding question 3
filter range 2
Auto Filter 3
Problems with Auto Filter 2
Blanks at end of worksheet 1
Auto-filter option 5
Auto-filter not grabbing all the data 2

Top