SOLVED

Forms responses missing when Excel is opened

Copper Contributor

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.

125 Replies

Based 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.

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.

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?

Hi Zhong Zhong@Zhongzhong Li 

 

My sharepoint form was created using Form for Excel in Folder A, which means that the responses from the Sharepoint form syncs to an excel file. However, I need to move this excel file to another folder, lets call is Folder B. 

 

When I move the excel file to Folder B, new responses to the form does not go into the excel file anymore. The best solution I managed to find so far is to use the option "sync all responses to a new workbook"to a new excel file. But the new excel file is again created in Folder A instead of Folder B.

 

Is there any solution or way to relink the excel file to the Sharepoint form after I moved the excel file? Pls let me know urgently. Thanks!

@Rele_2018 we use FileID to identify the file in SharePoint. If folder A and folder B are in the same SharePoint site, then you should be free to move the file, and the data sync connection keep working. If you met problem, please let me know, it should be a bug.

 

However, if folder A and folder B are in different SharePoint sites, we don't have good solution here (you could sync data into another workbook via Flow).

 

"Sync data to a specific file" is in our backlog. But I'm not sure if x-site file is in the scope.

@Zhongzhong Li 

 

Hi ZhongZhong

 

Folder A and B are different document libraries created under the same Sharepoint site (Team site).

 

@Rele_2018 

 

Thanks for the info. I will double check with engineers.

@Rele_2018, could you send me the form URL? 

@Zhongzhong Li 

i have sent you the form url thru private message. :)

@Rele_2018 Thanks. I have already passed it to engineering team.

@Zhongzhong Li 

 

I am having a similar problem: I make a form in Microsoft forms, and when I look at the answers in Excel it keeps responding with "Workbook Repaired" and it only shows answers from 2 of the multiple respondents. How can I stop this from happening each time I make a new form?

I am having a similar problem: I make a form in Microsoft forms, and when I look at the answers in Excel it keeps responding with "Workbook Repaired" and it only shows answers from 2 of the multiple respondents. How can I stop this from happening each time I make a new form?

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

@Zhongzhong Li 

@lishiben 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.

Hi @longding 
Thanks for your reply

When I open the spreadsheet it only shows 3 responses even though I have had 15 responses.

The spreadsheet is not updating even though the responses are visible in Forms.

How can I fix this?

Thank you

Hi @lishiben In "Responses" tab, There is a "..." button on top of "Open in Excel". Press "..." button , then press "Sync all responses to a new workbook". After sync is done, try "open in excel" again to see the 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?

 

Hi @lishiben , How may responses show at "Responses" tab? Is it "download excel" or "Open in excel" on the tab?

@Zhongzhong Li - I private messaged you about a similar issue. I tried this solution (thanks @Nate Kennedy !) and I was able to generate a new excel file and I can see the full list of respondents but their response to the survey is still blank. Please advise how I can recover this data. Thank you!

 

This survey is time-sensitive, so @longding if you are able to assist as well that would be great. Thank you!