Get SharePoint Online (Office 365 Enterprise E3) Subscription for your Business NOW

Enable or Disable List Throttling using PowerShell in SharePoint 2013/2016


This PowerShell SharePoint tutorial explains, how we can enable or disable list throttling using PowerShell in SharePoint 2013/2016 Microsoft has set a default threshold limit of 5000 items to SharePoint list, once you list increased beyond you will get a message like The number of items in this list exceeds the list view threshold.

There are many cases where you want to deal with huge amount of data in SharePoint list, whereas you need to bypass the threshold limit of a particular SharePoint list. So to override the default throttling settings. Just execute the below PowerShell to add list items more than the threshold limits.


To overcome the threshold issue the straight forward solution is to increase the threshold limit for the particular list.

If you are new to PowerShell, read an article on Working with PowerShell in SharePoint Online/2016/2013.

Disable list throttling SharePoint 2013 PowerShell

Below is the PowerShell command to disable the list throttling for a particular list in SharePoint 2013/2016.

Add-PSSnapin Microsoft.SharePoint.PowerShell
$web = Get-SPWeb http://SiteURL/
$web.AllowUnsafeUpdates = $True
$list = $web.Lists[“YourListName”]
$list.EnableThrottling = $false
$list.Update()
$web.AllowUnsafeUpdates = $False
$web.Update()
$web.Dispose()

Enable list throttling SharePoint 2013 PowerShell

Below is the PowerShell command to enable list throttling for a particular list in SharePoint 2013/2016.

Add-PSSnapin Microsoft.SharePoint.PowerShell
$web = Get-SPWeb http://SiteURL/
$web.AllowUnsafeUpdates = $True
$list = $web.Lists[“YourListName”]
$list.EnableThrottling = $true
$list.Update()
$web.AllowUnsafeUpdates = $False
$web.Update()
$web.Dispose()

You may like following PowerShell tutorials:

Hope this will be helpful to enable or disable list throttling in SharePoint 2013 using PowerShell.

Check out Best Alternative to InfoPath -> Try Now

EnjoySharePoint YouTube Channel

You May Also like the Following SharePoint Tutorials:

About Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

View all posts by Bijay Kumar →