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 am having this issue too.
I have created a form here: lishi.org/confirm-your-booking
linked to an excel spreadsheet
and I have set up a Zap to export the info to Gist and to Airtable
The data is being Zapped to Gist and Airtable but I cannot see it in the spreadsheet.
How can I view the data from the form in the spreadsheet?
Thanks
Microsoftlishiben You can open your Form at forms.office.com. In "Responses" tab, there is a button "download excel", you can download an excel include all responses.
Thanks longding
I have tried that but it hasn't made any difference.
Still only 3 entries instead of the 19 it should be.
I have tried searching my file system for the same file name to see if there is a duplicate anywhere.
Is there a way to find the filepath from Forms of the spreadsheet it is saving responses to?