Autofiltering again

C

computexcel

Another of my workbooks have 1900 rows and the autofiltering is working all
the way down. Weird.
 
S

Sheeloo

What I understood from reading the earlier post;

1. In Excel 2003 there is a limit of 1,000 entries in the filter list not on
the rows to filter.
2. No limit in Excel 2007.

Only way to find out what is really going on is by looking at the file. Yoy
may send it [email protected] with then entry you are
having problem with
 
C

computexcel

Problem is solved! You just took me out of my Obssessionnnn.
1000 entries is the key.
Eventough I have a lot of biger files ( up to 5000 rows) none of them but
this one
have 1000 entries to autofilter. ( others are repeated names, this one has
unique
names).
You gave me the answer to the problem and also the solution :
get myself excell 2007.
THANKS Sheeloo.
 
S

Sheeloo

:)

I LOVE Excel 2007 but there are many who HATE its interface... Do check out
for posts on this in this fourm.

It HAS a learning curve but worth it. (Basically the difference between
Vista and XP)..
 
C

computexcel

Oh no, you got to be kidding me, Vista is a piece of S...orry program to get
our money. And now they are changing it again to another operating system
coming in
the next few months.
How come excell 2007 can be that bad ?
Isn't suppose to have more and better features everytime ?
I know Vista, believe me, it can not be compare to anything advance.
Hope Excell 2007 won't frustrate me, cause I have not choice.
THANKS for the feedback. I'll post back after buying it.
Does someone have access to get it for free? ( legally).
 
Top