0

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. – Antoine Driard Jan 16 at 13:35
  • oh, thank you it was because of credentials difference – Vaso Miruashvili Jan 16 at 13:50
  • but now it exports part of list data, not whole data :( – Vaso Miruashvili Jan 16 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? – Antoine Driard Jan 16 at 13:58
  • 2
    Problem is because the data import into Excel will Time-Out. – Zdeněk Vinduška Jan 16 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.