Forum Discussion

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

Robert Dunne

Copper Contributor

Feb 23, 2018

I have a similar issue with my form. It was set up for teachers to register students on detention. The idea being that the supervising teacher on detention can open the excel sheet from the form to take attendance in the next column with a simple X or I. However, for the past while, the excel document has not been updating. The form has 193 responses but only 128 appear in the spreadsheet. It seems that every new entry is recorded in the form but overwrites the previous entry in the spreadsheet so that the spreadsheet never fills past row 129.

I have tried removing the filters but that has not helped.

Any/all help appreciated

Robbie

Zhongzhong_Li

Microsoft

Feb 24, 2018

Hi Robert,

Do you mind to send out your form URL to me with private message?

I could connect with engineering team to investigate.

Regards,
Zhongzhong

Erin Rembert
Copper Contributor
Jun 19, 2018
Office 365 Form Responses MISSING-Kindergarten Bridges
We are missing responses from our Kindergarten Bridges form. Is there any way to retrieve them? My principal said she saw about 5 last week and yesterday there were only 2.

-Mrs. Rembert
Erin Rembert
Copper Contributor
Jun 19, 2018
We are missing responses from our Kindergarten Bridges form. Is there any way to retrieve them? My principal said she saw about 5 last week and yesterday there were only 2.

-Mrs. Rembert
Esther Ida Krisanti
Brass Contributor
Apr 11, 2018
Hi , I'm experiencing the same issue. Could you please help? I've sent the URL to your message. Our staffs are responding to our forms, but we only see some empty rows in excel. We need it immediately as we use the forms heavily to do our operational wors. Please kindly help.

Thanks,
Esther