Excel does not filter the latest entered data
Solved
tifou33
-
Alain -
Alain -
Hello,
On my columns, I've applied filters, and until recently, whenever I added a new row, it would show up directly in the filter. I now have over 130 rows, and it hasn't caused any problems. Currently, when I fill out a row and try to filter a column, it filters except for the last row. The filtered data is visible because the row number is highlighted in blue, while the last data remains black. I've tried saving, closing, and reopening, but it still doesn't filter my last row. Why? It used to work without any issues!
Does anyone have a solution?
On my columns, I've applied filters, and until recently, whenever I added a new row, it would show up directly in the filter. I now have over 130 rows, and it hasn't caused any problems. Currently, when I fill out a row and try to filter a column, it filters except for the last row. The filtered data is visible because the row number is highlighted in blue, while the last data remains black. I've tried saving, closing, and reopening, but it still doesn't filter my last row. Why? It used to work without any issues!
Does anyone have a solution?
4 réponses
Hi.
Your file has a flaw, a malfunction that I can't explain, since apparently you haven't changed the Excel options...
So do like me: Select the range A1:U227 (and not the entire columns or entire rows), COPY, open a new EXCEL file (and not another sheet of the same file) and PASTE: everything works perfectly!
--
Retirement is great! Especially in the West Indies... :-)
Raymond (INSA, AFPA, CF/R)
Your file has a flaw, a malfunction that I can't explain, since apparently you haven't changed the Excel options...
So do like me: Select the range A1:U227 (and not the entire columns or entire rows), COPY, open a new EXCEL file (and not another sheet of the same file) and PASTE: everything works perfectly!
--
Retirement is great! Especially in the West Indies... :-)
Raymond (INSA, AFPA, CF/R)
Very surprising, I see that the old file was in [accounting mode].
Thank you very much, it's definitely better this way.
This also happened to me; by selecting the row of labels where the filters were applied, removing the filter function, and reapplying it, the filter once again considered the last rows.