Sep 13 2017
07:30 PM
- last edited on
Aug 06 2023
01:57 PM
by
TechCommunityAP
Sep 13 2017
07:30 PM
- last edited on
Aug 06 2023
01:57 PM
by
TechCommunityAP
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.
Feb 26 2018 04:47 PM
Just ran into this problem last week and now again today. I have 4 broken Forms I'm using for student assessments. @Zhongzhong Li, I pm'd you with the URLs
Feb 27 2018 09:51 AM
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=RgHwM8xv6Um1aHiWswadRM6biPXhOnlKtde69MV1d...false - change this false to a true
Feb 27 2018 11:27 AM
Feb 27 2018 01:10 PM
Hello,
I am having the same issue. Here is my link to the form: https://forms.office.com/Pages/ResponsePage.aspx?id=Nj4mDgk0IkaKyBjZk-dutgfVNnF7wAJGuxvgsdc0aodUODJT...
Feb 27 2018 04:47 PM
Feb 28 2018 03:13 PM
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)
Feb 28 2018 03:17 PM
This does not work if you need to add formulas. For example, I need to know how long the form takes to complete and must add a column with a formula for time ended - time started. Any columns you have created do not come up when simply changing false to true, like they come up in onedrive when this is working the way it is supposed to.
Feb 28 2018 03:20 PM
Feb 28 2018 11:05 PM
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
Feb 28 2018 11:18 PM
Yes, you are right.
Data has been stored in Forms, and we sync the data into Excel workbook via Microsoft Graph / Excel REST API. I'm sorry for the error you have met, but we are actively working on the improvement with several partner teams.
Based on our design, customer could use all Excel features to analysis data in the workbook (e.g. formula, sort and filtering). Please be free to let us know if you find conflict between Forms data and Excel features.
Mar 01 2018 07:56 AM
Hi,
Please could you fix my form to feed the responses in to original spreadsheet. I have tried false to true fix - it fixed it so I can see the responses but in a new spreadsheet. I need it to be in the original spreadsheet as I have some additional columns and other related tabs in that excel spreadsheet.
Thanks a lot in advance.
Mar 01 2018 08:44 AM
Mar 01 2018 12:36 PM
Hello. I am having a similar issue to that described above. We have an online form at work that I created and it has been working perfectly until today. New responses to the form are in the Form Response tab, but they are not showing up in the online Excel document as before. We did not change anything, it just stopped working. I would really appreciate someone's help in getting this working. I looked at the tip to change the "false" and "true" after clicking the Open in Excel button, but I do not see a false or true in the URL. It just opens it in Excel automatically. Thanks!
Mar 02 2018 07:24 AM
I have also sent you a Form link that has the same issue, please help
Thanks
Mar 03 2018 12:06 AM
Mar 03 2018 01:01 AM
Mar 05 2018 06:27 AM
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.
Mar 05 2018 06:33 AM
The false / true trick is not the official solution. Once you try that URL, your form will disconnected with the original workbook, and generate a new workbook.
We cannot move the connection back to the original workbook.
Mar 05 2018 08:30 AM
Mar 05 2018 11:34 AM
The url flashes briefly before opening in excel. So, you'll need to catch it at the right time. In other words click the open in excel button then watch the url box for the link. You will see an =false at the end, change that to an =true.