Forum Discussion
jaden_12135
Jan 22, 2020Copper Contributor
Export to Excel - No Data
When selecting 'Export to Excel' I don't get any data in my Excel document.
At first I received an error when exporting into Excel (Microsoft Office has identified a potential security concern).
When I added the file path I could then open the Excel sheet.
There are headers, however, the data doesn't populate.
I have selected 'unhide' and I have also made sure there are no filters.
I can confirm there is data there that needs to be exported.
Not sure if related, however, it is now exporting as .iqy instead of .xlsx and/or .csv
- Paulo JuniorBrass Contributor
Microsoft Link about your question topic: https://support.office.com/en-us/article/export-to-excel-from-sharepoint-bfb2ea48-6118-4fa9-abb6-cced9424e5d9
- Paulo JuniorBrass Contributor
Hi jaden_12135,
The normal behavior os the "Export to Excel" button generate and download a ".iqy" file, using the current view. This is an Excel Web Query File.
When this file is opened, normally the Excel launchs and show a security alert. This is not a error, this is normal behavior.
If you click in "Disable", the data can't load to your spreadsheet.
- jaden_12135Copper Contributor
Sorry I should have mentioned that I tried that originally.
I get An error has occurred on the server.
- rafaelhslCopper Contributor
Hello Jaden.
I experienced the same issue today and to solve it, I had to alter display setting. Select All Items, then, select Edit display current model (my language is Portuguese, I'm not sure about the right words).
On the Settings, look on Filter. You must set Show all items in this view.