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.
Registry Hive | HKEY_CURRENT_USER |
Registry Path | software\policies\microsoft\office\16.0\list\settings |
Value Name | rowlimitforlookups |
Value Type | REG_DWORD |
Value | 0 |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | software\policies\microsoft\office\16.0\list\settings |
Value Name | rowlimitforlookups |
Value Type | REG_DWORD |
Value | 1 |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | software\policies\microsoft\office\16.0\list\settings |
Value Name | rowlimitforlookups |
Value Type | REG_DWORD |
Value | 100 |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | software\policies\microsoft\office\16.0\list\settings |
Value Name | rowlimitforlookups |
Value Type | REG_DWORD |
Value | 450 |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | software\policies\microsoft\office\16.0\list\settings |
Value Name | rowlimitforlookups |
Value Type | REG_DWORD |
Value | 5000 |