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.
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.
Can you explain why I can't open the file "query.ipy" directly.
Sometimes I need to share the file to someone.
Hi ca_rem - no, I can't explain that. That's why I use the workaround of creating the Excel first and keeping it as an Excel. I open up the file and refresh the data and bypass the iqy altogether. Sorry I couldn't help more.