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
I am having the same problem. The form has responses but the Excel spreadsheet is completely blank.
I have this same problem. Created an Excel Sheet in OneDrive, and used Forms for Excelt to create a form. At first it took responses just fine and added them to both the Form and the Spreadsheet in OneDrive, but now it no longer updates the Spreadsheet and I am missing some responses that are still in the form.
For now I'm going back to using Google Forms since they're much less clunky and more reliable than Office 365's Excel Forms are, and will also be going with GSuite over Office 365 for my business clients' email hosting due to reliably.- Zhongzhong_Li
Microsoft
Hi Erik,
I'm sorry for the error, could you please send the form URL for me, so we could troubleshoot.
Regards,
Zhongzhong
Hello,
I am having the same issue. Here is my link to the form: https://forms.office.com/Pages/ResponsePage.aspx?id=Nj4mDgk0IkaKyBjZk-dutgfVNnF7wAJGuxvgsdc0aodUODJTTkVTVTRVVjBSVzNFSlBLQTFSOVdPWS4u
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?
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?
I am having this same issue! There are responses on my form, but when I open the spreadsheet, no responses show up! Please help!
I don't know if this makes a difference but after I checked to make sure that the form was working and onpened it in excel the first time, I then deleted the spreadsheet out of my OneDrive. If this is what caused the problem, is there away to get the data onto a spreadsheet now? Thanks!
To confirm, are you saying that you created the Form from an Excel workbook in OneDrive, or that you exported your results to OneDrive and deleted that?
I'm having the same problem, I have a form that I made in excel online and some of the responses are missing. This is a rather large survey that will go out to around 1300 people. I'm missing about 50 out of 312 right now. Please advise I would like to get this fixed soon.
