Forum Discussion
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'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...
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.
Hi,
Zhongzhong_Li I sent you a private message regarding a similar problem, can you please check your messages?
Thanks,
I'm getting the same problem (30th May 2018). I was getting blank lines appear in Excel Online and have been deleting them. Users have now been telling me that they have been entering data on Microsoft Forms, but I thought they had done something daft like not pressing the Submit button. However, in forms responses I can now see they have indeed been entering data, but Forms / Excel Online have been messing things up. What a mess!
Note that I have Synced the Document Library used by the spreadsheet/form to my hard drive as I link to it as a read-only linked table in Microsoft Access.
I see this has now been going on for 8 months. Come on Microsoft. Pull your finger out!
I posted a solution back in May on this thread but it seemed to have disappeared. Here is a summary.
I had the same problem with 50% of the responses missing.The best way to maximize your chances to have all your responses in your Excel is to have two excel documents. One document for the data and one for the processing of the data.The reason is that Excel tries to calculate every formula each time forms add a response. It can take a long time especially if you have a lot of formulas (I had 1000 complex formulas referencing the data). Forms is like a user, it tries to add data but if the document is calculating or blocked by another user it gives up. You then end up with missing data.Having a document for data allows forms to input data without being stuck by excel calculating or another user modifying the document. Excel will only try to calculate formulas when you open the processing document containing the formulas. It's also a great way to change your data document if needed.With this, I nearly never had missing data.Hopes it helps.Having a similar issue as described.
I realised that the link between my Microsoft Form and Microsoft Excel Workbook broke when I added a macro to one of the sheets and it saved the file as an .xlsm macro enabled workbook. I got rid of the macro and tried saving as an .xlsx again but it made no difference.
Have tried changing the False to True as described several times earlier, have also tried syncing all responses to a new workbook and also opening in Excel from the Forms Responses tab but no luck.
Raised the issue with our IT support 3 weeks ago who raised a support ticket with Microsoft, unfortunately I have had no response other than one offer of a callback one week ago which I agreed to, but Microsoft never bothered to call.
Yesterday I escalated to our IT support again and they have escalated to their own IT support who are closer to Microsoft.
I am hoping for an answer promptly as it has been broken for 3 weeks and I need to have this resolved tomorrow as I need to use the data for end of month reporting.
Any help would be much appreciated.
longdingMicrosoft
Chris-Smith The user is a member of the SharePoint site or the owner of OneDirve to sync to a new workbook, Please first make sure this is true. Then try "Sync all responses in a new workbook" as in below link, it should work usually. https://support.microsoft.com/en-us/office/how-to-get-missing-data-in-forms-9fb98299-4dcc-41a4-bb29-34a9c3daf8cc
If "Sync all responses in a new workbook" still not helping, please collect network trace and escalate to support team.
And we suggest NOT to change the workbook Forms sync to, like formula, macro, etc. It may cause live sync broken.
