+ Reply to Thread
Results 1 to 7 of 7

Filtering Values not showing all data

  1. #1
    Registered User
    Join Date
    08-02-2017
    Location
    Sudbury, Ontario
    MS-Off Ver
    Office 365
    Posts
    4

    Filtering Values not showing all data

    Hi,

    My workbook contains a column (A) that has dates in it(65000 ish total rows), which are every Saturday from January 2015 to present (130 or so unique values).
    Up until a week ago, the filtering of this column allowed me to filter by Year->Month->Day/week.

    Now for some reason it will not let me filter past May30th 2015.
    That date happens to be around line 10000.
    For trouble shooting purposes I deleted all of may 30th 2015 data, and it will then show me the following June 6th data, which again stops the data in the filtering values list around row 10000...

    And to add to the mess that this is becoming. The filtering will work on some users computers but not on others...

    Hard to explain, but is there some limitation in Excel that is stopping the filters from looking past row 10000? Or a user setting that can be adjusted?
    There are no blank rows.
    I've pasted just that column into another workbook and the same issue occurs.

    Can someone please enlighten me?

    I tried to add the file as an attachment to this post, but it is not working for me. I can send via email if you are willing to help.

    Thanks in advance;
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Filtering Values not showing all data

    I tried it on my computer in column A, and select 4-3-2017 which start in row 50718.

    No problems with that on this computer.

    You are working on an old computer, so the processing is slow?
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    08-02-2017
    Location
    Sudbury, Ontario
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Filtering Values not showing all data

    Two different computers experiencing the same problem.
    Both relatively new, one running windows 7, the other windows 10.

    Attached is a screenshot showing the values I get in the filter.
    As you can see at the bottom, there are 2017 values...
    Attached Images Attached Images

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Filtering Values not showing all data

    Another filter open, before you filter on column A?

    Is there VBA code in the file?

  5. #5
    Registered User
    Join Date
    08-02-2017
    Location
    Sudbury, Ontario
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Filtering Values not showing all data

    There is no filter before, I can paste the values into a new sheet and it does the same thing in a blank workbook.
    There is VBA in the original file, but it exhibits the same behaviour when in new workbook as well as the workbook originally attached to this thread.

    It almost seems like it's something specific to the user/computers (excel setting of some sort?).
    I have tried a fresh install of office on these machines also...

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Filtering Values not showing all data

    I'm out of options on the moment.

    Good luck with the problem. Maybe other forummembers recognise this problem.

  7. #7
    Registered User
    Join Date
    08-02-2017
    Location
    Sudbury, Ontario
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Filtering Values not showing all data

    Thanks for the responses. I'm at a loss also at this point...
    Hopefully someone can chime in.

+ 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. [SOLVED] Filtering a set of data based on particular values for one column
    By ickleingus in forum Excel General
    Replies: 4
    Last Post: 10-31-2016, 12:20 PM
  2. Replies: 1
    Last Post: 10-03-2016, 04:16 PM
  3. Replies: 2
    Last Post: 04-22-2016, 05:25 PM
  4. [SOLVED] Filtering between Data VALUES
    By Blackhawks in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-07-2014, 04:44 PM
  5. Filtering the table and showing the results in a combobox
    By iverim in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2014, 10:49 AM
  6. Filtering data and totals by column values
    By holmes123 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-05-2013, 04:11 PM
  7. Showing chart as percentage but data table as values
    By Evetsllub in forum Excel General
    Replies: 0
    Last Post: 08-23-2010, 12:08 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