Home

Export to Excel feature in Sharepoint 2013 list not working

%3CLINGO-SUB%20id%3D%22lingo-sub-560721%22%20slang%3D%22en-US%22%3EExport%20to%20Excel%20feature%20in%20Sharepoint%202013%20list%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-560721%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20i%20am%20in%20a%20Sharepoint%202013%20list%20with%20data%20and%20click%20Export%20to%20Excel%20in%20the%20top%20ribbon%20then%20i%20get%20the%20following%20message%20in%20a%20popup%20window%3A%20%22To%20export%20a%20list%2C%20you%20must%20have%20a%20Microsoft%20SharePoint%20Foundation-compatible%20application.%22%3CBR%20%2F%3EWhen%20i%20click%20OK%2C%20it%20opens%20a%20new%20page%20in%20the%20browser%20with%20this%20text%3A%3C%2FP%3E%3CPRE%3EWEB%0A1%0Ahttp%3A%2F%2Fxx.yy.com%2Fabc%2Fabcd%2Fabcde%2F_vti_bin%2Fowssvr.dll%3FXMLDATA%3D1%26amp%3BList%3D%7BE8964891-47A3-43E4-9934-E7415AAB8528%7D%26amp%3BView%3D%7BC54310C8-A407-415C-84DC-8045B5D8335B%7D%26amp%3BRowLimit%3D0%26amp%3BRootFolder%3D%252fITPMO%252fProjects%252fissues%252fLists%252fEmerson%2520Process%2520Issue%2520Tracking%0A%0ASelection%3D%7BE8964891-47A3-43E4-9934-E7415AAB8528%7D-%7BC54310C8-A407-415C-84DC-8045B5D8335B%7D%0AEditWebPage%3D%0AFormatting%3DNone%0APreFormattedTextToColumns%3DTrue%0AConsecutiveDelimitersAsOne%3DTrue%0ASingleBlockTextImport%3DFalse%0ADisableDateRecognition%3DFalse%0ADisableRedirections%3DFalse%0ASharePointApplication%3Dhttp%3A%2F%2Fxx.yy.com%2Fabc%2Fabcd%2Fabcde%2F_vti_bin%0ASharePointListView%3D%7BC54310C8-A407-415C-84DC-8045B5D8335B%7D%0ASharePointListName%3D%7BE8964891-47A3-43E4-9934-E7415AAB8528%7D%0ARootFolder%3D%2Fblablabla%3C%2FPRE%3E%3CP%3EThis%20while%20the%20same%20action%20in%20IE11%20opens%20an%20excel%20file%20with%20inside%20a%20data%20connection%20to%20the%20Sharepoint%20list%20that%20can%20be%20refreshed%20at%20any%20time.%3CBR%20%2F%3EI%20also%20found%20this%20post%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FSharePoint%2FSharePoint-Modern-List-Export-to-Excel-Not-Available-in-Chrome%2Fm-p%2F45772%23M4368%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FSharePoint%2FSharePoint-Modern-List-Export-to-Excel-Not-Available-in-Chrome%2Fm-p%2F45772%23M4368%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPeople%20say%20it%20is%20because%20Export%20to%20Excel%20is%20based%20on%20an%20ActiveX%20control%20not%20supported%20in%20Chrome%20and%20therefore%20not%20inside%20the%20new%20Edge%20Dev%20as%20well%3F%3F%3F%20That%20would%20make%20Sharepoint%20users%20not%20happy.%3CBR%20%2F%3EOr%20is%20there%20something%20i%20need%20to%20change%20in%20Settings%20to%20make%20it%20possible%20to%20continue%20using%20the%20%3CSTRONG%3EExport%20to%20Excel%3C%2FSTRONG%3E%20feature%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-746533%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20to%20Excel%20feature%20in%20Sharepoint%202013%20list%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-746533%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F340561%22%20target%3D%22_blank%22%3E%40Brownie71%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20is%20a%20great%20feature%20suggestion%20that%20may%20be%20added%20in%20the%20future.%26nbsp%3B%20Or%20it%20is%20possible%20it%20is%20available%20now.%26nbsp%3B%20Please%20let%20me%20know%20if%20you%20are%20still%20having%20this%20issue%20after%20installing%20any%20possible%20missing%20updates.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGabriel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-768447%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20to%20Excel%20feature%20in%20Sharepoint%202013%20list%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-768447%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F299596%22%20target%3D%22_blank%22%3E%40v-gapart%3C%2FA%3E%26nbsp%3BI%20am%20on%20SP2016%20and%20experiencing%20the%20same%20issue.%20I%20am%20currently%20using%26nbsp%3B%3CSPAN%3EVersion%2077.0.218.4%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-768460%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20to%20Excel%20feature%20in%20Sharepoint%202013%20list%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-768460%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F340561%22%20target%3D%22_blank%22%3E%40Brownie71%3C%2FA%3E%26nbsp%3BThis%20has%20been%20true%20of%20Chrome%20since%20forever%20-%20one%20of%20the%20reasons%20we%20have%20to%20keep%20IE11%20around.%20Hopefully%20the%20new%20IE%20support%20in%20Chromium%20Edge%20will%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20a%20graceful%20workaround%2C%20not%20a%20solution%2C%20and%20definitely%20a%20pain%2C%20but%20if%20you%20hit%20this%20when%20using%20Chrome%20and%20don't%20have%20IE11%20around%2C%20right%20click%20on%20that%20page%20and%20'save%20as'%20without%20renaming.%20When%20the%20file%20is%20done%20downloading%20(it's%20an%20.iqy%20file)%2C%20click%20on%20it%20to%20open%20it%20and%20it%20will%20open%20in%20Excel%20and%20work%20fine%20-%20you%20can%20save%20the%20Excel%20and%20the%20query%20will%20stay%20intact.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773791%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20to%20Excel%20feature%20in%20Sharepoint%202013%20list%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773791%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F340561%22%20target%3D%22_blank%22%3E%40Brownie71%3C%2FA%3E%26nbsp%3BI%20have%20noticed%20that%20all%20of%20the%20limitations%20of%20Chrome%20in%20Sharepoint%20are%20present%20in%20Edge%20Dev.%20The%20only%20workaround%20I've%20found%20is%20to%20use%20the%20IETab%20Chrome%20extension%20available%20in%20the%20Chrome%20web%20store%2C%20which%20allows%20some%20of%20the%20features%20unavailable%20for%20Chrome%20users%20in%20Sharepoint%20sites%20such%20as%20opening%20links%20from%20a%20link%20library%2C%20opening%20files%20in%20a%20file%20library%2C%20converting%20lists%20to%20Excel%2C%20etc.%20The%20only%20one%20I've%20found%20so%20far%20that%20doesn't%20work%20is%20the%20Form%20Field%20edit%20feature%2C%20when%20clicked%20it%20says%20you%20must%20use%20Internet%20Explorer.%20IETab%20is%20a%20third-party%20extension%20so%20it%20would%20be%20terrific%20if%20the%20Microsoft%20developers%20working%20on%20chromium-based%20Edge%20Dev%20could%20add%20features%20to%20allow%20the%20new%20Edge%20to%20work%20with%20MS%20Sharepoint.%20At%20the%20moment%2C%20the%20same%20limitations%20apply%20to%20Edge%20Dev%20users%20as%20Chrome%20users.%20and%20only%20the%20IETab%20extension%20seems%20to%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773808%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20to%20Excel%20feature%20in%20Sharepoint%202013%20list%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773808%22%20slang%3D%22en-US%22%3EGood%20to%20know%2C%20thanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773977%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20to%20Excel%20feature%20in%20Sharepoint%202013%20list%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773977%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382213%22%20target%3D%22_blank%22%3E%40C_Benson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20is%20likely%20to%20be%20implemented%20with%20the%20Internet%20Explorer%20Mode%20once%20that%20is%20fully%20added%20as%20a%20feature.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGabriel%3C%2FP%3E%3C%2FLINGO-BODY%3E
Brownie71
New Contributor

