Forum Discussion
Solved
Unable export to excel from Sharepoint List using "Export to Excel" Built-in function?
Hi. I have a question abount the "Export to Excel" built in function in SharePoint List. I download query.iqy file from this Button. I use Excel to Open it. But I enable and this error appe...
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.
Is there a solution for this one already?? Im also looking for this. Thanks
- I had same issue and managed to resolve it by two simple steps.
First I tried to add new key into registry according MS documentation: https://learn.microsoft.com/en-us/office/troubleshoot/excel/cannot-export-to-excel
then I completely sign-out all accounts from Excel and tried it again.
Hope this will help to someone 🙂
