0

I have some problems about exporting a SharePoint List to excel. I'm getting "Excel cannot connect to the SharePoint list" error while exporting it to excel. There wasn't any error in the same list before and there is not any error while exporting other lists to excel. There is no additional info, any logs. Any ideas about the problem?

P.S: List has more than 10000 items.

Thanks in advance.

enter image description here

Improve this question
4
  • Is this in SharePoint 2010? I'm thinking it could be a throttling issue.
    – Richard
    Apr 24, 2013 at 14:14
  • Yes, this is SharePoint 2010. Export action were working correctly till last week. But now it causes that error.
    – newbie
    Apr 25, 2013 at 5:04
  • You could try and temporarily disable throttling on the list to see if it helps this link shows how to disable it. Also worth looking at your logs around the time you try the export to see what messages you get.
    – Richard
    Apr 25, 2013 at 14:18
  • Disabling the throttling didnot work for me. I searched logs and I found this exception: Failed to load ... with error: 'Unable to open workbook due to unexpected exception: Microsoft.Office.Excel.Server.Host.HostFileException ---> System.IO.DirectoryNotFoundException But there is a list and I can reach this list over web and SPD2010.
    – newbie
    May 13, 2013 at 12:29

1 Answer 1

Reset to default
0

I faced a similar case when a user in my company's sharepoint (10) could not export a list of a subsite. By similar, i mean that the message shown was "cannot connect to server at the moment. Your data will not be saved."

After checking the user's permissions, the error was unexplained, meaning that a user of the same permission levels could export the list without any problems. Checking the performance on the task manager tab, the laptop was running for about 40 days, so what i did was change the security settings (IE -> Internet Options -> Security Tab) to "no security", at all and then reinstall all previous measures, and it worked like a charm.

Improve this answer
2
  • An interesting scenario :/ Finally I've upgraded to SharePoint 2013 and problem had gone.
    – newbie
    Dec 13, 2018 at 6:08
  • Yes, and not to mention, that the user could export the list if he logged in to the sharepoint from another users PC. Really strange how SP10 handles security...
    – jimas13
    Dec 14, 2018 at 7:45

Your Answer

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

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