Forum Discussion
Forms responses missing when Excel is opened
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
June 18, 2018
Good Morning:
The form that I set up for our annual Kindergarten Bridges program is missing responses. According to my principal last week there were 5 responses and today there are only 2. Where did the responses go and how do we retrieve them if possible?
Sincerely,
Mrs. R.
Hello, Mrs. R,
Until Microsoft get their act together and stop this happening you will need to use the work around at https://support.office.com/en-us/article/how-to-get-missing-data-in-forms-9fb98299-4dcc-41a4-bb29-34a9c3daf8cc?ui=en-US&rs=en-US&ad=US
Been there, done that, twice, expect to need to do it again.
Alan Cossey
As per my reply to your private message, I am very grateful for this offer and will contact you if it goes wrong again since I have deleted the previous two Excel spreadsheets/form which went wrong. Currently things are working.
- Zhongzhong_Li
Microsoft
Hi Alan,
As I mentioned before, the whole data sync pipe is built upon Microsoft Graph / Excel API, we are working closely with API and Excel Online team to improve the reliability.
For most of the time, we need to solve the specific error/bug on reliability one by one, so if you could share your form URL, it will help us troubleshoot, and fix the error type you have met previously.
Regards,
Zhongzhong
