Forum Discussion

GREGOIRE DUGAST's avatar
GREGOIRE DUGAST
Copper Contributor
Mar 02, 2018

Forms for excel - OneDrive doesn't work anymore ?

Dear Community,

Since yesterday all my forms (forms for Excel - OneDrive) are broken :

  • All forms online don't save responses on the attached Excel document anymore. But I still received notifications mails.
  • When i create a new Forms for Excel on OneDrive, the Excel document remains empty and doesn't receive responses.
    In that case I noticed Excel document create a "Form1" sheet with columns linked to questions, where responses are stored.
    But now the sheet "Form1" isn't created, I just have an empty sheet named "Sheet1".

Thank you for your help !

  • Seems like someone edited or locked the Excel document you had the form pointed too. Your probably going to have to resetup the document to have the proper sheet name for it to know where to put the responses to.
  • Seems like someone edited or locked the Excel document you had the form pointed too. Your probably going to have to resetup the document to have the proper sheet name for it to know where to put the responses to.
    • Melinda Grant's avatar
      Melinda Grant
      Copper Contributor

      This has happened to one of our users to - and hasn't 'righted' itself in a month whilst I've been trying to find answers!

      She created a 'Form for Excel' which had the Excel file saved in a SharePoint site.

      We wanted the Excel Spreadsheet to display columns in a different order to the order questions were listed in the form, so she edited the Excel spreadsheet - which broke the link!!

      How do we get the link to re-connect??  Or, if we start again from scratch, how can we rearrange the spreadsheet of results without breaking the link again?

       

    • GREGOIRE DUGAST's avatar
      GREGOIRE DUGAST
      Copper Contributor

      Everything returned to normal...and I do know why and how.
      Maybe it was a simple "bug" from Microsoft servers, because all responses I didn't receive 2 days ago are now in the Excel doc.

      But thank you for help !

Resources