SOLVED

Forms for excel - OneDrive doesn't work anymore ?

%3CLINGO-SUB%20id%3D%22lingo-sub-167284%22%20slang%3D%22en-US%22%3EForms%20for%20excel%20-%20OneDrive%20doesn't%20work%20anymore%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-167284%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Community%2C%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%3CP%3ESince%20yesterday%20all%20my%20forms%20(forms%20for%20Excel%20-%20OneDrive)%20are%20broken%20%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EAll%20forms%20online%20don't%20save%20responses%20on%20the%20attached%20Excel%20document%20anymore.%20But%20I%20still%20received%20notifications%20mails.%3C%2FLI%3E%0A%3CLI%3EWhen%20i%20create%20a%20new%20Forms%20for%20Excel%20on%20OneDrive%2C%20the%20Excel%20document%20remains%20empty%20and%20doesn't%20receive%20responses.%3CBR%20%2F%3E%3CEM%3EIn%20that%20case%20I%20noticed%20Excel%20document%20create%20a%20%22Form1%22%20sheet%20with%26nbsp%3Bcolumns%20linked%20to%20questions%2C%20where%20responses%20are%20stored.%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3EBut%20now%20the%20sheet%20%22Form1%22%20isn't%20created%2C%20I%20just%20have%20an%20empty%20sheet%20named%20%22Sheet1%22.%3C%2FEM%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EThank%20you%20for%20your%20help%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-167284%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-167555%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20for%20excel%20-%20OneDrive%20doesn't%20work%20anymore%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-167555%22%20slang%3D%22en-US%22%3E%3CP%3EEverything%20returned%20to%20normal...and%20I%20do%20know%20why%20and%20how.%3CBR%20%2F%3EMaybe%20it%20was%20a%20simple%20%22bug%22%20from%20Microsoft%20servers%2C%20because%20all%20responses%20I%20didn't%20receive%202%20days%20ago%20are%20now%20in%20the%20Excel%20doc.%3C%2FP%3E%0A%3CP%3EBut%20thank%20you%20for%26nbsp%3Bhelp%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-167520%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20for%20excel%20-%20OneDrive%20doesn't%20work%20anymore%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-167520%22%20slang%3D%22en-US%22%3ESeems%20like%20someone%20edited%20or%20locked%20the%20Excel%20document%20you%20had%20the%20form%20pointed%20too.%20Your%20probably%20going%20to%20have%20to%20resetup%20the%20document%20to%20have%20the%20proper%20sheet%20name%20for%20it%20to%20know%20where%20to%20put%20the%20responses%20to.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 !

3 Replies
Highlighted
Best Response confirmed by GREGOIRE DUGAST (New Contributor)
Solution
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.
Highlighted

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 !

Highlighted

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?