Forum Discussion
Forms responses missing when Excel is opened
- Apr 28, 2018
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.
- DeletedNov 10, 2017
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!
- Zhongzhong_LiNov 13, 2017Microsoft
Hi Tim,
Could you send me your form URL? I could help connect to the engineering team for troubleshooting.
Regards,
Zhongzhong
- Sarah FerrencyNov 13, 2017Copper Contributor
I created a form by opening a new Excel document, then clicking Forms --> +New Form. I created my survey, and annoyingly, the spreadsheet kept questions I had deleted or changed. I fixed the columns on the spreadsheet to match the questionnaire in the right order, and I deleted the ones that I had deleted off the form. I have received three responses to my form, and none of them have populated the spreadsheet. I can see them in the "Responses" tab from the forms view. When I click "Open in Excel," the same empty spreadsheet (with the question headers) opens up. Please let me know what I can do to get my responses in Excel, without having to redo the form since it has already been distributed. Thanks! PS: I would be happy to send the URL but I do not want to post it publicly.
- Ahti SyreeniNov 27, 2017Copper Contributor
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.
- Rachael FennerJan 20, 2018Copper Contributor
I am having this same issue! There are responses on my form, but when I open the spreadsheet, no responses show up! Please help!
- Zhongzhong_LiJan 22, 2018Microsoft
Could you send me your form URL, so we could troubleshoot.
- Maria KilgoreFeb 13, 2018Copper ContributorI 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?
- Maria KilgoreFeb 14, 2018Copper Contributor
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?