Forum Discussion
Form Responses not Showing when Using Open with Excel
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
MicrosoftWe 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.
What exactly does this mean? At this time the form still will not Open with Excel. Previous forms are working fine. Please tell me what can be done to resolve the issue. This is incredibly frustrating since we now have data can we cannot easily get to due to the error message.
- Zhongzhong_Li
Looks like you have met a blocking error on API side.
Could you send me the URL of your form (the URL you send out to responders)?
Then we could do futher investigation and provide solution to help you get data into Excel.
