PROBLEM

Sort, Find, and Summarize operations only work on some records in a table

Last Published: April 25, 2020

Description

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

Cause

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.

Article ID:000002760

Software:
  • ArcMap

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic