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

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

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

 

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

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

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.

Hi Stephanie,

 

I'll follow up with you.

 

Regards,

Zhongzhong

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. 

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.

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 hope this article could help you - How to get missing data in Forms

 

@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?