Maximum number of rows fetched per request while populating a lookup in the SharePoint list control

The maximum number of rows fetched per request while populating a lookup in the SharePoint list control. Based on a standalone server's recommended hardware configuration a good default would be about 5000. The limit helps improve the performance of the SharePoint list control and is a defense in depth measure to prevent loading the server.

Supported on: At least Windows 7




  1. Default
    Registry HiveHKEY_CURRENT_USER
    Registry Pathsoftware\policies\microsoft\office\16.0\list\settings
    Value Namerowlimitforlookups
    Value TypeREG_DWORD
    Value0
  2. 1
    Registry HiveHKEY_CURRENT_USER
    Registry Pathsoftware\policies\microsoft\office\16.0\list\settings
    Value Namerowlimitforlookups
    Value TypeREG_DWORD
    Value1
  3. 100
    Registry HiveHKEY_CURRENT_USER
    Registry Pathsoftware\policies\microsoft\office\16.0\list\settings
    Value Namerowlimitforlookups
    Value TypeREG_DWORD
    Value100
  4. 450
    Registry HiveHKEY_CURRENT_USER
    Registry Pathsoftware\policies\microsoft\office\16.0\list\settings
    Value Namerowlimitforlookups
    Value TypeREG_DWORD
    Value450
  5. 5000
    Registry HiveHKEY_CURRENT_USER
    Registry Pathsoftware\policies\microsoft\office\16.0\list\settings
    Value Namerowlimitforlookups
    Value TypeREG_DWORD
    Value5000


office16.admx

Administrative Templates (Computers)

Administrative Templates (Users)