Current Position:Home > How to export more than 5000 SharePoint items to excel?

How to export more than 5000 SharePoint items to excel?

Update:11-30Source: network consolidation
Advertisement
Need a solution on how to export more than 5000 share point items to excel file.

The Best Answer

Advertisement
Hello Chitra,
Option
suggested by soni is valid you can increase threshold limit through CA as well
as you can disable list threshold using PowerShell.
$web =Get-SPWeb
"URL"
$list =$web.Lists[“BIG_LIST_NAME”]
$list.EnableThrottling= $false
But disabling threshold cause performance issue, so as per best practices manage threshold limit according to your requirements
from CA.