Enable or Disable List Throttling using PowerShell in SharePoint 2013

InfoPath alternatives for form designing SharePoint

In this post we will discuss how we can enable or disable list throttling using PowerShell in SharePoint 2013. Microsoft has set a default threshold limit of 5000 items to SharePoint list, once you list increased beyond you will get message like: The number of items in this list exceeds the list view threshold. Check out an article on Working with large lists in sharepoint 2013 list throttling.

Also read:
– How to Set up your SharePoint 2013 Online Management Shell to connect to SharePoint online sites?

– Install workflow manager sharepoint 2013 step by step

– SharePoint 2013 SPListItem method Update SystemUpdate and UpdateOverwriteVersion

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

Disable List Throttling:
Below is the PowerShell command to disable the list throttling for a particular list.

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

Enable List Throttling:
Below is the PowerShell command to enable list throttling for a particular list.

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

Hope this will be helpful.

Similar SharePoint 2013 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 →

Leave a Reply