Autofilter limit

  • Thread starter Thread starter AndyW
  • Start date Start date
A

AndyW

Excel 2003
I have been using the autofilter function quite heavily recently and noticed
that some items have not appeared in the drop-down.
I assume that there is a limit on the number of items Excel autofilter can
handle. Does anyone know what it is and if it is the same in Excel 2007?

Many thanks

Andy
 
It is 1,000 items in 2003, and 2007 raises it to 10,000 I believe.
 
Bob Phillips said:
It is 1,000 items in 2003, and 2007 raises it to 10,000 I believe.

--
__________________________________
HTH

Bob
Click to expand...

Many thanks

Andy
 
You must log in or register to reply here.

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

Missing Menu item - AutoFilter. 2
Autofilters i Excel 2007 2
Excel Autofilter Capacity 1
AutoFilter & Hiden Rows 1
problems with autofilter and checkboxes 11
removing autofilter sort options 4
Autofilter Arrow Colours 3
Can't Autofilter converted date??!? 1

Back
Top