Forum Discussion
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 MurariuCopper 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. OrtizIron Contributor
It's not a workaround, you are downloading a connection file to your SfarePoint Library, not an Excel workbook.
- Pablo R. OrtizIron Contributor
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 MurariuCopper 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.