Forum Discussion

BobAtkinson's avatar
BobAtkinson
Copper Contributor
Jun 18, 2019

Export to Excel - An Unexpected Error Has Occurred.

For about the last week or so our users have been reporting issues exporting list content to excel.  This is happening on different lists on different sites. We have found that once they get the 'An...
SharePoint Online
jcgonzalezmartin's avatar
jcgonzalezmartin
MVP
Jun 18, 2019
Export to Excel is a basic feature in lists and document libraries that should work with no problems...can you provide more details about the browser your users are using and also the list required to be exported?
  • BobAtkinson's avatar
    BobAtkinson
    Copper Contributor
    Jun 18, 2019

    jcgonzalezmartin 

    Thanks for replying.  We have several different sites with custom lists, and this has been reported frequently over the last week or so.  The one we are getting the most calls on has around 30 columns, no special characters in the columns and nothing out of the ordinary in the content, and the list has about 475 items.  We are experiencing this using both IE 11 and 75.

     

    User clicks Export to Excel, gets prompted to open or save the query.iqy file, clicks Open and gets the security prompt to enable data connections, clicks Enable then gets the Unexpected error.  At this point we can click OK, then open a different view in the list then either toggle back to the original or stay there and click Export to Excel again, and we repeat the above, but this time the export opens.  If we close/reopen the browser it once again fails to open on the initial attempt.

     

    Hope these details help, please let me know if more info is needed.

Resources