13 September, 2013

To export a list, you must have a Microsoft SharePoint Foundation-compatible application - SharePoint 2010 + SharePoint 2013

The export to Excel button is available but when I select the following error appears:
 
Error message: To export a list, you must have a Microsoft SharePoint Foundation-compatible application

 
Let me tell you guys that this section is very widespread and can be happen because of so many reasons. I don’t want to restrict this thread with only one solution as while debugging on this issue, I have explored so many options and would like to share all the options with you so that you can take a benefit of this and issue can be resolved in easy as well as proficient manner.

I am going to elaborate this information in step by step manner so in case of any queries/questions regarding any step then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Multiple Resolutions:
1)   Make sure the Office client should be installed on the machine.

2)   Make sure the web client service in started mode, How to check this: On your machine- Start-Run-services.msc-start the webclient service.

3)   Make sure the IE (Internet Explorer) Version should be 32-bit and not a 64-bit. How to check this: http://www.tracker-software.com/knowledgebase/280-How-do-I-tell-if-I-am-using-a-32-bit-or-64-bit-version-of-IE    

4)   Make sure the client integration is Enabled in Central Administration
How to check this: Central Administration-Manage web applications-Ribbon-Authentication Providers-Client Integration check box.

5)   Make sure the STSSYNC add-on should be enabled in IE. How to check this: Open IE-Tools-Manage Add-Ons-Look for the STSSYNC add-on and enable it.

6)   Make sure this option “Enable additional actions and Online Status for members” in Central Administration is set to Yes. How to check this: Open the Central Administration page-Click on Manage web applications-Select the web application you would like to configure-From the ribbon select General Settings-In the section titled Person Name Actions and Presence Settings change the setting Enable additional actions and Online Status for members to Yes-Click OK to apply changes.

7)   Make sure the ActiveX Control is enabled in Internet Explorer. How to check this- Open IE-Tools-Manage Add-Ons-Look for the STSUpld UploadCtl Class add-on and enable it.

8)   Make sure the Internet Explorer settings should not be too high. How to check this: http://windows.microsoft.com/en-in/windows-vista/change-internet-explorer-security-settings

9)   Make sure the protected mode should not be enabled in Internet Explorer. How to check this: Open internet explorer- Click on Tools menu and select Internet Options- Select Security Tab in the Internet options windows- Select Internet from the zone settings- Uncheck Enable Protected Mode option to disable the protection from Security for this zone- Hit Apply and Ok.

10)               Make sure the SharePoint site should be added inside trusted sites zone. How to do this: http://sharepointknowledgebase.blogspot.in/2010/07/site-prompts-for-credentials.html

Thank you once again!

I would like to request you if you have any different resolution apart from the above mentioned then please share here so that it would be beneficial for others as well.

Happy SharePoint to all of U...

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

7 comments:

  1. Thanks for the post. But unfortunately, none of these solved our issue. It makes me wonder why is it so difficult for Microsoft to create a system that is 100% compatible with their products! We are using Windows 7 32bit, IE 9 32bit, Office 2010 32 bit, and yet their Sharepoint system can not function properly with Excel!

    ReplyDelete
  2. http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

    2007 Office System Driver: Data Connectivity Components

    Use This Link and download the Software it Work's Fine..

    ReplyDelete
  3. Link:http://www.microsoft.com/en-us/download/confirmation.aspx?id=13255

    For 2010

    ReplyDelete
  4. Thanks so much.
    Point 4) helped me
    Make sure the client integration is Enabled in Central Administration
    How to check this: Central Administration-Manage web applications-Ribbon-Authentication Providers-Client Integration check box.
    - See more at: http://sharepointknowledgebase.blogspot.com/2013/09/to-export-list-you-must-have-microsoft.html#.VH9LozHF_y0

    ReplyDelete

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge