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
Hi this solved it for me, it now created a new One Drive Excel file with all data.
Thank you so much!
Nate Kennedy wrote:
If you click the export to excel button the link will flash and be redirected. But if you copy and past it then change the false at the end to a true it will open a new spreadsheet that will have all your data in it. This is the only work around I have found. But you will have all your data this way.
Example
data. https://forms.office.com/Pages/RedirectToExcelPage.aspx?id=RgHwM8xv6Um1aHiWswadRM6biPXhOnlKtde69MV1dHQUFYT1g5VzFUMjBPR0QxOUdQTi4u&forceReExport=false - change this false to a true
I hope this helps some of you!
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
If you click the export to excel button the link will flash and be redirected. But if you copy and past it then change the false at the end to a true it will open a new spreadsheet that will have all your data in it. This is the only work around I have found. But you will have all your data this way.
Example
data. https://forms.office.com/Pages/RedirectToExcelPage.aspx?id=RgHwM8xv6Um1aHiWswadRM6biPXhOnlKtde69MV1dHQUFYT1g5VzFUMjBPR0QxOUdQTi4u&forceReExport=false - change this false to a true
This resolved it for me perfectly!!!!
Zhongzhong_Li - please have the engineers update the "Open in Excel' link from 'false' to 'true'. This worked for me! However, when i open the excel file directly from OneDrive, the excel is strangely not updated. It only works when I go to that URL directly (with 'true' at the end of the URL)
- Zhongzhong_Li
Microsoft
Hi Justin Philip,
You could try the trick of change "false" to "true", it may solve your problem, but not always. That's why we didn't provide it as a official solution.
Actually we have a data sync service to make sure all of your responses get into the Excel workbook in real time. There may be random failure that the data sync action get failed, so we built up a retry system to redo the sync in every hours.
If your workbook met a fatal error after editing the workbook, which cannot be resolved by "retry", I will suggest to send the form URL for me. We will investigate the root cause and fix the problem on server side.
Before we fix the root cause, even you get a new workbook with the "true of false" trick, you has high risk to meet the same error again.
Regards,
Zhongzhong
- I don't have the export to excel option as the form was created within excel so it could be shared with staff
- Zhongzhong_Li
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,
ZhongzhongOffice 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
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
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
