Forum Discussion
Solved
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 not...
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.
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?
- For 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...
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 !
