I am having when Exporting large lists to excel (over 14K records). It displays “Running security Scan” at the bottom of the screen and then gives “An unexpected error has occurred. Changes to your data cannot be saved” in Excel (data does not load).
I am using IE 9 and MCAffee AV on the client side.
Sharepoint Version is 2010 Foundation
Not sure whether the issue is related to the AV however. Could it be some timeout setting that I need to modify? Maybe a setting in Sharepoint?
Thanks!
4 Answers
Here is a trick I've tried in your situation:
- Change your view in SharePoint to only display like Maximum 1000 rows. (use the Limit in the bottom of the view definition screen)
- Attempt again to export to Excel - this should work without issues (if it doesn't the problem lies elsewhere in your SharePoint and then you should have a look in ULS)
- Change back the View to show all items or those you need.
- Use the Refresh All in Excel to get latest updates from your View
-
Thanks - it is a good workaround (but not really a solution) +1 Aug 21, 2012 at 9:32
-
1It might actually not exist a proper solution for that amount of data. I've search for alternatives myself at the time, besides you only need to do the trick once per list, then Excel would be able to work properly. You cannot rely on Excel services neither as you have SPF. Aug 21, 2012 at 10:48
-
Thanks for your reply. Yes, it could do since it only needs to be done once. I will do some other research myself and let you know the outcome. Aug 21, 2012 at 11:01
-
Had the same problem with two user fields containing texts. Export works fine without them.
And the Solution was to add additional Filter to the View! The Filter is on Date Created Field (in my case) > xx and it's set so that all the data that we were displaying before is also shown, the additional Filter does not return any less Results, so the amount of data is the same, but this fixed the issue and the two user fields can normally be in the View. Weird... I guess the problem is in the query, and with an additional Filter we can limit the query a bit more?
Try it out, should work..
It turned out to be related to user fields and not to the size of the data. I removed 2 user fields and added 7 other fields (to confirm that it is not related to the size of the data). & it worked. Somehow excel seems to have problems with exporting a large amount of user fields.
Thanks everyone for your useful support.
You just have to extend the duration of the Excel export or request timeout by doing the following:
Log in to Central Admin as a Farm Administrator
Click
Application Management
in the left nav.Click
Manage service applications
under Service Applications.Click
Excel Services Application
next toExcel Services Application Web Service Application
Note: not the item in grey under this.. You want the blue item.Click the
Trusted File Locations
link and then select the reports library or document library your web part is calling or where the files are.Scroll down to
Session Management
and increase the value ofMaximum Request Duration
.Scroll down to
Workbook Properties
and increase the value ofMaximum Workbook Size
.
This shall do it