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
MicrosoftHi Rembert,
Yes, please try "Sync to new Excel workbook" to get your data into a new workbook.
It would be great if you could share your form URL with us, so we could troubleshoot the error you have met.
Regards,
Zhongzhong
I do not see the "more options" option to sync all responses...
- Zhongzhong_Li
Alan Cossey, please also be free to contact me directly when you have the ribbon status error.
It is a good opportunity for us to get more input from customer to validate our troubleshooting assumption. It will be more efficient than just analyzing service logs.
Regards,
Zhongzhong
Erin,
Yes, that seems to be a hit and miss too, unless I have missed something. Sometimes when I open the associated Excel spreadsheet up online the items on the Form ribbon option are greyed out. I usually refresh the browser or re-sign in or something like that before it starts to work properly.
