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
MicrosoftHi 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
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?
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?
