2

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 4

4

Here is a trick I've tried in your situation:

  1. Change your view in SharePoint to only display like Maximum 1000 rows. (use the Limit in the bottom of the view definition screen)
  2. 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)
  3. Change back the View to show all items or those you need.
  4. Use the Refresh All in Excel to get latest updates from your View
4
  • Thanks - it is a good workaround (but not really a solution) +1 Aug 21, 2012 at 9:32
  • 1
    It 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
  • Tried this approach but excel still gave the same error Aug 21, 2012 at 12:28
3

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..

1

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.

0

You just have to extend the duration of the Excel export or request timeout by doing the following:

  1. Log in to Central Admin as a Farm Administrator

  2. Click Application Management in the left nav.

  3. Click Manage service applications under Service Applications.

  4. Click Excel Services Application next to Excel Services Application Web Service Application Note: not the item in grey under this.. You want the blue item.

  5. 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.

  6. Scroll down to Session Management and increase the value of Maximum Request Duration.

  7. Scroll down to Workbook Properties and increase the value of Maximum Workbook Size.

This shall do it

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.