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
MicrosoftBased on your screenshot, your form doesn't have a connection with Excel online workbook. To create a form has live connection, you could check the document here.
For your form, every time you click on "Open in Excel", you will receive a new download file, which should always contain the latest data.
Do you mean for the new download file, it also has missing data?
Yes.
My principal checked and one week there were 5 responses and the next week there were only 2.
When I generated the excel file there were still only 2 responses showing.
-Mrs. Rembert
Kindergarten Bridges Form missing responses in both responses and excel