Forum Discussion
Export to Excel
What happens when you click OK on this dialog? It should start downloading the file.
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. OrtizFeb 07, 2018Iron Contributor
It's not a workaround, you are downloading a connection file to your SfarePoint Library, not an Excel workbook.
- Aurel MurariuFeb 07, 2018Copper Contributor
For me, it is a workaround as long as it is not "normal behavior". Export to Excel should open Microsoft Excel on the local machine. This should go smoothly without any extra knowledge being required.
As stated before: end-users expect a straight forward action.
- Pablo R. OrtizFeb 07, 2018Iron Contributor
Please understand a SharePoint List/Library is not an Excel file. You are downloading a small connection file, which is very convenient because you can open it anywhere and it will ask for credentials to establish connection. You can also refresh any update to the List/Library.
You can share this link with users, to help them with feature adoption: