Sep 14 2017
01:48 AM
- last edited on
Aug 06 2023
01:57 PM
by
TechCommunityAP
Sep 14 2017
01:48 AM
- last edited on
Aug 06 2023
01:57 PM
by
TechCommunityAP
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 happening for some of the Forms and they have all been set up in the same way. We have checked permissions and browsers but no luck!
Thank You.
Dec 17 2017 11:39 PM
Did they tell you to do anything specific? Because I have the exact same problem. I contacted Microsoft support and opened a ticket but it's been 3 days now and they are still try to find a solution :(
Dec 18 2017 05:19 AM
It was a problem on their end and they pushed out a fix to us. Nothing I could do on my end.
Dec 19 2018 05:00 PM
Same here. Need a fix.
Dec 27 2018 06:39 AM
How do I resolve this problem? 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 happening for some of the Forms and they have all been set up in the same way. We have checked permissions and browsers but no luck
Jan 18 2019 12:07 AM
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
Jan 23 2019 02:56 PM
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
Jan 23 2019 08:32 PM
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
This is where you can insert the download option : (Marked in Bold)
https://forms.office.com/Pages/DesignPage.aspx?DownloadFileSize=1500#Analysis=true&FormId
After Designpage.aspx insert "?DownloadFileSize=1500"
Insert this option and try again.
Regards
Sugan
Oct 18 2019 08:10 PM
thanks @Sugan_Rodrigo - worked for me!
Aug 23 2020 07:22 PM
Aug 29 2023 11:55 AM