+ Reply to Thread
Results 1 to 26 of 26

Date filter not showing all dates

  1. #1
    Registered User
    Join Date
    07-04-2017
    Location
    Kuwait
    MS-Off Ver
    2016
    Posts
    11

    Date filter not showing all dates

    In my autofilter, dates after June 25 are not shown in the drop down

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Date filter not showing all dates

    Difficult to comment without seeing the workbook.

    Probably because there is a gap after June 25th?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    07-04-2017
    Location
    Kuwait
    MS-Off Ver
    2016
    Posts
    11

    Re: Date filter not showing all dates

    No. Thre is no gap.
    Attached Files Attached Files

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Date filter not showing all dates

    I don't see any missing dates. The drop down shows all dates through to the last 2nd July dates.

    What are you doing when you say you can't see dates post 25/6?

  5. #5
    Registered User
    Join Date
    07-04-2017
    Location
    Kuwait
    MS-Off Ver
    2016
    Posts
    11

    Re: Date filter not showing all dates

    Sorry, it is 25 May rather. I am attaching the screen shots of what I see in the drop-down.
    Attached Images Attached Images

  6. #6
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Date filter not showing all dates

    Have you scrolled all the way down the list of May dates?

  7. #7
    Registered User
    Join Date
    07-04-2017
    Location
    Kuwait
    MS-Off Ver
    2016
    Posts
    11

    Re: Date filter not showing all dates

    Yes, I did

  8. #8
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Date filter not showing all dates

    Is the picture you show from the same workbook you uploaded?

    Otherwise I'm struggling to understand why you have an apparent problem since I can't replicate it.

  9. #9
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Date filter not showing all dates

    I see the name Routes is linked to another workbook. Not sure why that should make a difference but have you tried removing the name.

  10. #10
    Registered User
    Join Date
    07-04-2017
    Location
    Kuwait
    MS-Off Ver
    2016
    Posts
    11

    Re: Date filter not showing all dates

    The pictures are from the same workbook.
    The name "Routes" is for some validation rules. I removed all the validation rules and all the name. Still the result is same.

  11. #11
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be everywhere
    MS-Off Ver
    All on PC except 365
    Posts
    9,836

    Re: Date filter not showing all dates

    maybe try this:
    go to the ribbon DATA - Filter ("unclick" filter)
    then click anywhere in your table and use Ctrl+T, tick: My table has headers, Ok

    now check if you've the same problem as before
    sandy
    I want to see what you are trying to achieve, not how you are trying to do it
    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  12. #12
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,927

    Re: Date filter not showing all dates

    I have download your file & showing all months properly.
    Your screenshot as per your attach file.
    Refer attachment which is as per your attach file #3
    Attached Images Attached Images


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  13. #13
    Registered User
    Join Date
    07-04-2017
    Location
    Kuwait
    MS-Off Ver
    2016
    Posts
    11

    Re: Date filter not showing all dates

    Tried this. the problem persists

  14. #14
    Registered User
    Join Date
    07-04-2017
    Location
    Kuwait
    MS-Off Ver
    2016
    Posts
    11

    Re: Date filter not showing all dates

    Quote Originally Posted by sandy666 View Post
    maybe try this:
    go to the ribbon DATA - Filter ("unclick" filter)
    then click anywhere in your table and use Ctrl+T, tick: My table has headers, Ok

    now check if you've the same problem as before
    Tries this. The problem persists

  15. #15
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be everywhere
    MS-Off Ver
    All on PC except 365
    Posts
    9,836

    Re: Date filter not showing all dates

    so try copy all data into brand new excel file and check again

  16. #16
    Registered User
    Join Date
    07-04-2017
    Location
    Kuwait
    MS-Off Ver
    2016
    Posts
    11

    Re: Date filter not showing all dates

    Quote Originally Posted by sandy666 View Post
    so try copy all data into brand new excel file and check again
    Already tried

  17. #17
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,927

    Re: Date filter not showing all dates

    Go to name manager & delete name "Routes"
    Clear all filter columns & set again filter & try.

  18. #18
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be everywhere
    MS-Off Ver
    All on PC except 365
    Posts
    9,836

    Re: Date filter not showing all dates

    No more ideas.
    I can say only: reinstall office. this is ca. 30 minutes or less

  19. #19
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be everywhere
    MS-Off Ver
    All on PC except 365
    Posts
    9,836

    Re: Date filter not showing all dates

    try with this file:
    Attached Files Attached Files
    Last edited by sandy666; 07-04-2017 at 08:37 AM.

  20. #20
    Registered User
    Join Date
    07-04-2017
    Location
    Kuwait
    MS-Off Ver
    2016
    Posts
    11

    Re: Date filter not showing all dates

    Quote Originally Posted by sandy666 View Post
    try with this file:
    No difference.

    One thing i noticed is, on 25/05 the table crosses 10000 records. But they are not uniqe

  21. #21
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Date filter not showing all dates

    Quote Originally Posted by ManuMFK View Post
    No difference.

    One thing i noticed is, on 25/05 the table crosses 10000 records. But they are not uniqe
    Indeed. there's a limit of 100000 unique items in a drop down.

    See here about 6 pages down https://support.office.com/en-gb/art...7-269d656771c3

  22. #22
    Registered User
    Join Date
    07-04-2017
    Location
    Kuwait
    MS-Off Ver
    2016
    Posts
    11

    Re: Date filter not showing all dates

    Quote Originally Posted by Richard Buttrey View Post
    Indeed. there's a limit of 100000 unique items in a drop down.

    See here about 6 pages down https://support.office.com/en-gb/art...7-269d656771c3
    But that is in case of unique data. My data is not unique. So it must be displayed in dropdown. Also the problem is in my pc only. Some persons who replied in this thread said they are able to list all the data in dropdown.
    Last edited by ManuMFK; 07-05-2017 at 05:32 AM.

  23. #23
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be everywhere
    MS-Off Ver
    All on PC except 365
    Posts
    9,836

    Re: Date filter not showing all dates

    try with PT
    Attached Files Attached Files

  24. #24
    Registered User
    Join Date
    09-25-2017
    Location
    Tallahassee, Florida
    MS-Off Ver
    Office 365
    Posts
    1

    Re: Date filter not showing all dates

    I've had the same problem when I've exported large amounts of data as delimited csv files and forgotten to save it as an Excel format file. In these cases the filters wouldn't show all the dates, and were probably treating each row as a unique value even though they appeared to have the same data. Once I converted to Excel I've still had problems if I sort the dates - Once again it sometimes cuts of the later dates. The best thing to do would be to import the data into Access if you still have the filter limit issue.

    If this is the case for you, make sure to save the file first in an Excel format and try it again. I hope this helps or that you've already found a solution.
    Last edited by Oudman; 09-25-2017 at 09:58 AM.

  25. #25
    Registered User
    Join Date
    07-04-2017
    Location
    Kuwait
    MS-Off Ver
    2016
    Posts
    11

    Re: Date filter not showing all dates

    My problem was solved itself. Seems the problem was with some update of office. The later update did the job.

  26. #26
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be everywhere
    MS-Off Ver
    All on PC except 365
    Posts
    9,836

    Re: Date filter not showing all dates

    So, If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Chart not showing MY dates, ive tried Text and date axis
    By rikkyshh in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-02-2015, 06:24 PM
  2. [SOLVED] Date filter for specific dates
    By excelhelpseeker in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-14-2015, 05:37 AM
  3. [SOLVED] Filter dates according to current date
    By babbeleme1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2013, 04:57 PM
  4. [SOLVED] 1900 year date when filter column of dates
    By rz6657 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-03-2013, 12:18 PM
  5. [SOLVED] Date Filter based on Cell Input - single date or range of dates
    By babaloo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2012, 10:32 AM
  6. Problem with Date Filter between two dates
    By bhaskar_bkp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2010, 01:20 PM
  7. Filter by showing dates in between
    By Brice112 in forum Excel General
    Replies: 3
    Last Post: 04-27-2010, 01:14 PM

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