Forum Discussion

jaden_12135's avatar
jaden_12135
Copper Contributor
Jan 22, 2020

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 Junior's avatar
    Paulo Junior
    Brass 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_12135's avatar
      jaden_12135
      Copper Contributor

      Paulo Junior 

       

      Sorry I should have mentioned that I tried that originally. 

       

      I get An error has occurred on the server.

       

      • rafaelhsl's avatar
        rafaelhsl
        Copper 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.

         

Resources