Feb 19 2018
11:11 AM
- last edited on
Aug 04 2023
01:25 AM
by
TechCommunityAP
Feb 19 2018
11:11 AM
- last edited on
Aug 04 2023
01:25 AM
by
TechCommunityAP
I accidentally deleted the Excel sheet containing my Form responses and don't know how to export my responses. Each time I try I receive an error stating that my sheet may have been deleted...
Help help if you are able.
John
Feb 19 2018 07:17 PM
Hi John
If you have creation rights to the form, you can go back and export the responses to Excel.
1. Click onto the form you want to view.
2. Click onto the Responses tab (to the right of the Questions tab where you would have set up the forms questions).
3. Click onto the Open in Excel link. The results of the form should export to Excel.
Hopefully that is what you are after.
Good luck and let us know how you go?
Cheers
Damien
Oct 11 2019 09:23 AM
I have followed your instructions and i still get the error message
Oct 11 2019 09:24 AM
Oct 13 2019 04:11 PM
How was your form generated? Did you create it in OneDrive, or straight from Forms itself, or did you create it in a SharePoint group?
If it's OneDrive, go into your OneDrive and the root directory may have your Excel doc results in it.
If it's Forms itself, the instructions above should have worked.
If it's SharePoint, go into the SharePoint group that it's associated with, and check the Documents directory for the Excel file.
If all else fails, try logging a ticket with Microsoft Support (do this through your IT guy or perhaps one of the Microsoft Employees who frequent this site can assist @Yong Qiu).
Hope you find a solution!
Cheers
Damien
Oct 13 2019 04:17 PM
Oh one last one which may do the trick, did you check the recycle bin of your OneDrive or SharePoint site to see if the file is there?
If it is, restore it!
Cheers
Damien
Jun 21 2021 08:08 PM