Forum Discussion
Forms responses missing when Excel is opened
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 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!