Forum Discussion
Solved
Forms responses missing when Excel is opened
I have created a Form in Office 365 Business and now have 81 responses. When I try to open the responses in Excel, it only shows that I have 1 response. Please advice.
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
Did you ever get this issue resolved. I did something to break the link on my Survey as well. I'm getting responses but the Excel sheet is empty!
Unfortunately I did not managed to solve it and neither did our IT department (my request is still pending). I read from some forums that old versions of Microsoft Office may temporarily lock the excel files so that the synchronizer cannot write on them. I have recent OneDrive client installed and Excel 2013 so my best quess is that even I did not have opened any files locally or Excel even running when students were answering with their mobile phones, maybe some files were somehow still locked. Anyway, this system feels too unreliable for me if I cannot be absolutely sure that all responses are in excel files. In addition, it seems like forms are not saved in excel-files so I cannot even move or copy excel files in OneDrive without loosing the forms.