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
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)
MicrosoftHi 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
https://dmgmori-my.sharepoint.com/:x:/r/personal/gowen_dmgmori-usa_com/_layouts/15/WopiFrame.aspx?sourcedoc=%7B6941BAAC-DEF9-4E11-B249-E5B7C30F0FE6%7D&file=Bielefeld_%20%20CTX%20310%20etc.%20CTV,%20CTX%20Alpha,%20Beta,%20Gamma,%20TC%20%26%204A.%20%20(All%20versions)1%20-%20Master.xlsx&action=edit&d=w6941baacdef94e11b249e5b7c30f0fe6
Sir,
I have the same problem with missing data in Microsoft forms. I created a form and have received 188 responses, but only have 114 responses in excel.
The responses between 04/09/2018 and 04/23/2018 are not in the excel file. I have tried adding =TRUE to the URL bot doesn't change. Please advise.
- Thanks for the update. Is there an ETA on the official fix?
- Zhongzhong_Li
We have improved the reliability and performance for the data sync service based on the error cases people reported here.
At the same time, we are working on an official solution to help people generate a new live-synced workbook with Forms UI.
- Hi
The true/false technique worked for me but is it a permanent fix or will every user who needs to view the form sheet have to do this every time the select the "open in excel" option? The staff will not have that level of techspertise.
Robbie - Hi
The true/false technique worked for me but is it a permanent fix or will every user who needs to view the form sheet have to do this every time the select the "open in excel" option? The staff will not have that level of techspertise.
Robbie
