Forum Discussion
Dave Pyett
Feb 14, 2019Brass Contributor
Issue with exporting responses to Excel
Hi all, Just starting out with Forms and have already come across an issue. We have set up a simple training survey form which works great. I've deleted all of the initial test responses so ...
Feb 14, 2019
Hi Dave Pyett,
Let's see if we can help
1.) Go to https://forms.office.com/ and login
2.) Select the form
3.) Select Reponses
4.) Select ... and delete all responses
5.) The open in excel should now be greyed out
6.) When you submit responses from this point a new excel should be populated
Hope that answers your question.
Best, Chris
Let's see if we can help
1.) Go to https://forms.office.com/ and login
2.) Select the form
3.) Select Reponses
4.) Select ... and delete all responses
5.) The open in excel should now be greyed out
6.) When you submit responses from this point a new excel should be populated
Hope that answers your question.
Best, Chris
Dave Pyett
Feb 14, 2019Brass Contributor
Thanks for that - have tried it but the Export to Excel option remains active and still shows all previous responses. The form itself shows 0 responses etc (attached screenshot).
Maybe just a timing thing? Will leave it until tomorrow and will try it again
Dave.
- Feb 14, 2019Ok! Another option could be to just copy/clone the form. So if you go back to Forms on the top left of the screen and select ... on the form and then copy you can clone it. This may be a workaround it.
Best, Chris- Dave PyettFeb 14, 2019Brass Contributor
Good idea - thanks
- Zhongzhong_LiFeb 19, 2019
Microsoft
Hi Dave,
I want to check that you have delete all responses in Forms web app, and when you click on "Download in Excel" (you will get a new download Excel workbook), the new workbook contains all the history data. Is it right?
Could you share your form URL with us, so we could troubleshoot?
Regards,
Zhongzhong