Sir, Filter for the year 2016 is not displaying in my pc for this excel file. It displaying only 2017 year. I can't able to filter 2016 year in my pc. But its working in other pc. For your reference i have attached screenshot.
Sir, Filter for the year 2016 is not displaying in my pc for this excel file. It displaying only 2017 year. I can't able to filter 2016 year in my pc. But its working in other pc. For your reference i have attached screenshot.
1. do a quick test. =isnumber(cell-with-2016-date-in-it) if it returns FALSE, your dates are really text not dates and we will need to convert them
2. Remove the filter (completely) and re-apply it, see if that halps?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I can't understand. Say easily
upoad a sample workbook, I will take a look for you
Hi
Do you have build 1706 of Excel 2016 by any chance? If so, it is beginning to look like there is a bug with it. Rolling back to build 1705 will fix the problem.
Don
Please remember to mark your thread 'Solved' when appropriate.
It was working in other pc but in my pc its not working. It is 17mb i can't upload here
We dont need teh whole file, delete everything that is not related to the filtered data, save under another name and then upload that?
If the same file works on one computer but not another, it is more likely to be a software issue than a problem with the workbook itself.
Are you using Excel 2016? If you are, please check the build number under Account info on the computer that doesn't work. If it's 1706, that is the cause of your problem.
Please check in this file. In my put i put filter means it comes only 2017 only not displaying 2016 datas so i can't able to filter 2016 datas. check and replay.
Interesting. I dont see 2016 either. I am, also using build 1706
If I delete about 20 000 rows it then shows 2016, so it seems there is a row limit to the filter
Same problem on Office 365, so whatever the bug is, it hasn't been fixed yet.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
AFAIK, it has only just been introduced.
Please provide solution
There isn't one. Please contact Microsoft to find out when the bug will be fixed.
You need to roll your installation back to build 1705- https://support.microsoft.com/en-us/...fice-2016-clic
or wait for a fix to be rolled out.
but it was working on another PC, how ?
Have you read the thread properly? The other PC is running an earlier version of Excel.
They must have an earlier build.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks