PROBLEM
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.
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.
Get help from ArcGIS experts
Download the Esri Support App