Forum Discussion
Form Responses not Showing when Using Open with Excel
I have a Microsoft Form with 99 responses. When choosing Open with Excel it is missing at least 30 of the responses. Is there a way to get it to show all the responses in Excel? The responses are there if you view them one by one from the Form.
- I also am experiencing this problem. I built a form for Students to Sign-In to the Lab, and just today it started only sending only 1,502 responses out of 2,553. The last responses are showing for 2/23/22, and I had all up through last week. Why is it not sending all 2,553 responses to Excel?
- I use MS Edge Chromium for my browser. I finally figured out that Forms was splitting my download into two files with 1,500 records in each file. Not sure why. There was an option to show all available downloaded files, or in my case only the 1st file. Once I turned this off I was able to see all of the files and get all my data.
- Zhongzhong_Li
Microsoft
Hi Kaylynn, let me follow up with you.We have a form that downloaded most of the responses but missed about an hour. The responses can be seen if you go to the summary and if you go to each one individually but they will not download in Excel.
- I am also having a similar problem. My Form shows 81 responses and it only displays 1 when I pull it up in Excel...please advise.
- Zhongzhong_Li
Hi Stephanie,
I'll follow up with you.
Regards,
Zhongzhong
I am also experiencing the same issue with my form. Please let me know if there is a way to pull the missing data into Excel. Thank you!
Actually, the responses ended up pulling into the Excel form the next morning. Strange! Hopefully, there aren't more issues in the future. Or perhaps if there is some way/function where we can pull the individual responses viewed into the Excel spreadsheet, that would be helpful
- Zhongzhong_Li
We are using Microsoft Graph API to write responses data into your Excel workbook. And we have retry logic to for the missing data when the API meets errors.
Sometime, people checkout the workbook in SPO or lock the workbook by legacy Excel client, so the workbook cannot get access by API. So we have to wait and retry later.
Now I have a form that will not open in Excel at all.
Session id: b913519d-312e-4f41-89a9-fcd203d19905
- Zhongzhong_Li
I will follow up with the people who has the met error for "Open in Excel".
I have encountered this issue as well. Is there a fix yet?
- HI,
Sign in
Sorry, but we’re having trouble signing you in.
AADSTS70001: Application 'c9a559d2-7aab-4f13-a6ed-e7e9c52aec87' is disabled.
I am getting this error.
Any help would be greatly appreciated.
Thanks,
Omi
- I have a current and urgent problem in this same vein. The parent form driving a complex business flow is malfunctioning. some responses going to the excel sheet, some skipping it entirely but the data showing up later in the flow. I really need some real-time help, if a MS agent could help.
AHaynes5697 your scenario doesn't make a lot of sense: if responses are showing up later in a power automate flow then they've clearly been recorded in the form & spreadsheet as a response. Could you give some screenshots so we can try to understand what the issue is?
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
- the same issue - not all of my 27 responses are in the downloaded xls file. also, other information like the date and time of the responses are missing.
