Filter Option

[saraskandan]

Hi,

If someone could help me with the Auto Filter option.

I have 8000 records in a worksheet. If I choose Auto Filter option and
click drop down button I am able to view only 1000 records and not more
than that. If I need to view all the records. How can I do it and what
is the option?

 

[Guest]

Debra Dalgleish exhibits some options at her Contextures website:

http://www.contextures.com/xlautofilter02.html#Limits

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[saraskandan]

Is there any other way to increase the limit....

 

[Debra Dalgleish]

There may be other workarounds, but there's no setting you can change to
increase the 1000 item limit.