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
I have same problem: some responses are showing only on Forms web user interface, not in Excel files. My files were created with Excel Online (in OneDrive) then added forms with Forms for Excel. I have 12 files with forms. During one hour, two persons answered with mobile phones and the other response can be found in Excel file while the other response is only on Forms. Even if I open the file on Forms using link "Open in Excel". the other response is still missing. Some files received both responses. I already contacted local IT support (and received no response) and tried to contact Microsoft helpdesk by phone (they asked to contact local IT support). If synchronization between Forms and Excel is unreliable, then it should at least ask "Would you like to add missing responses to Excel?", when I open the Forms responses using the link "Open in Excel" on Forms.
I am experiencing the same issues, where I open the the Excel spreadsheet through Forms "Open in Excel" and am missing responses. Is this a system wide issue, and is there a solution?
