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 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.
I exported from forms to one drive anf then deleted the spreadsheet out of onedrive.
Hm. I could see how being unable to see responses would make "sense" if the Form originated from an Excel workbook in OneDrive, but if you really did create the Form from Forms first...I'm out of explanations for this.
Me too. The only thing I have been able to figure out through piecing things together is that I broke the live link to the spread sheet and therefore made it mad.
