Export to Excel - An Unexpected Error Has Occurred.

%3CLINGO-SUB%20id%3D%22lingo-sub-699620%22%20slang%3D%22en-US%22%3EExport%20to%20Excel%20-%20An%20Unexpected%20Error%20Has%20Occurred.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-699620%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20about%20the%20last%20week%20or%20so%20our%20users%20have%20been%20reporting%20issues%20exporting%20list%20content%20to%20excel.%26nbsp%3B%20This%20is%20happening%20on%20different%20lists%20on%20different%20sites.%3C%2FP%3E%3CP%3EWe%20have%20found%20that%20once%20they%20get%20the%20'An%20unexpected%20error%20has%20occurred'%20message%20if%20they%20switch%20to%20a%20different%20view%20then%20return%20to%20the%20original%20view%20they%20can%20export%20without%20error.%2C%20but%20needless%20to%20say%20folks%20aren't%20happy%20with%20that%20workaround.%3C%2FP%3E%3CP%3EAnyone%20else%20experiencing%20this%20or%20aware%20of%20anything%20going%20on%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3CP%3EBob%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-699620%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-701420%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20to%20Excel%20-%20An%20Unexpected%20Error%20Has%20Occurred.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-701420%22%20slang%3D%22en-US%22%3EExport%20to%20Excel%20is%20a%20basic%20feature%20in%20lists%20and%20document%20libraries%20that%20should%20work%20with%20no%20problems...can%20you%20provide%20more%20details%20about%20the%20browser%20your%20users%20are%20using%20and%20also%20the%20list%20required%20to%20be%20exported%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-701781%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20to%20Excel%20-%20An%20Unexpected%20Error%20Has%20Occurred.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-701781%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20replying.%26nbsp%3B%20We%20have%20several%20different%20sites%20with%20custom%20lists%2C%20and%20this%20has%20been%20reported%20frequently%20over%20the%20last%20week%20or%20so.%26nbsp%3B%20The%20one%20we%20are%20getting%20the%20most%20calls%20on%20has%20around%2030%20columns%2C%20no%20special%20characters%20in%20the%20columns%20and%20nothing%20out%20of%20the%20ordinary%20in%20the%20content%2C%20and%20the%20list%20has%20about%20475%20items.%26nbsp%3B%20We%20are%20experiencing%20this%20using%20both%20IE%2011%20and%2075.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUser%20clicks%20Export%20to%20Excel%2C%20gets%20prompted%20to%20open%20or%20save%20the%20query.iqy%20file%2C%20clicks%20Open%20and%20gets%20the%20security%20prompt%20to%20enable%20data%20connections%2C%20clicks%20Enable%20then%20gets%20the%20Unexpected%20error.%26nbsp%3B%20At%20this%20point%20we%20can%20click%20OK%2C%20then%20open%20a%20different%20view%20in%20the%20list%20then%20either%20toggle%20back%20to%20the%20original%20or%20stay%20there%20and%20click%20Export%20to%20Excel%20again%2C%20and%20we%20repeat%20the%20above%2C%20but%20this%20time%20the%20export%20opens.%26nbsp%3B%20If%20we%20close%2Freopen%20the%20browser%20it%20once%20again%20fails%20to%20open%20on%20the%20initial%20attempt.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20these%20details%20help%2C%20please%20let%20me%20know%20if%20more%20info%20is%20needed.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-805464%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20to%20Excel%20-%20An%20Unexpected%20Error%20Has%20Occurred.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-805464%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F249001%22%20target%3D%22_blank%22%3E%40BobAtkinson%3C%2FA%3E%26nbsp%3BDo%20you%20know%20if%20there%20has%20been%20any%20update%20on%20this%3F%26nbsp%3B%20I%20have%20a%20user%20getting%20that%20error%20as%20well.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-806299%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20to%20Excel%20-%20An%20Unexpected%20Error%20Has%20Occurred.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-806299%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F392484%22%20target%3D%22_blank%22%3E%40MauriceV%3C%2FA%3E%20I%20am%20not%20aware%20of%20any%20updates%20on%20this.%20What%20I%20have%20noticed%20though%20is%20that%20this%20happens%20to%20our%20users%20when%20they%20access%20the%20list%20from%20the%20left%20hand%20navigation%20links%20on%20pages%20that%20are%20not%20in%20modern%20format.%20If%20they%20access%20the%20list%20directly%20through%20it's%20url%20or%20site%20contents%20or%20from%20a%20page%20in%20modern%20format%20the%20export%20works.%20I%20rebuilt%20the%20pages%20as%20modern%20to%20get%20around%20this.%20In%20addition%20to%20the%20export%2C%20we%20were%20also%20noticing%20issues%20trying%20to%20filter%20on%20columns%2C%20the%20page%20would%20just%20hang%20and%20the%20values%20wouldn't%20load.%20This%20also%20seems%20tied%20to%20the%20links%20from%20non-modern%20pages%2C%20and%20recreating%20pages%20fixed%20that%20as%20well.%20I%20don't%20know%20if%20all%20of%20this%20is%20just%20coincidence%20or%20if%20there%20is%20some%20other%20root%20cause%20in%20our%20environment.%20Let%20me%20know%20if%20this%20helps%20you%20out.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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 unexpected error has occurred' message if they switch to a different view then return to the original view they can export without error., but needless to say folks aren't happy with that workaround.

Anyone else experiencing this or aware of anything going on?

 

Thanks in advance

Bob

4 Replies
Highlighted
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?
Highlighted

@Juan Carlos González Martín 

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.

Highlighted

@BobAtkinson Do you know if there has been any update on this?  I have a user getting that error as well.

Highlighted
@MauriceV I am not aware of any updates on this. What I have noticed though is that this happens to our users when they access the list from the left hand navigation links on pages that are not in modern format. If they access the list directly through it's url or site contents or from a page in modern format the export works. I rebuilt the pages as modern to get around this. In addition to the export, we were also noticing issues trying to filter on columns, the page would just hang and the values wouldn't load. This also seems tied to the links from non-modern pages, and recreating pages fixed that as well. I don't know if all of this is just coincidence or if there is some other root cause in our environment. Let me know if this helps you out.