Autofiltering again
 

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

Autofiltering again
 

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 tethisportion with then entry you are
having problem with

"computexcel" wrote:

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

Autofiltering again
 

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.

"Sheeloo" wrote:

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 tethisportion with then entry you are
having problem with

"computexcel" wrote:

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

Autofiltering again
 

:-)

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)..

"computexcel" wrote:

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.

"Sheeloo" wrote:

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 tethisportion with then entry you are
having problem with

"computexcel" wrote:

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

Autofiltering again
 

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).
"Sheeloo" wrote:

:-)

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)..

"computexcel" wrote:

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.

"Sheeloo" wrote:

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 tethisportion with then entry you are
having problem with

"computexcel" wrote:

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

Autofiltering again
 

See what I mean? Lot of people react like that about Excel 2007 too...
(btw I love both Office 2007 and VISTA...)

You can try Office 2007 for 60 days.... Go to
http://office.microsoft.com/en-us/excel/default.aspx

Share your findings/frustrations with me -
vethispart

"computexcel" wrote:

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).
"Sheeloo" wrote:

:-)

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)..

"computexcel" wrote:

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.

"Sheeloo" wrote:

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 tethisportion with then entry you are
having problem with

"computexcel" wrote:

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

Autofiltering again
 

Thanks for the link I'll try excell 2007.
Vista, not even free.

"Sheeloo" wrote:

See what I mean? Lot of people react like that about Excel 2007 too...
(btw I love both Office 2007 and VISTA...)

You can try Office 2007 for 60 days.... Go to
http://office.microsoft.com/en-us/excel/default.aspx

Share your findings/frustrations with me -
vethispart

"computexcel" wrote:

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).
"Sheeloo" wrote:

:-)

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)..

"computexcel" wrote:

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.

"Sheeloo" wrote:

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 tethisportion with then entry you are
having problem with

"computexcel" wrote:

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