Forum Discussion

Aurel Murariu's avatar
Aurel Murariu
Copper Contributor
Feb 07, 2018

Export to Excel

Hello everybody,

 

We currently have the following situation:

 - Sharepoint Online with Office 365 Pro 

When ever a user tries to use the "Export to Excel function" an error pops up: 

"To export a list, you must have Microsoft Sharepoint Foundation-compatible application"

I know this was an issue in Sharepoint 2010, but it's 2018. What is the solution?

 

Best regards.

21 Replies

  • What happens when you click OK on this dialog? It should start downloading the file.

    • Aurel Murariu's avatar
      Aurel Murariu
      Copper Contributor

      Despite the error message, you still get this *.iqy file which you can then open with Excel, and use Save As function to save it in excel format. But this a workaround, it works for us, IT people. This is not a good workaround for end users. And defiantly not a solution, for a pay'd software.

      • Pablo R. Ortiz's avatar
        Pablo R. Ortiz
        Iron Contributor

        It's not a workaround, you are downloading a connection file to your SfarePoint Library, not an Excel workbook.

  • What versión of Office/Excel client you have installed?

    Please go to Control panel -> Programs and check there aren't different versions of Office installed.

    You could also try a Repair Office.

    • Aurel Murariu's avatar
      Aurel Murariu
      Copper Contributor

      Microsoft Office 365 Pro Plus, I currently have the 32 bit version. This is officially deployed in the entire company. There is no other Office version on my MS Surface.

Resources