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
Julia Monahan
Mar 12, 2018Copper Contributor
I'm having a related issue:
I was working on a type of rudimentary ticketing system in which clients fill out the form and then our team can update status on the back end.
Everything was working fine until I added our backend columns to assign and track. Now it is no longer updating with new form submissions.
I'm guessing it is some sort of mapping issue but I can't find where I can fix it and there's little to no documentation or support...
UPDATE: Apparently it didn't break them but added them to row 1000+ ... no clue why and probably randomly making me file ginormous. but at least it still works...
Andrei Popa
Mar 20, 2018Copper Contributor
Hey!
I've created a form that had 4 questions. The form was used by us to gather data in a bounty program, when we saw that we already had over 10000 completions, we decided that we needn't more so we changed the intro text of the form to inform them that the bounty is over. Then we thought that we should delete the questions because we didn't want people to fill in more data. We did not download the CSV before deleting the questions and when we downloaded the CSV it was filled with 10000 + empty responses. The problem seems to be that if you delete a question it wil automatically delete the column from the csv that powers forms. Of course we did not know this and couldn't guess that it would delete even all the previous responses. So I think we need a previous version of the csv, before deleting the questions.
The form was exclusively handlet through forms.office.com.