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
MicrosoftChris-Smith The user is a member of the SharePoint site or the owner of OneDirve to sync to a new workbook, Please first make sure this is true. Then try "Sync all responses in a new workbook" as in below link, it should work usually. https://support.microsoft.com/en-us/office/how-to-get-missing-data-in-forms-9fb98299-4dcc-41a4-bb29-34a9c3daf8cc
If "Sync all responses in a new workbook" still not helping, please collect network trace and escalate to support team.
And we suggest NOT to change the workbook Forms sync to, like formula, macro, etc. It may cause live sync broken.
longdingI have tried the Sync all responses to a new workbook, but either I am unable to find where the new workbook is going.
How do I collect network trace?
How do I escalate within the support team? (I have been trying to contact Microsoft and have a ticket raised for over 3 weeks and have not had any response)
While I understand not changing the workbook, sometimes additions are made as time goes by to automate tasks, so there should be some way to be able to choose where the responses are sent.
It appears there are common issues of the workbook and form losing their connection and no obvious way to reconnect them. I would thought that having the ability to re-link the spreadsheet and form would be important after 2 years.