Problem: Sort, Find, and Summarize operations only work on some records in a table
When there are more than 2,000 records in a table, the Sort, Find, and Summarize options only work on the records currently loaded in the Table window
When a nonOID table, such as an OLE DB table or text file, is opened in ArcMap, the first 2000 records are cached locally and appear in the table window when it is first opened. Although subsequent scrolling operations add to this local cache, the whole table must be loaded to support these operations.
Solution or Workaround
Ensure all the records are loaded in the table window by either scrolling down through the table window, or by clicking the Move to end of Table button on the Table window.