Forum Discussion
GREGOIRE DUGAST
Mar 02, 2018Copper Contributor
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 !
- DeletedMar 04, 2018Seems 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.
- DeletedSeems 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 GrantCopper 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?
- Phil DetweilerBrass ContributorFor any serious work, the Forms for Excel is a mostly useless feature that breaks by design the moment you manually edit the workbook.
https://support.microsoft.com/en-us/office/how-to-ensure-your-form-and-workbook-are-in-sync-e7fd7e45-d63f-4b30-b2ed-76709fe35813
I learned this just now thinking I could solicit data from users using Forms, then calculate results in Excel behind the scenes. It lets you do everything but at some point, just stops working, no error messages, nothing... just doesn't work anymore. Microsoft's answer is, "sync to a new workbook". Oh, okay... no problem, I'll just recreate my workbook whenever it decides to stop working...
- GREGOIRE DUGASTCopper 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 !