Forum Discussion
Excel filter issues
Hi
I have an excel file with dates (month) from 01/07/2016 to 30/05/2017.
Excel is only filtering the top 4 months on the list. (everytime I sort the date, either from oldest to newest or vice versa) There are no spaces, I've removed and added the filter, copied and pasted the data etc. and tried and the filter doesn't seem to work properly. The file is attached. I have Excel 2016 and Office 365. If someone can help me resolve this please, would really appreciate it!
Many thanks..
Sergei, the Excel version 1706 has a known problem with filters. It has been reported to the Excel developers. Search filters will not help in this scenario, because Excel does not include some date ranges in the filter in the first place. The search only searches in what the filter already includes. If the filter does not include it, it cannot be discovered by search.
15 Replies
- Sorry, this is the wrong place, but as a new subscriber, I cannot find a way to make a new post on a new topic.
I want to filter an Excel file, showing those cells that contain strikethrough text. I cannot find a way to do this, even in Advanced. How should I do it?
Thank youHi Manchester05 ,
Please publish as new topic - go to https://techcommunity.microsoft.com/t5/Excel/bd-p/ExcelGeneral and click Start a New Conversation
There is a known issue in Excel 1706 with date filters not showing all the dates of the data in the column.
Currently, the only workaround is to roll back to Excel 1705, where the problem does not occur. This article explains how to roll back to a previous version.
- Thank you!! Yes I think it's a bug as before the upgrade to the new version of excel, we didn't come across such an issue
Another couple workarounds could be
1) Use search filter
2) Convert data to table and use the slicer, for this particular case it's not too big
- Thank you
- Thank you!
