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
Chris-Smith
Oct 29, 2020Copper Contributor
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.
longding
Microsoft
Oct 29, 2020Chris-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.
- Chris-SmithOct 29, 2020Copper Contributor
longdingI have tried the Sync all responses to a new workbook, but either I am unable to find where the new workbook is going.
How do I collect network trace?
How do I escalate within the support team? (I have been trying to contact Microsoft and have a ticket raised for over 3 weeks and have not had any response)
While I understand not changing the workbook, sometimes additions are made as time goes by to automate tasks, so there should be some way to be able to choose where the responses are sent.
It appears there are common issues of the workbook and form losing their connection and no obvious way to reconnect them. I would thought that having the ability to re-link the spreadsheet and form would be important after 2 years.