Results 1 to 7 of 7

Filtering Values not showing all data

Threaded View

  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

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