Custom option when using Autofilter

rstone25 · Mar 14th, 2002, 08:03 AM

Hi,

Is there a limitation on how many lines can be displayed when you click on Custom in the Autofilter?

I am not getting all the data thats in the spreadsheet in the drop down list.

There are just under 3000 lines in the document.

Thanks

Al Chara · Mar 14th, 2002, 08:10 AM

As far as I know...No. Make sure your constraints are correct.

Mark W. · Mar 14th, 2002, 09:35 AM

No need to repost. See http://www.mrexcel.com/board/viewtop...2296&forum=2&1.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 08:03 AM	#1
rstone25 New Member Join Date: Feb 2002 Posts: 14	Hi, Is there a limitation on how many lines can be displayed when you click on Custom in the Autofilter? I am not getting all the data thats in the spreadsheet in the drop down list. There are just under 3000 lines in the document. Thanks

Mar 14th, 2002, 08:10 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	As far as I know...No. Make sure your constraints are correct.

Mar 14th, 2002, 09:35 AM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	No need to repost. See http://www.mrexcel.com/board/viewtop...2296&forum=2&1.