| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto filter not working on all data
I have used autofilter for a long time and have not encountered this before.
5000 rows of data - autofilter has been working normally for months. Yesterday a filter stopped at row 4307, nothing below is filtered. All columns are affected. There are no blank rows, I reformatted the text to match above rows and nothing has helped. Suggestions? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
auto filter not working on all data
Turn off the AutoFilter, select the entire table, then turn on the
AutoFilter. Kaddy wrote: I have used autofilter for a long time and have not encountered this before. 5000 rows of data - autofilter has been working normally for months. Yesterday a filter stopped at row 4307, nothing below is filtered. All columns are affected. There are no blank rows, I reformatted the text to match above rows and nothing has helped. Suggestions? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
auto filter not working on all data
Thank you.
I tried that. The problem was that column A (which was hidden) did not have data in it past a certain point. Once I added info to this column the filter recognized the entire table. "Debra Dalgleish" wrote: Turn off the AutoFilter, select the entire table, then turn on the AutoFilter. Kaddy wrote: I have used autofilter for a long time and have not encountered this before. 5000 rows of data - autofilter has been working normally for months. Yesterday a filter stopped at row 4307, nothing below is filtered. All columns are affected. There are no blank rows, I reformatted the text to match above rows and nothing has helped. Suggestions? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
auto filter not working on all data
You're welcome. Thanks for describing how you solved the problem.
Kaddy wrote: Thank you. I tried that. The problem was that column A (which was hidden) did not have data in it past a certain point. Once I added info to this column the filter recognized the entire table. "Debra Dalgleish" wrote: Turn off the AutoFilter, select the entire table, then turn on the AutoFilter. Kaddy wrote: I have used autofilter for a long time and have not encountered this before. 5000 rows of data - autofilter has been working normally for months. Yesterday a filter stopped at row 4307, nothing below is filtered. All columns are affected. There are no blank rows, I reformatted the text to match above rows and nothing has helped. Suggestions? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there an easy way to filter duplicate rows of data in excel? | Excel Discussion (Misc queries) | |||
| AUTO FILTER NOT CHANGING RESULTS | Excel Discussion (Misc queries) | |||
| Data Connection wizard quits working | Excel Discussion (Misc queries) | |||
| Auto Filter not working properly | Excel Discussion (Misc queries) | |||
| excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
Linear Mode
