none
SharePoint Exporting Lists RRS feed

  • Question

  • Hi,

    Can anyone help?

    When I try to export a list I get the following error below. I am not running different versions of word which a lot of users suggest is the issue. Is there anything on the server I could check? I also get the same message when I try to connect to a site via SharePoint Designer.

    Any help would be much appreciated. 


     

    Tuesday, December 5, 2017 4:14 PM

Answers

  • Hi,

    Please ensure you are using 32-bit versions of Internet Explorer.
    If you are using windows 7 64 bit, you will get both 32 bit and 64 bit version of Internet Explorer installed on your computer. Navigate to C:\Program Files (x86)\Internet Explorer\iexplore.exe to use Internet Explorer 32 bit.
    After that, add this site to the Compatibility View and Trusted sites in Internet Explorer, check if it works.

    If it doesn’t work, please make sure the Web Client service is started.

    Feel free to reply if there is any update.

    Best Regards,
    Carl Zhou

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    • Marked as answer by Kier4n Tuesday, December 12, 2017 2:15 PM
    Thursday, December 7, 2017 9:24 AM
  • Hi

    Please use the Internet Explorer instead of Chrome. Because opening the SharePoint list in Excel, Or Datasheet View and InfoPath relies on the ActiveX control. Chrome doesn't know how to respond to ActiveX.


    Murugesa Pandian MCSA,MCSE,MCPD
    Please remember to mark the replies as answers or helpful if they really helped and saved your time.

    • Marked as answer by Kier4n Tuesday, December 12, 2017 2:15 PM
    Thursday, December 7, 2017 10:14 AM

All replies

  • Hi,

    There are various dependencies on office Excel issue.

    If this is happening only for one particular list or library then it is issue with connection or permission second if you can check from other machine / client then this problem happening only on the machine with 64bit Of Office Product installed, If you're seeing this on all lists, then i recommend running a repair on MS Office. 

    Here there are various things you can check and apply First of all despite the error message the export actually works! Notice the yellow bar at the bottom of your browser. Simply save the .iqy file normally and open it with Excel. It’s that simple. The error message is certainly a nuisance but does not actually stop the export.

    One option to try: If you only have one version of Office installed on your computer, then install the Microsoft SharePoint Foundation Support. You can simply go to the Control Panel, select your Office installation, click Change and then repair your existing installation. On the Installation Options screen, enable Microsoft SharePoint Foundation Support from the list of Office programs. For more information check out Microsoft’s blog post on this topic

    You may have installed Office 2016 but SharePoint Designer 2013. Because SharePoint Designer is really an Office component, you are running multiple versions of Office. Multiple versions of Office cause a lot of errors and perhaps it will be a good topic for a future article. The solution is to make sure you are running only one version of Office. In some cases, you may have to completely remove the multiple versions, reboot the computer and then install only one version, even here if you have Since you have had multiple versions of office installed, there are multiple folders installed for it and SharePoint doesn't see anything in the 2010 folder on the client machine - because it was moved to the 2013 folder.  There is a fix outlined here for machines that don't have SharePoint Designer, OneNote or InfoPath installed, but otherwise does not work, to fix this you can modify the registry.

    • Click on the start menu, type regedit and then click OK.
    • Under Computer, HKEY_CLASSES_ROOT, find the SharePoint.OpenDocuments.5 key and right click.  Choose Rename.  Name it SharePoint.OpenDocuments.5.old and click ok.
    • The key will be re-added any time you repair/update the Office 2013 program and will have to be renamed/deleted again

    Check if are using 32-bit version of Internet Explorer and enable compatibility view, here If you are using windows 7 64 bit, then you will get both 32 bit and 64 bit version of Internet Explorer installed on your computer. Navigate to C:\Program Files (x86)\Internet Explorer\iexplore.exe to use Internet Explorer 32 bit.Check the Web Client service and have it started, restart it and see.

    You need to install the Micrsoft Access Database Engine"( Download here) driver on your machine, where you are trying to export to excel or DataSheetview.

    This problem happening only on the machine with 64bit Of Office Product installed, If you're seeing this on all lists, then i recommend running a repair on MS Office. 

    Please check this blog as well, having some of the other things you can test.

    http://sharepointknowledgebase.blogspot.com/2013/09/to-export-list-you-must-have-microsoft.html#.WibV3lWnGpo


    KRISHANA KUMAR

    SharePoint Architect

    Mosstechnet-kk.com

     

    Please click "Mark As Answer" if this post solves your problem or "Vote As Helpful" if it was useful

    Tuesday, December 5, 2017 5:39 PM
  • Hi,

    Please ensure you are using 32-bit versions of Internet Explorer.
    If you are using windows 7 64 bit, you will get both 32 bit and 64 bit version of Internet Explorer installed on your computer. Navigate to C:\Program Files (x86)\Internet Explorer\iexplore.exe to use Internet Explorer 32 bit.
    After that, add this site to the Compatibility View and Trusted sites in Internet Explorer, check if it works.

    If it doesn’t work, please make sure the Web Client service is started.

    Feel free to reply if there is any update.

    Best Regards,
    Carl Zhou

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    • Marked as answer by Kier4n Tuesday, December 12, 2017 2:15 PM
    Thursday, December 7, 2017 9:24 AM
  • Narocroc,

    Try these options,

    https://learningintheopen.org/2017/08/14/toexportalistyoumusthaveamicrosoftsharepointfoundationcompatibleapplication/

    https://www.acumenitsupport.com/blog/sharepoint/to-export-a-list-you-must-have-a-microsoft-sharepoint-foundation-compatible-application/

    Thanks

    Thursday, December 7, 2017 9:52 AM
  • Hi

    Please use the Internet Explorer instead of Chrome. Because opening the SharePoint list in Excel, Or Datasheet View and InfoPath relies on the ActiveX control. Chrome doesn't know how to respond to ActiveX.


    Murugesa Pandian MCSA,MCSE,MCPD
    Please remember to mark the replies as answers or helpful if they really helped and saved your time.

    • Marked as answer by Kier4n Tuesday, December 12, 2017 2:15 PM
    Thursday, December 7, 2017 10:14 AM