Autofilter does not show values from 2022

Not applicable

Excel for Mac v.16.65


I have a long list with dates and times in column "Datum och tid", from 2020 to 2022


When I use autofilter on this column, autofilter only displays the values from 2020 and 2021


Any idea how I can solve this? Some error in Excel that is never solved by Microsoft


Skärmavbild 2022-09-14 kl. 10.22.18.png

1 Reply

I suspect you have an empty row above the row where the dates from 2022 begin. Delete it and try again.