Forum Discussion
Stephanie Piazza
Sep 14, 2017Copper Contributor
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.
- 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
Stephanie Piazza
Sep 18, 2017Copper Contributor
I exported from forms to one drive anf then deleted the spreadsheet out of onedrive.
Matt Coats
Sep 18, 2017Steel Contributor
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.
- Stephanie PiazzaSep 18, 2017Copper Contributor
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.