Forum Discussion

Catherine Hartell's avatar
Catherine Hartell
Copper Contributor
Sep 14, 2017

Excel Spreadsheet not opening to show Forms responses

Hello, I was wondering if someone can help. We have created a survey using Office365 Forms but when we click on the 'Open in Excel' option we get the message 'Something went wrong'. This is only happ...
education
microsoft forms
Sugan_Rodrigo's avatar
Sugan_Rodrigo
Copper Contributor
Jan 18, 2019

A Solution for the "Excel not opening in Microsoft Forms"

 

When you open the forms in the browser, inside the URL you will find "DownloadFileSize=" that would have been mentioned some number greater than 3000. Change that value to 1000 or 1500.

 

This will break your result file as 1000 respondent per excel which will target for low file size and the excel will be downloaded.

 

- Sugan Rodrigo 

millguth's avatar
millguth
Copper Contributor
Jan 23, 2019

Hi There.

 

I've clicked every link in forms and I've opened every form I have, and every tab in forms. I can't see  "DownloadFileSize=" in any URL.

 

Are you able to screen shot your solution, just in case I'm missing something.

 

Mark

  • Sugan_Rodrigo's avatar
    Sugan_Rodrigo
    Copper Contributor
    Jan 24, 2019

    Dear Mark,

     

    Let me help you with an example.

     

    This will be your normal link for the survey :

    https://forms.office.com/Pages/DesignPage.aspx#Analysis=true&FormId

     

    https://forms.office.com/Pages/DesignPage.aspx?DownloadFileSize=1500#Analysis=true&FormId=KbhgE4U3lk2ubQERvxVIBvATGr7HEbxDjqVXLLPjoAxUNkY1SDVBR01RSTFLS0JZR0lYVUNGWDJQSi4u

     

    https://forms.office.com/Pages/DesignPage.aspx?DownloadFileSize=1500#Analysis=true&FormId=KbhgE4U3lk2ubQERvxVIBvATGr7HEbxDjqVXLLPjoAxUNkY1SDVBR01RSTFLS0JZR0lYVUNGWDJQSi4u#Analysis=true&FormId

     

    After Designpage.aspx insert "?DownloadFileSize=1500"

     

    Insert this option and try again.

     

    Regards

    Sugan

     

     

Resources