I have a SharePoint list with 13879 items, so when I am trying to export the list to Excel, data doesn't export.

It is blank sheet and looks like this. (where column1, column2... are SharePoint list column names).

enter image description here

Also list view threshold is increased to 15000. Here is an image of list settings showing list view threshold:

enter image description here

  • 2
    Are you sure that Excel connects with the same credentials you use when browsing your list? Excel will try to use credentials from IE (regardless of your default or preferred browser). If IE is not authentified to your SharePoint site, then it will prompt for authentication. Jan 16 '19 at 13:35
  • oh, thank you it was because of credentials difference Jan 16 '19 at 13:50
  • but now it exports part of list data, not whole data :( Jan 16 '19 at 13:54
  • You should probably edit your question or even better ask a new one. How much data is exported? do you see any pattern differentiating the rows exported from the ones that are not exported? Jan 16 '19 at 13:58
  • 2
    Problem is because the data import into Excel will Time-Out. Jan 16 '19 at 14:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.