User Profile
Torbjrn
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Could not open exported iqy file downloaded from Sharepoint list
I need to export data from a Sharepoint list to Excel. I clicked "Export to Excel" and received a downloaded iqy file. When I tried to open the iqy file, I got this message: "An unexpected error has occurred. Changes to your data cannot be saved". In order to understand and solve the problem I have tested several hypotheses, so far without success. I then tested this on another Sharepoint site (same PC and same local software), and I was then able to export and open the downloaded iqy file and a linked Excel book was created. I now suspect that the problems I have with Sharepoint site # 1 has to do with user permissions to the Sharepoint site and/or to the list. Question: what types of Sharepoint user permission are needed for me to open an iqy file and create a linked Excel workbook?2.3KViews0likes0CommentsData from 365 list
I need to export data from a Sharepoint list to an Excel file. The Sharepoint list is located on a site belonging to an organization which I have access to through a user ID. After clicking the «Export to Excel» a file in iqy format is downloaded to my PC. Microsoft 365 is installed on my PC through a personal Microsoft 365 account. This account has a personal userID which is different from the userID I use when I access the Sharepoint list. When I try to open the iqy file, I get this error message: "An unexpected error has occurred. Changes to your data cannot be saved." This error message is very general and gives me no information on why the operation failed. I need to know the reason, or at least I need to know what the requirements for Excel exports from Sharepoint lists. Can anyone help?1.9KViews0likes7Comments
Recent Blog Articles
No content to show