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
MicrosoftHi Emanuel Foglander, Maria Kilgore, Nate Kennedy, Timothy Denton, Erik Michael and Evan Raiewski,
Thanks for reaching out and sorry for the error for your Forms and Excel workbook.
Do you mind to send me a private mail with your form URL, so I could ask our engineers to follow up?
Regards,
Zhongzhong
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!
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!
You're a genious ! Thanks a lot !
That completely fixed my Excel sheet, creating a new one which workd perfectly.
Note for others : the "export" button is on the form's response's tab. Be quick to copy the URL...
- Pretty funny to see community members explaining the fix to the Microsoft team!
Thanks for this - worked fine for me!!! 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!
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!
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
