Forum Discussion
Export to Excel
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.
It's not a workaround, you are downloading a connection file to your SfarePoint Library, not an Excel workbook.
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.
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:
Yes you are right, it is a connection. Nevertheless, my point remains:
- this is not normal behavior. Does Microsoft have a fix yet?
Please do not try to deviate from my initial subject. "Export to Excel" should open Microsoft Excel, period. This does not happen. Ergo - there is an error.