Forum Discussion
Data 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 «Expo...
Do you have access to SharePoint from that computer? If so you may try to generate another query from scratch to check if it works.
I do have access to Sharepoint from my PC through the userID I use in the organization. It is I who created the Sharepoint list. I have tried many times to export the list data to Excel. Is that what you mean by "generate another query from scratch"?
On that computer select any list on SharePoint, click Export to Excel, open downloaded iqy file, enable data connection on prompt. If connection works you have the table in Excel workbook.
- This is exactly what I have tried many times, also with the organization userID on my local 365 Excel.
I now also tried to create a new list, then exported the new list. However, same error message again when I tried to open the iqy file.- I still have not been able to resolve this. Do you have any other suggestions?