I have a large SharePoint 2010 list (~60,000 items) in which the list view threshold has been turned off. Recently, we've encountered the problem that exporting the list to Excel only yields a subset of the total number of items. Sometimes, refreshing the data connection will return 4,000 records to Excel. Sometimes it will return 20,000, etc. There doesn't appear to be any consistency in this, so my assumption is there there is some sort of network interruption happening.

Can anyone suggest some troubleshooting methods for this problem? I'm stuck.

1 Answer 1


For test purpose, can you please try exporting using the below script, which creates a csv file with the values in SharePoint List.

$MyWeb = Get-SPWeb "http://sitename"
$MyWeb.Lists["ListName"].Items |
          New-Object PSObject -Property @{
                                          Column1=$_["Column Name in SharePoint"]
                                          Column2=$_["Column Name in SharePoint"]                  
     } | Export-Csv -path 'C:\FilePath\Filename.csv'


  • Hi, Karthik. Provided that this script retrieves all of the data, I don't see how it would be relevant since it needs to run on the server whereas exporting to Excel is client-side.
    – bgw
    Dec 16, 2013 at 15:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.