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
Did you ever get this issue resolved. I did something to break the link on my Survey as well. I'm getting responses but the Excel sheet is empty!
MicrosoftHi Tim,
Could you send me your form URL? I could help connect to the engineering team for troubleshooting.
Regards,
Zhongzhong
Hi Zhongzhong,
My client is currently experiencing this issue, responses have stopped syncing to the Excel doc. They briefly saw them overwriting the last response but now nothing gets written.
- Zhongzhong_Li
Hi Euan,
I hope this document could help - How to get the missing data in Forms.
Regards,
Zhongzhong
Hi Zhongzhong
Is there any way of troubleshooting this rather than re-syncing to a new spreadsheet? The users have been adding extra information to the spreadsheet gathered from the Form and to replicate this information would be an extra administrative burden. I can see from the audit log app@sharepoint is accessing the file and when I have the file open I can see SharePoint App editing the file so it looks like the connection still works but something is preventing the new rows from being written.
I created a form by opening a new Excel document, then clicking Forms --> +New Form. I created my survey, and annoyingly, the spreadsheet kept questions I had deleted or changed. I fixed the columns on the spreadsheet to match the questionnaire in the right order, and I deleted the ones that I had deleted off the form. I have received three responses to my form, and none of them have populated the spreadsheet. I can see them in the "Responses" tab from the forms view. When I click "Open in Excel," the same empty spreadsheet (with the question headers) opens up. Please let me know what I can do to get my responses in Excel, without having to redo the form since it has already been distributed. Thanks! PS: I would be happy to send the URL but I do not want to post it publicly.
