+ Reply to Thread
Results 1 to 18 of 18

Filter is not working in my PC

  1. #1
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Filter is not working in my PC

    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.
    Attached Images Attached Images

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Filter is not working in my PC

    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

  3. #3
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Re: Filter is not working in my PC

    I can't understand. Say easily

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Filter is not working in my PC

    upoad a sample workbook, I will take a look for you

  5. #5
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Filter is not working in my PC

    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.

  6. #6
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Re: Filter is not working in my PC

    It was working in other pc but in my pc its not working. It is 17mb i can't upload here

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Filter is not working in my PC

    We dont need teh whole file, delete everything that is not related to the filtered data, save under another name and then upload that?

  8. #8
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Filter is not working in my PC

    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.

  9. #9
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Re: Filter is not working in my PC

    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.
    Attached Files Attached Files

  10. #10
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Filter is not working in my PC

    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

  11. #11
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,403

    Re: Filter is not working in my PC

    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.

  12. #12
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Filter is not working in my PC

    AFAIK, it has only just been introduced.

  13. #13
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Re: Filter is not working in my PC

    Please provide solution

  14. #14
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,403

    Re: Filter is not working in my PC

    There isn't one. Please contact Microsoft to find out when the bug will be fixed.

  15. #15
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Filter is not working in my PC

    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.

  16. #16
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Re: Filter is not working in my PC

    but it was working on another PC, how ?

  17. #17
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,403

    Re: Filter is not working in my PC

    Have you read the thread properly? The other PC is running an earlier version of Excel.

  18. #18
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Filter is not working in my PC

    They must have an earlier build.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. greater than filter not working
    By stephme55 in forum Excel General
    Replies: 1
    Last Post: 02-04-2017, 02:07 AM
  2. [SOLVED] Less Than Filter Not Working
    By rbirch in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-21-2016, 03:12 PM
  3. filter not working
    By superchew in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-29-2016, 06:34 PM
  4. [SOLVED] filter not working
    By Learning ExL in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2015, 05:34 PM
  5. Specified filter not working...
    By pharaz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-09-2012, 10:29 AM
  6. why filter is not working
    By reedzhou in forum Excel General
    Replies: 1
    Last Post: 12-09-2010, 01:21 AM
  7. [SOLVED] Filter isn't working with a VBA Code
    By [email protected] in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-15-2006, 08:25 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1