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
MicrosoftDear 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
Dear Microsoft,
When are you going to sort this out, please? I am again missing at least one response from my Excel spreadsheet. I know this because I demonstrated to someone how to use the Excel form. They got an acknowledgement of their input and when I got into Edit Form --> Responses I can see the item I added, but when I click on "Open in Excel" the spreadsheet opens in Excel Online missing that data.
This is a mess. Please sort it out so it works properly. Your post says, "On occasion, the workbook may not contain the latest data for a number of reasons." It's time to sort those reason out, don't you think?
