Forum Discussion
Unable export to excel from Sharepoint List using "Export to Excel" Built-in function?
Hi ca_rem - the initial load does put in several columns that you may not be interested in. all you have to do is hide or delete those columns. whenever you open and refresh the data, it will keep those columns hidden. I've used this successfully several times. I have one spreadsheet that is connected to 3 lists and then have built the pivot tables on new tabs in the same workbook.
Hi ca_rem - I've been running into this a lot lately. My workaround is to
- Go to the Site Assets Library on the same site
- Create an Excel file
- Data > Get Data
- Connect to SharePoint Online list
Hope that helps!
Follow your instruction. I do:
1. Done
2. Done
3,4. You mean I open Excel Application on Window and go to Data > Get Data > Connect to SharePoint Online list. Right? My steps is below.
But what's next?
I go back again to the "query.iqy". But nothing changes. The error's still there.
Can you give me some advices?
Hi ca_rem - when you select your list, it should populate the Excel. What's happening after you select your list?
When I choose a list and load this. It will open a new Spreadsheet with some column of my items, but I see many columns like system data column like: FileSystemObjectType, ServerRedirectedEmbedUrl, GUID
I have 2 option here, If I choose Load, It opens a new spreadsheet:
If I choose Transform Data, I open a new Excel Window - Power Query Editor (Something like Access):
I don't know what you see when you open the file query.iqy is the same what I see with this method? My goal is to display the columns in the All Item View of the List or in a specific view if it could through open the query.iqy file.
Hi ca_rem - the initial load does put in several columns that you may not be interested in. all you have to do is hide or delete those columns. whenever you open and refresh the data, it will keep those columns hidden. I've used this successfully several times. I have one spreadsheet that is connected to 3 lists and then have built the pivot tables on new tabs in the same workbook.