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
Rachael Fenner
Jan 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_Li
Microsoft
Jan 22, 2018Could you send me your form URL, so we could troubleshoot.
- Rachael FennerJan 22, 2018Copper ContributorIt actually worked once I cleared all the filters from the spreadsheet. Thanks for your quick response!
- Zhongzhong_LiJan 22, 2018
Microsoft
No worry. I'm glad to know it works for you now.
Please be free to let us know your feedback and anything we could help.
- Erik WrightJan 23, 2018Copper ContributorYou rock! Since you took a look behind the scenes, the form is now working again. Thanks!