Forum Discussion

Stephanie Piazza's avatar
Stephanie Piazza
Copper Contributor
Sep 14, 2017
Solved

Forms responses missing when Excel is opened

I have created a Form in Office 365 Business and now have 81 responses.  When I try to open the responses in Excel, it only shows that I have 1 response.  Please advice.
microsoft forms
  • Zhongzhong_Li's avatar
    Zhongzhong_Li
    Apr 28, 2018

    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

     

Zhongzhong_Li's avatar
Zhongzhong_Li
Icon for Microsoft rankMicrosoft
Nov 20, 2018

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.

Euan Eddie's avatar
Euan Eddie
Copper Contributor
Nov 20, 2018

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?

Resources