Forum Discussion

John Booth's avatar
John Booth
Copper Contributor
Feb 19, 2018

Need help! I deleted my Forms Excel Sheet

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 

6 Replies

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor

    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

    • DominiqueMAB's avatar
      DominiqueMAB
      Copper Contributor

      Damien_Rosario 

       

      I have followed your instructions and i still get the error message 

       

      Cannot open Excel workbook
      The Excel workbook cannot be found. Please check if the workbook has been deleted.
      • Damien_Rosario's avatar
        Damien_Rosario
        Silver Contributor

        Hi DominiqueMAB 

         

        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

Resources