Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

share|improve this question
    
Is this in SharePoint 2010? I'm thinking it could be a throttling issue. –  Richard Apr 24 '13 at 14:14
    
Yes, this is SharePoint 2010. Export action were working correctly till last week. But now it causes that error. –  compengTR Apr 25 '13 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 '13 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. –  compengTR May 13 '13 at 12:29
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.