Forum Discussion
Forms responses missing when Excel is opened
- Apr 28, 2018
Dear Forms customers,
Forms for Excel contains a live data connection to your form. Any new response data will be stored in your form, and also be reflected in your workbook. On occasion, the workbook may not contain the latest data for a number of reasons.
If this is the case, Forms provides a new feature, "Sync all responses to a new workbook", in order to “sync” your most recent responses to a new workbook. This new workbook will be stored next to your original workbook on OneDrive for Business or SharePoint Online. This will ensure your data is up to date. Learn more about how to get missing data.
Regards,
Zhongzhong
I have this same problem. Created an Excel Sheet in OneDrive, and used Forms for Excelt to create a form. At first it took responses just fine and added them to both the Form and the Spreadsheet in OneDrive, but now it no longer updates the Spreadsheet and I am missing some responses that are still in the form.
For now I'm going back to using Google Forms since they're much less clunky and more reliable than Office 365's Excel Forms are, and will also be going with GSuite over Office 365 for my business clients' email hosting due to reliably.
Hi Erik,
I'm sorry for the error, could you please send the form URL for me, so we could troubleshoot.
Regards,
Zhongzhong
- Erik WrightJan 22, 2018Copper ContributorThanks for the quick response! I've sent you a link to the form, but can't share the Excel Sheet itself due to Office 365 account restrictions. Let me know if you need anything else, as I'm quite technical when it comes to this kind of stuff having worked in IT for 10+ years.
- Zhongzhong_LiJan 22, 2018Microsoft
Hi Erik,
I have already received your form URL in private mail. We will do investigate based on your form ID (in your form URL) and try to recover the error.
Your data is safe in both Forms and Excel in O365. Even for engineering team, we don't have the permission to access your data.
Regards,
Zhongzhong
- RattusRattus07Apr 08, 2019Copper Contributor
I am having a similar problem: I make a form in Microsoft forms, and when I look at the answers in Excel it keeps responding with "Workbook Repaired" and it only shows answers from 2 of the multiple respondents. How can I stop this from happening each time I make a new form?
- Miguel ChumboFeb 07, 2018Copper Contributor
I am having the same problem. Please help.
- Jodie BoeldtFeb 27, 2018Copper Contributor
Hello,
I am having the same issue. Here is my link to the form: https://forms.office.com/Pages/ResponsePage.aspx?id=Nj4mDgk0IkaKyBjZk-dutgfVNnF7wAJGuxvgsdc0aodUODJTTkVTVTRVVjBSVzNFSlBLQTFSOVdPWS4u
- Zhongzhong_LiFeb 28, 2018MicrosoftThanks, I have sent it our engineer.
Regards,
Zhongzhong- Ataur–Rahim AhsanMar 02, 2018Copper Contributor
I have also sent you a Form link that has the same issue, please help
Thanks