When i am in a Sharepoint 2013 list with data and click Export to Excel in the top ribbon then i get the following message in a popup window: "To export a list, you must have a Microsoft SharePoint Foundation-compatible application."
When i click OK, it opens a new page in the browser with this text:

WEB
1
http://xx.yy.com/abc/abcd/abcde/_vti_bin/owssvr.dll?XMLDATA=1&List={E8964891-47A3-43E4-9934-E7415AAB8528}&View={C54310C8-A407-415C-84DC-8045B5D8335B}&RowLimit=0&RootFolder=%2fITPMO%2fProjects%2fissues%2fLists%2fEmerson%20Process%20Issue%20Tracking

Selection={E8964891-47A3-43E4-9934-E7415AAB8528}-{C54310C8-A407-415C-84DC-8045B5D8335B}
EditWebPage=
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False
SharePointApplication=http://xx.yy.com/abc/abcd/abcde/_vti_bin
SharePointListView={C54310C8-A407-415C-84DC-8045B5D8335B}
SharePointListName={E8964891-47A3-43E4-9934-E7415AAB8528}
RootFolder=/blablabla

This while the same action in IE11 opens an excel file with inside a data connection to the Sharepoint list that can be refreshed at any time.
I also found this post:
https://techcommunity.microsoft.com/t5/SharePoint/SharePoint-Modern-List-Export-to-Excel-Not-Availab...

 

People say it is because Export to Excel is based on an ActiveX control not supported in Chrome and therefore not inside the new Edge Dev as well??? That would make Sharepoint users not happy.
Or is there something i need to change in Settings to make it possible to continue using the Export to Excel feature?

6 Replies

@Brownie71 

 

This is a great feature suggestion that may be added in the future.  Or it is possible it is available now.  Please let me know if you are still having this issue after installing any possible missing updates.

 

Gabriel

Highlighted

@v-gapart I am on SP2016 and experiencing the same issue. I am currently using Version 77.0.218.4 

@Brownie71 This has been true of Chrome since forever - one of the reasons we have to keep IE11 around. Hopefully the new IE support in Chromium Edge will help.

 

Not a graceful workaround, not a solution, and definitely a pain, but if you hit this when using Chrome and don't have IE11 around, right click on that page and 'save as' without renaming. When the file is done downloading (it's an .iqy file), click on it to open it and it will open in Excel and work fine - you can save the Excel and the query will stay intact.

@Brownie71 I have noticed that all of the limitations of Chrome in Sharepoint are present in Edge Dev. The only workaround I've found is to use the IETab Chrome extension available in the Chrome web store, which allows some of the features unavailable for Chrome users in Sharepoint sites such as opening links from a link library, opening files in a file library, converting lists to Excel, etc. The only one I've found so far that doesn't work is the Form Field edit feature, when clicked it says you must use Internet Explorer. IETab is a third-party extension so it would be terrific if the Microsoft developers working on chromium-based Edge Dev could add features to allow the new Edge to work with MS Sharepoint. At the moment, the same limitations apply to Edge Dev users as Chrome users. and only the IETab extension seems to help.

Good to know, thanks

@C_Benson 

 

This is likely to be implemented with the Internet Explorer Mode once that is fully added as a feature.

 

Gabriel

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies