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
MicrosoftBased on our log, it shows the file has been locked (open by an legacy Excel client / check out), then the file has been deleted so we cannot find it.
Do you know has the file been locked, moved or deleted?
I can't see any entries in the Audit Log for the file being moved/deleted.
It is possible the file has been locked in the past as the client uses Excel 2010 - I have just done a quick test with a different form and no responses are added to the file while it is locked, but it seems the file will update again with any new responses once the file is unlocked again. The affected file is not currently locked as users can still edit it.
Thanks, that is useful information to pass back to the customer.
Just to confirm, if the file has been locked for 24hr there is no way of re-syncing to that file?
- Zhongzhong_Li
Yes, file lock will definitely block "data sync". And also other key features (e.g. co-authoring) cannot work.
That's why we suggest customer to upgrade to the latest Office client.
We will keep retry for 24hr. Therefore, if customer could unlock the file, he could still get the answers in Excel. After 24hr, they could only re-sync to a new file.