Form Responses not Showing when Using Open with Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-103283%22%20slang%3D%22en-US%22%3EForm%20Responses%20not%20Showing%20when%20Using%20Open%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-103283%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BI%20have%20a%20Microsoft%20Form%20with%2099%20responses.%20When%20choosing%20Open%20with%20Excel%20it%20is%20missing%20at%20least%2030%20of%20the%20responses.%20Is%20there%20a%20way%20to%20get%20it%20to%20show%20all%20the%20responses%20in%20Excel%3F%20The%20responses%20are%20there%20if%20you%20view%20them%20one%20by%20one%20from%20the%20Form.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-103283%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-482108%22%20slang%3D%22en-US%22%3ERe%3A%20Form%20Responses%20not%20Showing%20when%20Using%20Open%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-482108%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7646%22%20target%3D%22_blank%22%3E%40Zhongzhong%20Li%3C%2FA%3E%26nbsp%3B%20I%20have%20an%20excel%20workbook%20that%20is%20getting%20live%20data%20from%20a%20form%2C%20however%20I%20noticed%202%20blank%20lines%20in%20the%20workbook%2C%20like%20the%20responses%20were%20not%20synced%20correctly.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20looked%20at%20the%20individual%20responses%20on%20the%20form%20but%20they%20are%20not%20there%20either.%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20get%20those%20responses%20back%20or%20at%20least%20ensure%20it%20doesn't%20happen%20again%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-193220%22%20slang%3D%22en-US%22%3ERe%3A%20Form%20Responses%20not%20Showing%20when%20Using%20Open%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-193220%22%20slang%3D%22en-US%22%3E%3CP%3EI%20hope%20this%20article%20could%20help%20you%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fhow-to-get-missing-data-in-forms-9fb98299-4dcc-41a4-bb29-34a9c3daf8cc%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EHow%20to%20get%20missing%20data%20in%20Forms%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-193201%22%20slang%3D%22en-US%22%3ERe%3A%20Form%20Responses%20not%20Showing%20when%20Using%20Open%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-193201%22%20slang%3D%22en-US%22%3EHI%2C%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3ESign%20in%3CBR%20%2F%3ESorry%2C%20but%20we%E2%80%99re%20having%20trouble%20signing%20you%20in.%3CBR%20%2F%3E%3CBR%20%2F%3EAADSTS70001%3A%20Application%20'c9a559d2-7aab-4f13-a6ed-e7e9c52aec87'%20is%20disabled.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20getting%20this%20error.%3CBR%20%2F%3EAny%20help%20would%20be%20greatly%20appreciated.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%2C%3CBR%20%2F%3EOmi%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-146121%22%20slang%3D%22en-US%22%3ERe%3A%20Form%20Responses%20not%20Showing%20when%20Using%20Open%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-146121%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20encountered%20this%20issue%20as%20well.%20Is%20there%20a%20fix%20yet%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-109902%22%20slang%3D%22en-US%22%3ERe%3A%20Form%20Responses%20not%20Showing%20when%20Using%20Open%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-109902%22%20slang%3D%22en-US%22%3E%3CP%3ELooks%20like%20you%20have%20met%20a%20blocking%20error%20on%20API%20side.%3C%2FP%3E%0A%3CP%3ECould%20you%20send%20me%20the%20URL%20of%20your%20form%20(the%20URL%20you%20send%20out%20to%20responders)%3F%3C%2FP%3E%0A%3CP%3EThen%20we%20could%20do%20futher%20investigation%20and%20provide%20solution%20to%20help%20you%20get%20data%20into%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-109272%22%20slang%3D%22en-US%22%3ERe%3A%20Form%20Responses%20not%20Showing%20when%20Using%20Open%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-109272%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20exactly%20does%20this%20mean%3F%20At%20this%20time%20the%20form%20still%20will%20not%20Open%20with%20Excel.%20Previous%20forms%20are%20working%20fine.%20Please%20tell%20me%20what%20can%20be%20done%20to%20resolve%20the%20issue.%20This%20is%20incredibly%20frustrating%20since%20we%20now%20have%20data%20can%20we%20cannot%20easily%20get%20to%20due%20to%20the%20error%20message.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-109185%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Form%20Responses%20not%20Showing%20when%20Using%20Open%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-109185%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Stephanie%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'll%20follow%20up%20with%20you.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERegards%2C%3C%2FP%3E%0A%3CP%3EZhongzhong%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-109184%22%20slang%3D%22en-US%22%3ERe%3A%20Form%20Responses%20not%20Showing%20when%20Using%20Open%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-109184%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20using%20Microsoft%20Graph%20API%20to%20write%20responses%20data%20into%20your%20Excel%20workbook.%20And%20we%20have%20retry%20logic%20to%20for%20the%20missing%20data%20when%20the%20API%20meets%20errors.%3C%2FP%3E%0A%3CP%3ESometime%2C%20people%20checkout%20the%20workbook%20in%20SPO%20or%20lock%20the%20workbook%20by%20legacy%20Excel%20client%2C%20so%20the%20workbook%20cannot%20get%20access%20by%20API.%20So%20we%20have%20to%20wait%20and%20retry%20later.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-109178%22%20slang%3D%22en-US%22%3ERe%3A%20Form%20Responses%20not%20Showing%20when%20Using%20Open%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-109178%22%20slang%3D%22en-US%22%3E%3CP%3EI%20will%20follow%20up%20with%20the%20people%20who%20has%20the%26nbsp%3Bmet%20error%20for%20%22Open%20in%20Excel%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-107811%22%20slang%3D%22en-US%22%3ERe%3A%20Form%20Responses%20not%20Showing%20when%20Using%20Open%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-107811%22%20slang%3D%22en-US%22%3E%3CP%3ENow%20I%20have%20a%20form%20that%20will%20not%20open%20in%20Excel%20at%20all.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ESession%20id%3A%20b913519d-312e-4f41-89a9-fcd203d19905%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-107808%22%20slang%3D%22en-US%22%3ERe%3A%20Form%20Responses%20not%20Showing%20when%20Using%20Open%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-107808%22%20slang%3D%22en-US%22%3E%3CP%3EActually%2C%20the%20responses%20ended%20up%20pulling%20into%20the%20Excel%20form%20the%20next%20morning.%20Strange!%20Hopefully%2C%20there%20aren't%20more%20issues%20in%20the%20future.%20Or%20perhaps%20if%20there%20is%20some%20way%2Ffunction%20where%20we%20can%20pull%20the%20individual%20responses%20viewed%20into%20the%20Excel%20spreadsheet%2C%20that%20would%20be%20helpful%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-107796%22%20slang%3D%22en-US%22%3ERe%3A%20Form%20Responses%20not%20Showing%20when%20Using%20Open%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-107796%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20also%20experiencing%20the%20same%20issue%20with%20my%20form.%20Please%20let%20me%20know%20if%20there%20is%20a%20way%20to%20pull%20the%20missing%20data%20into%20Excel.%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-106201%22%20slang%3D%22en-US%22%3ERE%3A%20Form%20Responses%20not%20Showing%20when%20Using%20Open%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-106201%22%20slang%3D%22en-US%22%3EI%20am%20also%20having%20a%20similar%20problem.%20My%20Form%20shows%2081%20responses%20and%20it%20only%20displays%201%20when%20I%20pull%20it%20up%20in%20Excel...please%20advise.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-103437%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Form%20Responses%20not%20Showing%20when%20Using%20Open%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-103437%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20a%20form%20that%20downloaded%20most%20of%20the%20responses%20but%20missed%20about%20an%20hour.%20The%20responses%20can%20be%20seen%20if%20you%20go%20to%20the%20summary%20and%20if%20you%20go%20to%20each%20one%20individually%20but%20they%20will%20not%20download%20in%20Excel.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-103305%22%20slang%3D%22en-US%22%3ERE%3A%20Form%20Responses%20not%20Showing%20when%20Using%20Open%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-103305%22%20slang%3D%22en-US%22%3EHi%20Kaylynn%2C%20let%20me%20follow%20up%20with%20you.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

 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.

15 Replies
Highlighted
Hi Kaylynn, let me follow up with you.
Highlighted

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. 

Highlighted
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.
Highlighted

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!

Highlighted

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

Highlighted

Now I have a form that will not open in Excel at all. 

 

Session id: b913519d-312e-4f41-89a9-fcd203d19905

Highlighted

I will follow up with the people who has the met error for "Open in Excel".

Highlighted

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.

Highlighted

Hi Stephanie,

 

I'll follow up with you.

 

Regards,

Zhongzhong

Highlighted

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. 

Highlighted

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.

Highlighted

I have encountered this issue as well. Is there a fix yet?

Highlighted
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
Highlighted

I hope this article could help you - How to get missing data in Forms

 

Highlighted

@Zhongzhong Li  I have an excel workbook that is getting live data from a form, however I noticed 2 blank lines in the workbook, like the responses were not synced correctly. 

I looked at the individual responses on the form but they are not there either. 

How can I get those responses back or at least ensure it doesn't happen again?