Maximum number of rows fetched per request while populating a lookup in the SharePoint list control
Explanation
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
HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\list\settings- Value name
- not defined in the ADMX
Enable / disable values: not defined in the ADMX (see the options below).
PowerShell
PowerShell commands that write to the registry what the policy would write. Values in angle brackets (<…>) must be replaced.
Writing directly to the registry bypasses Group Policy: if a GPO manages this value, it will be rewritten at the next gpupdate; otherwise the value stays in place (the "tattooing" effect). Prefer a GPO or, locally, LGPO.exe. Run PowerShell as administrator for HKLM. Some policies need a restart or gpupdate /force.
Enable
# Enable: office16/L_MaximumNumberOfRows
$k = 'HKCU:\software\policies\microsoft\office\16.0\list\settings'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
#
# Possible options:
# Default = 0
# 1 = 1
# 100 = 100
# 450 = 450
# 5000 = 5000
Set-ItemProperty -Path $k -Name 'rowlimitforlookups' -Value 0 -Type DWordDisable
# Disable: office16/L_MaximumNumberOfRows
# No value is written in the "Disabled" state (nothing defined in the ADMX)Revert to "Not configured"
# Revert to "Not configured": office16/L_MaximumNumberOfRows
$k = 'HKCU:\software\policies\microsoft\office\16.0\list\settings'
Remove-ItemProperty -Path $k -Name 'rowlimitforlookups' -ErrorAction SilentlyContinueOptions (1)
| Label | Control | Registry value | REG type | Constraints / details | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| L_empty433 | Drop-down listenum | rowlimitforlookups | REG_DWORD | Default choice (UI): #0
|
Application
Microsoft 365 Apps / Office (Microsoft) — November 2026 templates
Official templates downloaded on November 12, 2026.