Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering a column, where it stopped showing records
I have a spreadsheet with close to 12,000 rows and 7 columns of data , and
have filters on each of the columns. As of this past Tuesday, the filter stopped showing data past the letter S (info goes down to letter X). I cannot fix this and neither can my IT dept. Any one know how to correct this? Thanks Reid |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering a column, where it stopped showing records
What you're describing is a known "feature" of Excel.
Debra Dalgleish describes the issue in the below website (along with some workarounds): http://www.contextures.com/xlautofilter02.html#Limits Does that help? *********** Regards, Ron XL2002, WinXP "Reid_co" wrote: I have a spreadsheet with close to 12,000 rows and 7 columns of data , and have filters on each of the columns. As of this past Tuesday, the filter stopped showing data past the letter S (info goes down to letter X). I cannot fix this and neither can my IT dept. Any one know how to correct this? Thanks Reid |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Matching the same amount of records in one value to another column | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) |