SOLVED

Forms responses missing when Excel is opened

%3CLINGO-SUB%20id%3D%22lingo-sub-106203%22%20slang%3D%22en-US%22%3EForms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-106203%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20Form%20in%20Office%20365%20Business%20and%20now%20have%2081%20responses.%20%26nbsp%3BWhen%20I%20try%20to%20open%20the%20responses%20in%20Excel%2C%20it%20only%20shows%20that%20I%20have%201%20response.%20%26nbsp%3BPlease%20advice.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-106203%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-401503%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401503%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20a%20similar%20problem%3A%20I%20make%20a%20form%20in%20Microsoft%20forms%2C%20and%20when%20I%20look%20at%20the%20answers%20in%20Excel%20it%20keeps%20responding%20with%20%22Workbook%20Repaired%22%20and%20it%20only%20shows%20answers%20from%202%20of%20the%20multiple%20respondents.%20How%20can%20I%20stop%20this%20from%20happening%20each%20time%20I%20make%20a%20new%20form%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-401502%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401502%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%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20a%20similar%20problem%3A%20I%20make%20a%20form%20in%20Microsoft%20forms%2C%20and%20when%20I%20look%20at%20the%20answers%20in%20Excel%20it%20keeps%20responding%20with%20%22Workbook%20Repaired%22%20and%20it%20only%20shows%20answers%20from%202%20of%20the%20multiple%20respondents.%20How%20can%20I%20stop%20this%20from%20happening%20each%20time%20I%20make%20a%20new%20form%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-381676%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-381676%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F304964%22%20target%3D%22_blank%22%3E%40Rele_2018%3C%2FA%3E%20Thanks.%20I%20have%20already%20passed%20it%20to%20engineering%20team.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-381668%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-381668%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%3C%2FP%3E%3CP%3Ei%20have%20sent%20you%20the%20form%20url%20thru%20private%20message.%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-378082%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-378082%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F304964%22%20target%3D%22_blank%22%3E%40Rele_2018%3C%2FA%3E%2C%20could%20you%20send%20me%20the%20form%20URL%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-378068%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-378068%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F304964%22%20target%3D%22_blank%22%3E%40Rele_2018%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%20for%20the%20info.%20I%20will%20double%20check%20with%20engineers.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-378057%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-378057%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%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20ZhongZhong%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFolder%20A%20and%20B%20are%20different%20document%20libraries%20created%20under%20the%20same%20Sharepoint%20site%20(Team%20site).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-378052%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-378052%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F304964%22%20target%3D%22_blank%22%3E%40Rele_2018%3C%2FA%3E%20we%20use%20FileID%20to%20identify%20the%20file%20in%20SharePoint.%20If%20folder%20A%20and%20folder%20B%20are%20in%20the%20same%20SharePoint%20site%2C%20then%20you%20should%20be%20free%20to%20move%20the%20file%2C%20and%20the%20data%20sync%20connection%20keep%20working.%20If%20you%20met%20problem%2C%20please%20let%20me%20know%2C%20it%20should%20be%20a%20bug.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHowever%2C%20if%20folder%20A%20and%20folder%20B%20are%20in%20different%20SharePoint%20sites%2C%20we%20don't%20have%20good%20solution%20here%20(you%20could%20sync%20data%20into%20another%20workbook%20via%20Flow).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%22Sync%20data%20to%20a%20specific%20file%22%20is%20in%20our%20backlog.%20But%20I'm%20not%20sure%20if%20x-site%20file%20is%20in%20the%20scope.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-378046%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-378046%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Zhong%20Zhong%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%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20sharepoint%20form%20was%20created%20using%20Form%20for%20Excel%20in%20Folder%20A%2C%20which%20means%20that%20the%20responses%20from%20the%20Sharepoint%20form%20syncs%20to%20an%20excel%20file.%20However%2C%20I%20need%20to%20move%20this%20excel%20file%20to%20another%20folder%2C%20lets%20call%20is%20Folder%20B.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20move%20the%20excel%20file%20to%20Folder%20B%2C%20new%20responses%20to%20the%20form%20does%20not%20go%20into%20the%20excel%20file%20anymore.%20The%20best%20solution%20I%20managed%20to%20find%20so%20far%20is%20to%20use%20the%20option%20%22sync%20all%20responses%20to%20a%20new%20workbook%22to%20a%20new%20excel%20file.%20But%20the%20new%20excel%20file%20is%20again%20created%20in%20Folder%20A%20instead%20of%20Folder%20B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20solution%20or%20way%20to%20relink%20the%20excel%20file%20to%20the%20Sharepoint%20form%20after%20I%20moved%20the%20excel%20file%3F%20Pls%20let%20me%20know%20urgently.%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-289204%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-289204%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%2C%20that%20is%20useful%20information%20to%20pass%20back%20to%20the%20customer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20to%20confirm%2C%20if%20the%20file%20has%20been%20locked%20for%2024hr%20there%20is%20no%20way%20of%20re-syncing%20to%20that%20file%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-289058%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-289058%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20file%20lock%20will%20definitely%20block%20%22data%20sync%22.%20And%20also%20other%20key%20features%20(e.g.%20co-authoring)%26nbsp%3Bcannot%20work.%3C%2FP%3E%0A%3CP%3EThat's%20why%20we%20suggest%20customer%20to%20upgrade%20to%20the%20latest%20Office%20client.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20will%20keep%20retry%20for%2024hr.%20Therefore%2C%20if%20customer%20could%20unlock%20the%20file%2C%20he%20could%20still%20get%20the%20answers%20in%20Excel.%20After%2024hr%2C%20they%20could%20only%20re-sync%20to%20a%20new%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-288628%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-288628%22%20slang%3D%22en-US%22%3E%3CP%3EI%20can't%20see%20any%20entries%20in%20the%20Audit%20Log%20for%20the%20file%20being%20moved%2Fdeleted.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20possible%20the%20file%20has%20been%20locked%20in%20the%20past%20as%20the%20client%20uses%20Excel%202010%20-%20I%20have%20just%20done%20a%20quick%20test%20with%20a%20different%20form%20and%20no%20responses%20are%20added%20to%20the%20file%20while%20it%20is%20locked%2C%20but%20it%20seems%20the%20file%20will%20update%20again%20with%20any%20new%20responses%20once%20the%20file%20is%20unlocked%20again.%20The%20affected%20file%20is%20not%20currently%20locked%20as%20users%20can%20still%20edit%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-288563%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-288563%22%20slang%3D%22en-US%22%3E%3CP%3EBased%20on%20our%20log%2C%20it%20shows%20the%20file%20has%20been%20locked%20(open%20by%20an%20legacy%20Excel%20client%20%2F%20check%20out)%2C%20then%20the%20file%20has%20been%20deleted%20so%20we%20cannot%20find%20it.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20know%20has%20the%20file%20been%20locked%2C%20moved%20or%20deleted%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-287572%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-287572%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Zhongzhong%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20of%20troubleshooting%20this%20rather%20than%20re-syncing%20to%20a%20new%20spreadsheet%3F%20The%20users%20have%20been%20adding%20extra%20information%20to%20the%26nbsp%3Bspreadsheet%20gathered%20from%20the%20Form%20and%20to%20replicate%20this%20information%20would%20be%20an%20extra%20administrative%20burden.%20I%20can%20see%20from%20the%20audit%20log%20app%40sharepoint%20is%20accessing%20the%20file%20and%20when%20I%20have%20the%20file%20open%20I%20can%20see%20SharePoint%20App%20editing%20the%20file%20so%20it%20looks%20like%20the%20connection%20still%20works%20but%20something%20is%20preventing%20the%20new%20rows%20from%20being%20written.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-287548%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-287548%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Euan%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20hope%20this%20document%20could%20help%20-%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fhow-to-get-missing-data-in-forms-9fb98299-4dcc-41a4-bb29-34a9c3daf8cc%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EHow%20to%20get%20the%20missing%20data%20in%20Forms%3C%2FA%3E.%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-287156%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-287156%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Zhongzhong%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20client%20is%20currently%20experiencing%20this%20issue%2C%20responses%20have%20stopped%20syncing%20to%20the%20Excel%20doc.%20They%20briefly%20saw%20them%20overwriting%20the%20last%20response%20but%20now%20nothing%20gets%20written.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fforms.office.com%2FPages%2FResponsePage.aspx%3Fid%3D59IL-cC1JUueJyJv-LbBe3S6AghXBodGqQG_vHb87IRUMVJRUlpKOTU3Vk9MN0VOSVVTUjREVkZYVC4u%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fforms.office.com%2FPages%2FResponsePage.aspx%3Fid%3D59IL-cC1JUueJyJv-LbBe3S6AghXBodGqQG_vHb87IRUMVJRUlpKOTU3Vk9MN0VOSVVTUjREVkZYVC4u%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-281676%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-281676%22%20slang%3D%22en-US%22%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F118803%22%20target%3D%22_blank%22%3E%40Nate%20Kennedy%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3EIf%20you%20click%20the%20export%20to%20excel%20button%20the%20link%20will%20flash%20and%20be%20redirected.%20But%20if%20you%20copy%20and%20past%20it%20then%20change%20the%20false%20at%20the%20end%20to%20a%20true%20it%20will%20open%20a%20new%20spreadsheet%20that%20will%20have%20all%20your%20data%20in%20it.%20This%20is%20the%20only%20work%20around%20I%20have%20found.%20But%20you%20will%20have%20all%20your%20data%20this%20way.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3C%2FP%3E%3CP%3Edata.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fforms.office.com%2FPages%2FRedirectToExcelPage.aspx%3Fid%3DRgHwM8xv6Um1aHiWswadRM6biPXhOnlKtde69MV1dHQUFYT1g5VzFUMjBPR0QxOUdQTi4u%26amp%3BforceReExport%3D%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fforms.office.com%2FPages%2FRedirectToExcelPage.aspx%3Fid%3DRgHwM8xv6Um1aHiWswadRM6biPXhOnlKtde69MV1dHQUFYT1g5VzFUMjBPR0QxOUdQTi4u%26amp%3BforceReExport%3D%3C%2FA%3E%3CSTRONG%3Efalse%20-%20change%20this%20false%20to%20a%20true%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps%20some%20of%20you!%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou're%20a%20genious%20!%20Thanks%20a%20lot%20!%3C%2FP%3E%3CP%3EThat%20completely%20fixed%20my%20Excel%20sheet%2C%20creating%20a%20new%20one%20which%20workd%20perfectly.%3C%2FP%3E%3CP%3ENote%20for%20others%20%3A%20the%20%22export%22%20button%20is%20on%20the%20form's%20response's%20tab.%20Be%20quick%20to%26nbsp%3Bcopy%26nbsp%3Bthe%20URL...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-266514%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266514%22%20slang%3D%22en-US%22%3E%3CP%3ETypical%20Msft%20-%20they%20can't%20even%20get%20a%20idea%20they%20copied%20from%20Google%20right.%20The%20whole%20point%20is%20to%20have%20a%20form%20that%20submits%20to%20a%20spreadsheet%20-%20Msft%20can't%20figure%20that%20out%20so%20the%20answer%20is%20to%20create%20a%20new%20spreadsheet%3F%3F%3F%20Ridiculous%20-%20please%20go%20back%20and%20see%20how%20Google%20does%20it%20and%20try%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-207133%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-207133%22%20slang%3D%22en-US%22%3E%3CP%3EZhongzhong%2C%3C%2FP%3E%3CP%3EMine%20has%20gone%20wrong%20again.%20Three%20responses%20are%20missing.%20However%2C%20I%20am%20not%20around%20for%20a%20couple%20of%20days%20so%20I'll%20private%20message%20you%20then%20and%20hopefully%20we%20can%20get%20the%20thing%20sorted%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-206528%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-206528%22%20slang%3D%22en-US%22%3E%3CP%3EYes.%3C%2FP%3E%3CP%3EMy%20principal%20checked%20and%20one%20week%20there%20were%205%20responses%20and%20the%20next%20week%20there%20were%20only%202.%3C%2FP%3E%3CP%3EWhen%20I%20generated%20the%20excel%20file%20there%20were%20still%20only%202%20responses%20showing.%3C%2FP%3E%3CP%3E-Mrs.%20Rembert%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKindergarten%20Bridges%20Form%20missing%20responses%20in%20both%20responses%20and%20excel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205986%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205986%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F151580%22%20target%3D%22_blank%22%3E%40Alan%20Cossey%3C%2FA%3E%2C%20please%20also%20be%20free%20to%20contact%20me%20directly%20when%20you%20have%20the%20ribbon%20status%20error.%3C%2FP%3E%0A%3CP%3EIt%20is%20a%20good%20opportunity%20for%20us%20to%20get%20more%20input%20from%20customer%20to%20validate%20our%20troubleshooting%20assumption.%20It%20will%20be%20more%20efficient%20than%20just%20analyzing%20service%20logs.%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-205984%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205984%22%20slang%3D%22en-US%22%3E%3CP%3EBased%20on%20your%20screenshot%2C%20your%20form%20doesn't%20have%20a%20connection%20with%20Excel%20online%20workbook.%20To%20create%20a%20form%20has%20live%20connection%2C%20you%20could%20check%20the%20document%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-Forms-Blog%2FForms-for-Excel-new-experience-for-Excel-survey-in-Office-365%2Fba-p%2F109195%22%20target%3D%22_blank%22%3Ehere%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20your%20form%2C%20every%20time%20you%20click%20on%20%22Open%20in%20Excel%22%2C%20you%20will%20receive%20a%20new%20download%20file%2C%20which%20should%20always%20contain%20the%20latest%20data.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20mean%20for%20the%20new%20download%20file%2C%20it%20also%20has%20missing%20data%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205660%22%20slang%3D%22en-US%22%3EOffice%20365%20Form%20Responses%20MISSING-Kindergarten%20Bridges%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205660%22%20slang%3D%22en-US%22%3E%3CP%3EOffice%20365%20Form%20Responses%20MISSING-Kindergarten%20Bridges%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20missing%20responses%20from%20our%20Kindergarten%20Bridges%20form.%20Is%20there%20any%20way%20to%20retrieve%20them%3F%20My%20principal%20said%20she%20saw%20about%205%20last%20week%20and%20yesterday%20there%20were%20only%202.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-Mrs.%20Rembert%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205659%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205659%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fforms.office.com%2FPages%2FDesignPage.aspx%3Forigin%3Dshell%23Analysis%3Dtrue%26amp%3BFormId%3Dqfk9CVurNE6xxHFZHTf6WeGhpJRayDNMv6sJwklSkvJURFVNSk0wMlhCRlJZTVlESUhUU0NMM0ZKSi4u%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fforms.office.com%2FPages%2FDesignPage.aspx%3Forigin%3Dshell%23Analysis%3Dtrue%26amp%3BFormId%3Dqfk9CVurNE6xxHFZHTf6WeGhpJRayDNMv6sJwklSkvJURFVNSk0wMlhCRlJZTVlESUhUU0NMM0ZKSi4u%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205657%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205657%22%20slang%3D%22en-US%22%3E%3CP%3EErin%2C%3C%2FP%3E%3CP%3EYes%2C%20that%20seems%20to%20be%20a%20hit%20and%20miss%20too%2C%20unless%20I%20have%20missed%20something.%20Sometimes%20when%20I%20open%20the%20associated%20Excel%20spreadsheet%20up%20online%20the%20items%20on%20the%20Form%20ribbon%20option%20are%20greyed%20out.%20I%20usually%20refresh%20the%20browser%20or%20re-sign%20in%20or%20something%20like%20that%20before%20it%20starts%20to%20work%20properly.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205654%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205654%22%20slang%3D%22en-US%22%3EMine%20does%20not%20look%20like%20that%3CBR%20%2F%3E%3CBR%20%2F%3EI%20do%20not%20see%20the%20%22more%20options%22%20option%20to%20sync%20all%20responses...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205653%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205653%22%20slang%3D%22en-US%22%3E%3CP%3EMine%20does%20not%20look%20like%20that%3C%2FP%3E%3CP%3EI%20do%20not%20see%20the%20%22more%20options%22%20option%20to%20sync%20all%20responses...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20624px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F36254i3FE48BF534C3903E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22screenshot.jpg%22%20title%3D%22screenshot.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205648%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205648%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Fforms.office.com%2FPages%2FDesignPage.aspx%3Forigin%3Dshell%23FormId%3Dqfk9CVurNE6xxHFZHTf6WeGhpJRayDNMv6sJwklSkvJURFVNSk0wMlhCRlJZTVlESUhUU0NMM0ZKSi4u%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fforms.office.com%2FPages%2FDesignPage.aspx%3Forigin%3Dshell%23FormId%3Dqfk9CVurNE6xxHFZHTf6WeGhpJRayDNMv6sJwklSkvJURFVNSk0wMlhCRlJZTVlESUhUU0NMM0ZKSi4u%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20very%20much!%3CBR%20%2F%3E%3CBR%20%2F%3E-Mrs.%20Rembert%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205647%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205647%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fforms.office.com%2FPages%2FDesignPage.aspx%3Forigin%3Dshell%23FormId%3Dqfk9CVurNE6xxHFZHTf6WeGhpJRayDNMv6sJwklSkvJURFVNSk0wMlhCRlJZTVlESUhUU0NMM0ZKSi4u%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fforms.office.com%2FPages%2FDesignPage.aspx%3Forigin%3Dshell%23FormId%3Dqfk9CVurNE6xxHFZHTf6WeGhpJRayDNMv6sJwklSkvJURFVNSk0wMlhCRlJZTVlESUhUU0NMM0ZKSi4u%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much!%3C%2FP%3E%3CP%3E-Mrs.%20Rembert%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205644%22%20slang%3D%22en-US%22%3EOffice%20365%20Form%20Responses%20MISSING-Kindergarten%20Bridges%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205644%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20missing%20responses%20from%20our%20Kindergarten%20Bridges%20form.%20Is%20there%20any%20way%20to%20retrieve%20them%3F%20My%20principal%20said%20she%20saw%20about%205%20last%20week%20and%20yesterday%20there%20were%20only%202.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-Mrs.%20Rembert%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205572%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205572%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20per%20my%20reply%20to%20your%20private%20message%2C%20I%20am%20very%20grateful%20for%20this%20offer%20and%20will%20contact%20you%20if%20it%20goes%20wrong%20again%20since%20I%20have%20deleted%20the%20previous%20two%20Excel%20spreadsheets%2Fform%20which%20went%20wrong.%20Currently%20things%20are%20working.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205534%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205534%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Alan%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20I%20mentioned%20before%2C%20the%20whole%20data%20sync%20pipe%20is%20built%20upon%20Microsoft%20Graph%20%2F%20Excel%20API%2C%20we%20are%20working%20closely%20with%20API%20and%20Excel%20Online%20team%20to%20improve%20the%20reliability.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20most%20of%20the%20time%2C%20we%20need%20to%20solve%20the%20specific%20error%2Fbug%20on%20reliability%20one%20by%20one%2C%20so%20if%20you%20could%20share%20your%20form%20URL%2C%20it%20will%20help%20us%20troubleshoot%2C%20and%20fix%20the%20error%20type%20you%20have%20met%20previously.%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-205530%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205530%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Alan%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%20for%20the%20late%20response.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELooks%20like%20you%20have%20met%20several%20critical%20errors%3C%2FP%3E%0A%3CP%3E1%20-%20Missing%20data%20in%20Excel%20workbook%3C%2FP%3E%0A%3CP%3E2%20-%20Forms%20settings%20(e.g.%20anyone%20with%20the%20link%20could%20response)%20takes%20hours%20to%20reflect%20on%20customer%20side%3C%2FP%3E%0A%3CP%3E3%20-%20%22Sync%20to%20new%20Excel%20workbook%22%20doesn't%20work%20well%20for%20you.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20would%20be%20great%20if%20you%20could%20share%20your%20form%20URL%20with%20us%2C%20so%20we%20could%20have%20further%20investigation.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'll%20send%20you%20a%20private%20message%20to%20have%20more%20detail%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%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205528%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205528%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Rembert%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYes%2C%20please%20try%20%22%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fhow-to-get-missing-data-in-forms-9fb98299-4dcc-41a4-bb29-34a9c3daf8cc%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESync%20to%20new%20Excel%20workbook%3C%2FA%3E%22%20to%20get%20your%20data%20into%20a%20new%20workbook.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20would%20be%20great%20if%20you%20could%20share%20your%20form%20URL%20with%20us%2C%20so%20we%20could%20troubleshoot%20the%20error%20you%20have%20met.%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-205527%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205527%22%20slang%3D%22en-US%22%3EHi%20Rachel%2C%3CBR%20%2F%3E%3CBR%20%2F%3EBased%20on%20the%20log%20we%20had%20for%20the%20URL%20you%20have%20shared%2C%20it%20shows%20your%20form%20hasn't%20connected%20with%20an%20Excel%20Online%20file%2C%20it%20is%20a%20standard%20form%20with%20%22Download%20Excel%22.%20%3CBR%20%2F%3E%3CBR%20%2F%3ECould%20you%20share%20me%20the%20actual%20error%20you%20have%20received%3F%3CBR%20%2F%3E%3CBR%20%2F%3ERegards%2C%3CBR%20%2F%3EZhongzhong%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205261%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205261%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3BZhongzhong%20Li%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20currently%20not%20able%20to%20view%20all%20of%20the%20responses%20to%20our%20form%20in%20Excel%2C%20could%20you%20please%20advise%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fforms.office.com%2FPages%2FDesignPage.aspx%23FormId%3DBFw1HqTg7UKOLXNRWR8O8UP_4VezT1RCnL7dHhiKgnVUNlBOOFFSVUkxVkZTNkw5TE9PNVdYRFhJNC4u%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fforms.office.com%2FPages%2FDesignPage.aspx%23FormId%3DBFw1HqTg7UKOLXNRWR8O8UP_4VezT1RCnL7dHhiKgnVUNlBOOFFSVUkxVkZTNkw5TE9PNVdYRFhJNC4u%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20if%20you%20need%20any%20further%20information%20for%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ERachel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205252%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205252%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20Mrs.%20R%2C%3C%2FP%3E%3CP%3EUntil%20Microsoft%20get%20their%20act%20together%20and%20stop%20this%20happening%20you%20will%20need%20to%20use%20the%20work%20around%20at%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%3Ehttps%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%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBeen%20there%2C%20done%20that%2C%20twice%2C%20expect%20to%20need%20to%20do%20it%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlan%20Cossey%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205248%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205248%22%20slang%3D%22en-US%22%3E%3CP%3EJune%2018%2C%202018%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20Morning%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20form%20that%20I%20set%20up%20for%20our%20annual%20Kindergarten%20Bridges%20program%20is%20missing%20responses.%20According%20to%20my%20principal%20last%20week%20there%20were%205%20responses%20and%20today%20there%20are%20only%202.%20Where%20did%20the%20responses%20go%20and%20how%20do%20we%20retrieve%20them%20if%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESincerely%2C%3C%2FP%3E%3CP%3EMrs.%20R.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205247%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205247%22%20slang%3D%22en-US%22%3E%3CP%3EJune%2018%2C%202018%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20Morning%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20form%20that%20I%20set%20up%20for%20our%20annual%20Kindergarten%20Bridges%20program%20is%20missing%20responses.%20According%20to%20my%20principal%20last%20week%20there%20were%205%20responses%20and%20today%20there%20are%20only%202.%20Where%20did%20the%20responses%20go%20and%20how%20do%20we%20retrieve%20them%20if%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESincerely%2C%3C%2FP%3E%3CP%3EMrs.%20R.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205241%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205241%22%20slang%3D%22en-US%22%3E%3CP%3EJune%2018%2C%202018%209%3A26%20am%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20Morning%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20set%20up%20a%20form%20to%20collect%20information%20for%20the%20annual%20K%20bridges%20program%20at%20our%20school.%20My%20principal%20says%20that%20last%20week%20she%20saw%205%20responses%20and%20today%20she%20only%20sees%202.%20Where%20did%20the%20other%20responses%20go%20and%20how%20do%20we%20retrieve%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESincerely%2C%3C%2FP%3E%3CP%3EMrs.%20R.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-203115%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-203115%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Microsoft%2C%3C%2FP%3E%3CP%3EWhen%20are%20you%20going%20to%20sort%20this%20out%2C%20please%3F%20I%20am%20again%20missing%20at%20least%20one%20response%20from%20my%20Excel%20spreadsheet.%20I%20know%20this%20because%20I%20demonstrated%20to%20someone%20how%20to%20use%20the%20Excel%20form.%20They%20got%20an%20acknowledgement%20of%20their%20input%20and%20when%20I%20got%20into%20Edit%20Form%20--%26gt%3B%20Responses%20I%20can%20see%20the%20item%20I%20added%2C%20but%20when%20I%20click%20on%20%22Open%20in%20Excel%22%20the%20spreadsheet%20opens%20in%20Excel%20Online%20missing%20that%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20a%20mess.%20Please%20sort%20it%20out%20so%20it%20works%20properly.%20Your%20post%20says%2C%20%22%3CSPAN%3EOn%20occasion%2C%20the%20workbook%20may%20not%20contain%20the%20latest%20data%20for%20a%20number%20of%20reasons.%3C%2FSPAN%3E%22%20It's%20time%20to%20sort%20those%20reason%20out%2C%20don't%20you%20think%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-200188%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-200188%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20recreated%20everything%20from%20scratch%20and%20it%20seems%20to%20be%20working.%20However%2C%20there%20are%20a%20couple%20of%20dodgy%20things%20about%20this%3A%3CBR%20%2F%3E1)%20The%20Forms%20icon%20on%20the%20Excel%20online%20spreadsheet%20can%20take%20several%20minutes%20to%20become%20enabled.%3C%2FP%3E%3CP%3E2)%20When%20I%20make%20changes%2C%20e.g.%20to%20allow%20people%20outside%20my%20organisation%20to%20be%20able%20to%20fill%20in%20the%20forms%2C%20it%20can%20take%20hours%20before%20some%20people%20on%20the%20web%20can%20use%20the%20updated%20version.%20For%20example%2C%20I%20made%20that%20change%20to%20my%20form%20about%203%20hours%20ago%20and%20one%20user%20down%20the%20road%20from%20me%20is%20still%20being%20asked%20to%20log%20in.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-198889%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-198889%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20a%20mess!%20What%20a%20complete%20mess!%20My%20original%20Excel%20spreadsheet%20was%20missing%20lots%20of%20responses%20(blank%20lines%20appeared%20in%20the%20spreadsheet%20where%20the%20responses%20should%20have%20been).%20So%20I%20followed%20the%20recommendation%20to%20synchronise%20to%20a%20new%20spreadsheet.%20Hooray%2C%20I%20could%20see%20(all%3F)%20the%20missing%20responses.%20However%2C%20I%20needed%20to%20open%20the%20spreadsheet%20in%20Excel%202016%2C%20but%20it%20refused%20to%20open.%20The%20path%20in%20the%20SharePoint%20document%20library%20was%20already%20fairly%20long%20and%20the%20new%20name%20automatically%20added%20for%20the%20new%20spreadsheet%20was%20really%20long%20as%20well.%20So%20I%20tried%20renaming%20the%20SharePoint%20folder%2C%20but%20that%20didn't%20change%20anything.%20Next%20attempt%20was%20to%20create%20a%20new%20SharePoint%20folder%20with%20a%20much%20shorter%20name%20and%20move%20all%20my%20files%20to%20that%20and%20sync%20it.%3CBR%20%2F%3EGreat%20I%20can%20now%20open%20the%20original%20forms%20spreadsheet%20(with%20its%20missing%20responses)%26nbsp%3Bbut%20I%20can't%20edit%20the%20form.%20Brilliant%2C%20just%20what%20I%20needed%20(not).%20All%20I%20get%20is%20the%20option%20to%20create%20a%20new%20form.%20I%20can%20still%20get%20to%20use%20the%20old%20form%20but%20the%20responses%20don't%20seem%20to%20get%20recorded%20anywhere.%20In%20the%20new%20spreadsheet%20(created%20by%20syncing%20to%20a%20new%20spreadsheet)%20I%20can%20see%20the%20data%20but%20all%20the%20Forms%20options%20are%20greyed%20out.%3CBR%20%2F%3ERight%2C%20so%20let's%20recreate%20everything%20from%20scratch.%20I've%20got%20nothing%20else%20I%20want%20to%20do%20with%20my%20life%2C%20after%20all.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-198865%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-198865%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20getting%20the%20same%20problem%20(30th%20May%202018).%20I%20was%20getting%20blank%20lines%20appear%20in%20Excel%20Online%20and%20have%20been%20deleting%20them.%20Users%20have%20now%20been%20telling%20me%20that%20they%20have%20been%20entering%20data%20on%20Microsoft%20Forms%2C%20but%20I%20thought%20they%20had%20done%20something%20daft%20like%20not%20pressing%20the%20Submit%20button.%20However%2C%20in%20forms%20responses%20I%20can%20now%20see%20they%20have%20indeed%20been%20entering%20data%2C%20but%20Forms%20%2F%20Excel%20Online%20have%20been%20messing%20things%20up.%20What%20a%20mess!%3C%2FP%3E%3CP%3ENote%20that%20I%20have%20Synced%20the%20Document%20Library%20used%20by%20the%20spreadsheet%2Fform%20to%20my%20hard%20drive%20as%20I%20link%20to%20it%20as%20a%20read-only%20linked%20table%20in%20Microsoft%20Access.%3C%2FP%3E%3CP%3EI%20see%20this%20has%20now%20been%20going%20on%20for%208%20months.%20Come%20on%20Microsoft.%20Pull%20your%20finger%20out!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-188023%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-188023%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Forms%20customers%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EForms%20for%20Excel%20contains%20a%20live%20data%20connection%20to%20your%20form.%20Any%20new%20response%20data%20will%20be%20stored%20in%20your%20form%2C%20and%20also%20be%20reflected%20in%20your%20workbook.%20On%20occasion%2C%20the%20workbook%20may%20not%20contain%20the%20latest%20data%20for%20a%20number%20of%20reasons.%3C%2FP%3E%0A%3CP%3EIf%20this%20is%20the%20case%2C%20Forms%20provides%20a%20new%20feature%2C%20%22%3CSTRONG%3ESync%20all%20responses%20to%20a%20new%20workbook%3C%2FSTRONG%3E%22%2C%20in%20order%20to%20%E2%80%9Csync%E2%80%9D%20your%20most%20recent%20responses%20to%20a%20new%20workbook.%20This%20new%20workbook%20will%20be%20stored%20next%20to%20your%20original%20workbook%20on%20OneDrive%20for%20Business%20or%20SharePoint%20Online.%20This%20will%20ensure%20your%20data%20is%20up%20to%20date.%20Learn%20more%20about%20%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%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F33141i86FA89684DBFAA15%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20alt%3D%22Sync%20all%20responses%20to%20a%20new%20workbook.png%22%20title%3D%22Sync%20all%20responses%20to%20a%20new%20workbook.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERegards%2C%3C%2FP%3E%0A%3CP%3EZhongzhong%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-186966%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-186966%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdmgmori-my.sharepoint.com%2F%3Ax%3A%2Fr%2Fpersonal%2Fgowen_dmgmori-usa_com%2F_layouts%2F15%2FWopiFrame.aspx%3Fsourcedoc%3D%257B6941BAAC-DEF9-4E11-B249-E5B7C30F0FE6%257D%26amp%3Bfile%3DBielefeld_%2520%2520CTX%2520310%2520etc.%2520CTV%2C%2520CTX%2520Alpha%2C%2520Beta%2C%2520Gamma%2C%2520TC%2520%2526%25204A.%2520%2520(All%2520versions)1%2520-%2520Master.xlsx%26amp%3Baction%3Dedit%26amp%3Bd%3Dw6941baacdef94e11b249e5b7c30f0fe6%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdmgmori-my.sharepoint.com%2F%3Ax%3A%2Fr%2Fpersonal%2Fgowen_dmgmori-usa_com%2F_layouts%2F15%2FWopiFrame.aspx%3Fsourcedoc%3D%257B6941BAAC-DEF9-4E11-B249-E5B7C30F0FE6%257D%26amp%3Bfile%3DBielefeld_%2520%2520CTX%2520310%2520etc.%2520CTV%2C%2520CTX%2520Alpha%2C%2520Beta%2C%2520Gamma%2C%2520TC%2520%2526%25204A.%2520%2520(All%2520versions)1%2520-%2520Master.xlsx%26amp%3Baction%3Dedit%26amp%3Bd%3Dw6941baacdef94e11b249e5b7c30f0fe6%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-186961%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-186961%22%20slang%3D%22en-US%22%3E%3CP%3ESir%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20same%20problem%20with%20missing%20data%20in%20Microsoft%20forms.%26nbsp%3B%20I%20created%20a%20form%20and%20have%20received%20188%20responses%2C%20but%20only%20have%20114%20responses%20in%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20responses%20between%2004%2F09%2F2018%20and%2004%2F23%2F2018%20are%20not%20in%20the%20excel%20file.%26nbsp%3B%20I%20have%20tried%20adding%20%3DTRUE%20to%20the%20URL%20bot%20doesn't%20change.%26nbsp%3B%20Please%20advise.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-181480%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-181480%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%2C%20I'm%20experiencing%20the%20same%20issue.%20Could%20you%20please%20help%3F%20I've%20sent%20the%20URL%20to%20your%20message.%20Our%20staffs%20are%20responding%20to%20our%20forms%2C%20but%20we%20only%26nbsp%3Bsee%20some%20empty%20rows%20in%20excel.%20We%20need%20it%20immediately%20as%20we%20use%20the%20forms%20heavily%20to%20do%20our%20operational%20wors.%20Please%20kindly%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EEsther%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-178219%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-178219%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%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%20I%20sent%20you%20a%20private%20message%20regarding%20a%20similar%20problem%2C%20can%20you%20please%20check%20your%20messages%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-177151%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-177151%22%20slang%3D%22en-US%22%3EThis%20still%20seems%20to%20be%20broken.%20I%20have%20created%20a%20new%20Form%20for%20Excel%20within%20OneDrive%2C%20and%20when%20I%20open%20the%20Excel%20once%20responses%20have%20been%20gathered%20it's%20just%20a%20blank%20file%20with%20no%20data.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-173528%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-173528%22%20slang%3D%22en-US%22%3E%3CP%3EHey!%3CBR%20%2F%3E%3CBR%20%2F%3EI've%20created%20a%20form%20that%20had%204%20questions.%20The%20form%20was%20used%20by%20us%20to%20gather%20data%20in%20a%20bounty%20program%2C%20when%20we%20saw%20that%20we%20already%20had%20over%2010000%20completions%2C%20we%20decided%20that%20we%20needn't%20more%20so%20we%20changed%20the%20intro%20text%20of%20the%20form%20to%20inform%20them%20that%20the%20bounty%20is%20over.%26nbsp%3B%20Then%20we%20thought%20that%20we%20should%20delete%20the%20questions%20because%20we%20didn't%20want%20people%20to%20fill%20in%20more%20data.%20We%20did%20not%20download%20the%20CSV%20before%20deleting%20the%20questions%20and%20when%20we%20downloaded%20the%20CSV%20it%20was%20filled%20with%2010000%20%2B%20empty%20responses.%20The%20problem%20seems%20to%20be%20that%20if%20you%20delete%20a%20question%20it%20wil%20automatically%20delete%20the%20column%20from%20the%20csv%20that%20powers%20forms.%20Of%20course%20we%20did%20not%20know%20this%20and%20couldn't%20guess%20that%20it%20would%20delete%20even%20all%20the%20previous%20responses.%20So%20I%20think%20we%20need%20a%20previous%20version%20of%20the%20csv%2C%20before%20deleting%20the%20questions.%3CBR%20%2F%3EThe%20form%20was%20exclusively%20handlet%20through%20forms.office.com.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-170562%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-170562%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20having%20a%20related%20issue%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20was%20working%20on%20a%20type%20of%20rudimentary%20ticketing%20system%20in%20which%20clients%20fill%20out%20the%20form%20and%20then%20our%20team%20can%20update%20status%20on%20the%20back%20end.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEverything%20was%20working%20fine%20until%20I%20added%20our%20backend%20columns%20to%20assign%20and%20track.%26nbsp%3B%20Now%20it%20is%20no%20longer%20updating%20with%20new%20form%20submissions.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'm%20guessing%20it%20is%20some%20sort%20of%20mapping%20issue%20but%20I%20can't%20find%20where%20I%20can%20fix%20it%20and%20there's%20little%20to%20no%20documentation%20or%20support...%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUPDATE%3A%26nbsp%3B%20Apparently%20it%20didn't%20break%20them%20but%20added%20them%20to%20row%26nbsp%3B1000%2B%26nbsp%3B%20...%20no%20clue%20why%20and%20probably%20randomly%20making%20me%20file%20ginormous.%20but%20at%20least%20it%20still%20works...%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-168823%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-168823%22%20slang%3D%22en-US%22%3EPretty%20funny%20to%20see%20community%20members%20explaining%20the%20fix%20to%20the%20Microsoft%20team!%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20for%20this%20-%20worked%20fine%20for%20me!!!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-167991%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-167991%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20url%20flashes%20briefly%20before%20opening%20in%20excel.%20So%2C%20you'll%20need%20to%20catch%20it%20at%20the%20right%20time.%20In%20other%20words%20click%20the%20open%20in%20excel%20button%20then%20watch%20the%20url%20box%20for%20the%20link.%20You%20will%20see%20an%20%3Dfalse%20at%20the%20end%2C%20change%20that%20to%20an%20%3Dtrue.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-167870%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-167870%22%20slang%3D%22en-US%22%3EThanks%20for%20the%20update.%20Is%20there%20an%20ETA%20on%20the%20official%20fix%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-167807%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-167807%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20false%20%2F%20true%20trick%20is%20not%20the%20official%20solution.%26nbsp%3B%20Once%20you%20try%20that%20URL%2C%20your%20form%20will%20disconnected%20with%20the%20original%20workbook%2C%20and%20generate%20a%20new%20workbook.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20cannot%20move%20the%20connection%20back%20to%20the%20original%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-167802%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-167802%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%26nbsp%3Bimproved%20the%20reliability%20and%20performance%20for%20the%20data%20sync%20service%20based%20on%20the%20error%20cases%20people%20reported%20here.%3C%2FP%3E%0A%3CP%3EAt%20the%20same%20time%2C%20we%20are%20working%20on%20an%20official%20solution%20to%20help%20people%20generate%20a%20new%20live-synced%20workbook%20with%20Forms%20UI.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-167424%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-167424%22%20slang%3D%22en-US%22%3EHi%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20true%2Ffalse%20technique%20worked%20for%20me%20but%20is%20it%20a%20permanent%20fix%20or%20will%20every%20user%20who%20needs%20to%20view%20the%20form%20sheet%20have%20to%20do%20this%20every%20time%20the%20select%20the%20%22open%20in%20excel%22%20option%3F%20The%20staff%20will%20not%20have%20that%20level%20of%20techspertise.%3CBR%20%2F%3E%3CBR%20%2F%3ERobbie%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-167417%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-167417%22%20slang%3D%22en-US%22%3EHi%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20true%2Ffalse%20technique%20worked%20for%20me%20but%20is%20it%20a%20permanent%20fix%20or%20will%20every%20user%20who%20needs%20to%20view%20the%20form%20sheet%20have%20to%20do%20this%20every%20time%20the%20select%20the%20%22open%20in%20excel%22%20option%3F%20The%20staff%20will%20not%20have%20that%20level%20of%20techspertise.%3CBR%20%2F%3E%3CBR%20%2F%3ERobbie%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-167195%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-167195%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20also%20sent%20you%20a%20Form%20link%20that%20has%20the%20same%20issue%2C%20please%20help%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-166924%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-166924%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%26nbsp%3B%20I%20am%20having%20a%20similar%20issue%20to%20that%20described%20above.%26nbsp%3B%20We%20have%20an%20online%20form%20at%20work%20that%20I%20created%20and%20it%20has%20been%20working%20perfectly%20until%20today.%26nbsp%3B%20New%20responses%20to%20the%20form%20are%20in%20the%20Form%20Response%20tab%2C%20but%20they%20are%20not%20showing%20up%20in%20the%20online%20Excel%20document%20as%20before.%26nbsp%3B%20We%20did%20not%20change%20anything%2C%20it%20just%20stopped%20working.%26nbsp%3B%20I%20would%20really%20appreciate%20someone's%20help%20in%20getting%20this%20working.%26nbsp%3B%20I%20looked%20at%20the%20tip%20to%20change%20the%20%22false%22%20and%20%22true%22%20after%20clicking%20the%20Open%20in%20Excel%20button%2C%20but%20I%20do%20not%20see%20a%20false%20or%20true%20in%20the%20URL.%26nbsp%3B%20It%20just%20opens%20it%20in%20Excel%20automatically.%26nbsp%3B%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-166840%22%20slang%3D%22en-US%22%3ERE%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-166840%22%20slang%3D%22en-US%22%3EHi%2C%20I'm%20having%20the%20same%20problem.%20My%20form%20populated%20the%20Excel%20database%20(in%20OneDrive)%20for%20the%20first%2016%20responses.%20I%20tried%20copying%20the%20data%20from%20OneDrive%20and%20something%20must%20have%20happened%20to%20the%20connection.%20I%20can%20see%20new%20responses%20in%20the%20form%2C%20but%20not%20in%20the%20Excel%20sheet.%20I%20urgently%20need%20to%20be%20able%20to%20fix%20this.%20Thanks!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-166810%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-166810%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3EPlease%20could%20you%20fix%20my%20form%20to%20feed%20the%20responses%20in%20to%20original%20spreadsheet.%20I%20have%20tried%20false%20to%20true%20fix%20-%20it%20fixed%20it%20so%20I%20can%20see%20the%20responses%20but%20in%20a%20new%20spreadsheet.%20I%20need%20it%20to%20be%20in%20the%20original%20spreadsheet%20as%20I%20have%20some%20additional%20columns%20and%20other%20related%20tabs%20in%20that%20excel%20spreadsheet.%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fforms.office.com%2FPages%2FResponsePage.aspx%3Fid%3Dq_b8cH6FEEq1KwTd7ZvwrwRG-s_xowZBmUoh2V1YgTdUNVZDNUlFRFlSTjZCRkVURzFFNUFSOVhSMyQlQCN0PWcu%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fforms.office.com%2FPages%2FResponsePage.aspx%3Fid%3Dq_b8cH6FEEq1KwTd7ZvwrwRG-s_xowZBmUoh2V1YgTdUNVZDNUlFRFlSTjZCRkVURzFFNUFSOVhSMyQlQCN0PWcu%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EThanks%20a%20lot%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-166629%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-166629%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20you%20are%20right.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EData%20has%20been%20stored%20in%20Forms%2C%20and%20we%20sync%20the%20data%20into%20Excel%20workbook%20via%20Microsoft%20Graph%20%2F%20Excel%20REST%20API.%20I'm%20sorry%20for%20the%20error%20you%20have%20met%2C%20but%20we%20are%20actively%20working%20on%20the%20improvement%20with%20several%20partner%20teams.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBased%20on%20our%20design%2C%20customer%20could%20use%20all%20Excel%20features%20to%20analysis%20data%20in%20the%20workbook%20(e.g.%20formula%2C%20sort%20and%20filtering).%20Please%20be%20free%20to%20let%20us%20know%20if%20you%20find%20conflict%20between%20Forms%20data%20and%20Excel%20features.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-166626%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-166626%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F123781%22%20target%3D%22_blank%22%3E%40Justin%20Philip%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20could%20try%20the%20trick%20of%20change%20%22false%22%20to%20%22true%22%2C%20it%20may%20solve%20your%20problem%2C%20but%20not%20always.%20That's%20why%20we%20didn't%20provide%20it%20as%20a%20official%20solution.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EActually%20we%20have%20a%20data%20sync%26nbsp%3Bservice%20to%20make%20sure%20all%20of%20your%20responses%20get%20into%20the%20Excel%20workbook%20in%20real%20time.%20There%20may%20be%20random%20failure%20that%20the%20data%20sync%20action%20get%20failed%2C%20so%20we%20built%20up%20a%20retry%20system%20to%20redo%20the%20sync%20in%20every%20hours.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20your%20workbook%20met%20a%20fatal%20error%20after%20editing%20the%20workbook%2C%20which%20cannot%20be%20resolved%20by%20%22retry%22%2C%20I%20will%20suggest%20to%20send%20the%20form%20URL%20for%20me.%20We%20will%20investigate%20the%20root%20cause%20and%20fix%20the%20problem%20on%20server%20side.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBefore%20we%20fix%20the%20root%20cause%2C%20even%20you%20get%20a%20new%20workbook%20with%20the%20%22true%20of%20false%22%20trick%2C%20you%20has%20high%20risk%20to%20meet%20the%20same%20error%20again.%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-166532%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-166532%22%20slang%3D%22en-US%22%3EGuess%20I%20spoke%20too%20soon.%20D'oh!%20It%20works%20for%20my%20simple%20text-only%20form%2C%20but%20for%20formulas%20I%20guess%20that%20changes%20things.%20It's%20very%20strange%20that%20the%20data%20isn't%20instantly%20in%20the%20spreadsheet%20yet%20it's%20in%20the%20'Responses'%20tab%20of%20the%20Form.%20It%20seems%20to%20work%20different%20than%20the%20old%20'Excel%20surveys'%20where%20the%20data%20was%20stored%20instantly%20in%20the%20form%2C%20but%20now%20it%20seems%20to%20be%20stored%20separately%20and%20then%20synced%20down%20(very%20slowly%20or%20not%20at%20all%20unfortunately).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-166518%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-166518%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20does%20not%20work%20if%20you%20need%20to%20add%20formulas.%20For%20example%2C%20I%20need%20to%20know%20how%20long%20the%20form%20takes%20to%20complete%20and%20must%20add%20a%20column%26nbsp%3Bwith%20a%20formula%20for%26nbsp%3Btime%20ended%20-%20time%20started.%20Any%20columns%20you%20have%20created%20do%20not%20come%20up%20when%20simply%20changing%20false%20to%20true%2C%20like%20they%20come%20up%20in%20onedrive%20when%20this%20is%20working%20the%20way%20it%20is%20supposed%20to.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-166516%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-166516%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20resolved%20it%20for%20me%20perfectly!!!!%3C%2FP%3E%0A%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%20-%20please%20have%20the%20engineers%20update%20the%20%22Open%20in%20Excel'%20link%26nbsp%3Bfrom%20'false'%20to%20'true'.%26nbsp%3B%20This%20worked%20for%20me!%20%26nbsp%3B%20However%2C%20when%20i%20open%20the%20excel%20file%20directly%20from%20OneDrive%2C%20the%20excel%20is%20strangely%20not%20updated.%26nbsp%3B%20It%20only%20works%20when%20I%20go%20to%20that%20URL%20directly%20(with%20'true'%20at%20the%20end%20of%20the%20URL)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-166017%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-166017%22%20slang%3D%22en-US%22%3EThanks%2C%20I%20have%20sent%20it%20our%20engineer.%3CBR%20%2F%3E%3CBR%20%2F%3ERegards%2C%3CBR%20%2F%3EZhongzhong%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-165955%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-165955%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20am%20having%20the%20same%20issue.%20Here%20is%20my%20link%20to%20the%20form%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fforms.office.com%2FPages%2FResponsePage.aspx%3Fid%3DNj4mDgk0IkaKyBjZk-dutgfVNnF7wAJGuxvgsdc0aodUODJTTkVTVTRVVjBSVzNFSlBLQTFSOVdPWS4u%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fforms.office.com%2FPages%2FResponsePage.aspx%3Fid%3DNj4mDgk0IkaKyBjZk-dutgfVNnF7wAJGuxvgsdc0aodUODJTTkVTVTRVVjBSVzNFSlBLQTFSOVdPWS4u%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-165899%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-165899%22%20slang%3D%22en-US%22%3EI%20don't%20have%20the%20export%20to%20excel%20option%20as%20the%20form%20was%20created%20within%20excel%20so%20it%20could%20be%20shared%20with%20staff%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-165861%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-165861%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20click%20the%20export%20to%20excel%20button%20the%20link%20will%20flash%20and%20be%20redirected.%20But%20if%20you%20copy%20and%20past%20it%20then%20change%20the%20false%20at%20the%20end%20to%20a%20true%20it%20will%20open%20a%20new%20spreadsheet%20that%20will%20have%20all%20your%20data%20in%20it.%20This%20is%20the%20only%20work%20around%20I%20have%20found.%20But%20you%20will%20have%20all%20your%20data%20this%20way.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExample%3C%2FP%3E%0A%3CP%3Edata.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fforms.office.com%2FPages%2FRedirectToExcelPage.aspx%3Fid%3DRgHwM8xv6Um1aHiWswadRM6biPXhOnlKtde69MV1dHQUFYT1g5VzFUMjBPR0QxOUdQTi4u%26amp%3BforceReExport%3D%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fforms.office.com%2FPages%2FRedirectToExcelPage.aspx%3Fid%3DRgHwM8xv6Um1aHiWswadRM6biPXhOnlKtde69MV1d...%3C%2FA%3E%3CSTRONG%3Efalse%20-%20change%20this%20false%20to%20a%20true%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-165549%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-165549%22%20slang%3D%22en-US%22%3E%3CP%3EJust%20ran%20into%20this%20problem%20last%20week%20and%20now%20again%20today.%20I%20have%204%20broken%20Forms%20I'm%20using%20for%20student%20assessments.%26nbsp%3B%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%2C%20I%20pm'd%20you%20with%20the%20URLs%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-164038%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-164038%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Robert%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20mind%20to%20send%20out%20your%20form%20URL%20to%20me%20with%20private%20message%3F%3C%2FP%3E%0A%3CP%3EI%20could%20connect%20with%20engineering%20team%20to%20investigate.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERegards%2C%3CBR%20%2F%3EZhongzhong%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-163999%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-163999%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20similar%20issue%20with%20my%20form.%20It%20was%20set%20up%20for%20teachers%20to%20register%20students%20on%20detention.%20The%20idea%20being%20that%20the%20supervising%20teacher%20on%20detention%20can%20open%20the%20excel%20sheet%20from%20the%20form%20to%20take%20attendance%20in%20the%20next%20column%20with%20a%20simple%20X%20or%20I.%20However%2C%20for%20the%20past%20while%2C%20the%20excel%20document%20has%20not%20been%20updating.%20The%20form%20has%20193%20responses%20but%20only%20128%20appear%20in%20the%20spreadsheet.%20It%20seems%20that%20every%20new%20entry%20is%20recorded%20in%20the%20form%20but%20overwrites%20the%20previous%20entry%20in%20the%20spreadsheet%20so%20that%20the%20spreadsheet%20never%20fills%20past%20row%20129.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20have%20tried%20removing%20the%20filters%20but%20that%20has%20not%20helped.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAny%2Fall%20help%20appreciated%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERobbie%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-163623%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-163623%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20this%20solved%20it%20for%20me%2C%20it%20now%20created%20a%20new%20One%20Drive%20Excel%20file%20with%20all%20data.%3C%2FP%3E%0A%3CP%3EThank%20you%20so%20much!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F118803%22%20target%3D%22_blank%22%3E%40Nate%20Kennedy%3C%2FA%3E%20wrote%3A%3CBR%20%2F%3E%3CP%3EIf%20you%20click%20the%20export%20to%20excel%20button%20the%20link%20will%20flash%20and%20be%20redirected.%20But%20if%20you%20copy%20and%20past%20it%20then%20change%20the%20false%20at%20the%20end%20to%20a%20true%20it%20will%20open%20a%20new%20spreadsheet%20that%20will%20have%20all%20your%20data%20in%20it.%20This%20is%20the%20only%20work%20around%20I%20have%20found.%20But%20you%20will%20have%20all%20your%20data%20this%20way.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExample%3C%2FP%3E%0A%3CP%3Edata.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fforms.office.com%2FPages%2FRedirectToExcelPage.aspx%3Fid%3DRgHwM8xv6Um1aHiWswadRM6biPXhOnlKtde69MV1dHQUFYT1g5VzFUMjBPR0QxOUdQTi4u%26amp%3BforceReExport%3D%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fforms.office.com%2FPages%2FRedirectToExcelPage.aspx%3Fid%3DRgHwM8xv6Um1aHiWswadRM6biPXhOnlKtde69MV1dHQUFYT1g5VzFUMjBPR0QxOUdQTi4u%26amp%3BforceReExport%3D%3C%2FA%3E%3CSTRONG%3Efalse%20-%20change%20this%20false%20to%20a%20true%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20hope%20this%20helps%20some%20of%20you!%3C%2FP%3E%0A%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-161054%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-161054%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20click%20the%20export%20to%20excel%20button%20the%20link%20will%20flash%20and%20be%20redirected.%20But%20if%20you%20copy%20and%20past%20it%20then%20change%20the%20false%20at%20the%20end%20to%20a%20true%20it%20will%20open%20a%20new%20spreadsheet%20that%20will%20have%20all%20your%20data%20in%20it.%20This%20is%20the%20only%20work%20around%20I%20have%20found.%20But%20you%20will%20have%20all%20your%20data%20this%20way.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExample%3C%2FP%3E%0A%3CP%3Edata.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fforms.office.com%2FPages%2FRedirectToExcelPage.aspx%3Fid%3DRgHwM8xv6Um1aHiWswadRM6biPXhOnlKtde69MV1dHQUFYT1g5VzFUMjBPR0QxOUdQTi4u%26amp%3BforceReExport%3D%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fforms.office.com%2FPages%2FRedirectToExcelPage.aspx%3Fid%3DRgHwM8xv6Um1aHiWswadRM6biPXhOnlKtde69MV1dHQUFYT1g5VzFUMjBPR0QxOUdQTi4u%26amp%3BforceReExport%3D%3C%2FA%3E%3CSTRONG%3Efalse%20-%20change%20this%20false%20to%20a%20true%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20hope%20this%20helps%20some%20of%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-160283%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-160283%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F119560%22%20target%3D%22_blank%22%3E%40Emanuel%20Foglander%3C%2FA%3E%2C%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F118529%22%20target%3D%22_blank%22%3E%40Maria%20Kilgore%3C%2FA%3E%2C%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F118803%22%20target%3D%22_blank%22%3E%40Nate%20Kennedy%3C%2FA%3E%2C%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F118625%22%20target%3D%22_blank%22%3E%40Timothy%20Denton%3C%2FA%3E%2C%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F118405%22%20target%3D%22_blank%22%3E%40Erik%20Michael%3C%2FA%3E%26nbsp%3Band%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F117950%22%20target%3D%22_blank%22%3E%40Evan%20Raiewski%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%20for%20reaching%20out%20and%20sorry%20for%20the%20error%20for%20your%20Forms%20and%20Excel%20workbook.%3C%2FP%3E%0A%3CP%3EDo%20you%20mind%20to%20send%20me%20a%20private%20mail%20with%20your%20form%20URL%2C%20so%20I%20could%20ask%20our%20engineers%20to%20follow%20up%3F%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-159929%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-159929%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20experiencing%20the%20same%20Issue%2C%20it%20seems%20like%20a%20specific%20Form%20is%20linked%20to%20a%20specific%20Excel%20sheet%20and%20if%20you%20change%20anything%20manually%20in%20the%20Excel%20sheet%20it%20might%20break%20the%20possibility%20for%20the%20Form%20application%20to%20save%20any%20data%20in%20the%20Excel%20sheet.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20expected%20it%20to%20create%20a%20new%20Excel%20sheet%20if%20it%20cant%20save%20or%20find%20the%20original%20Excel%20sheet.%20But%20that's%20not%20the%20case%20but%20should%20solve%20the%20issue%20for%20most%20of%20us.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-158896%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-158896%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20am%20experiencing%20the%20same%20issues%2C%20where%20I%20open%20the%20the%20Excel%20spreadsheet%20through%20Forms%20%22Open%20in%20Excel%22%20and%20am%20missing%20responses.%20Is%20this%20a%20system%20wide%20issue%2C%20and%20is%20there%20a%20solution%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-158553%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-158553%22%20slang%3D%22en-US%22%3EI'm%20having%20the%20same%20problem%2C%20I%20have%20a%20form%20that%20I%20made%20in%20excel%20online%20and%20some%20of%20the%20responses%20are%20missing.%20This%20is%20a%20rather%20large%20survey%20that%20will%20go%20out%20to%20around%201300%20people.%20I'm%20missing%20about%2050%20out%20of%20312%20right%20now.%20Please%20advise%20I%20would%20like%20to%20get%20this%20fixed%20soon.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-158519%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-158519%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20having%20the%20same%20problem%2C%20I%20have%20a%20form%20that%20I%20made%20in%20excel%20online%20and%20some%20of%20the%20responses%20are%20missing.%20This%20is%20a%20rather%20large%20survey%20that%20will%20go%20out%20to%20around%201300%20people.%20I'm%20missing%20about%2050%20out%20of%20312%20right%20now.%20Please%20advise%20I%20would%20like%20to%20get%20this%20fixed%20soon.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-158334%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-158334%22%20slang%3D%22en-US%22%3EPlease%20help%2C%20exact%20same%20issue%20with%20responses%20seen%20in%20forms%20but%20not%20in%20excel%20online%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-158239%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-158239%22%20slang%3D%22en-US%22%3EI%20am%20experiencing%20the%20same%20issues%2C%20where%20I%20open%20the%20the%20Excel%20spreadsheet%20through%20Forms%20%22Open%20in%20Excel%22%20and%20am%20missing%20responses.%20Is%20this%20a%20system%20wide%20issue%2C%20and%20is%20there%20a%20solution%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-157256%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-157256%22%20slang%3D%22en-US%22%3E%3CP%3EHaving%20this%20issue%20as%20well.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-155747%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-155747%22%20slang%3D%22en-US%22%3E%3CP%3EHaving%20the%20same%20problem%2C%20forms%20was%20working%20fine%20last%20week%2C%20now%20it%20will%20not%20update%20my%20excel%20file%20in%20onedrive.%20Created%20excel%20survey%20in%20from%20onedrive%20menu.%20Please%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-154588%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-154588%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Steve%2C%3C%2FP%3E%0A%3CP%3ECould%20you%20send%20me%20a%20private%20message%20with%20your%20Forms'%20URL%3F%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-153854%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-153854%22%20slang%3D%22en-US%22%3E%3CP%3ESame%20here.%20Removed%20all%20the%20filters%20still%20no%20data.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20would%20be%20a%20great%20help%20to%20solve%20this%20issue.%20I%20need%20the%20data%20in%20other%20applications.%20The%20whole%20idea%20of%20using%20Forms%20from%20Excel%20is%20to%20be%20able%20to%20use%20them%20in%20a%20quick%20and%20easy%20way%20in%20Word%2C%20other%20Excel-files%2C...%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-153600%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-153600%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20the%20same%20issue.%26nbsp%3B%20I%20can%20send%20you%20the%20URL%20if%20you%20tell%20me%20where%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-153408%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-153408%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20the%20same%20problem.%20Please%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-151373%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-151373%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20the%20same%20problem.%20The%20form%20has%20responses%20but%20the%20Excel%20spreadsheet%20is%20completely%20blank.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-151228%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-151228%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3EI%20am%20also%20having%20this%20problem.%26nbsp%3B%20The%20Excel%20file%20contains%202%20responses%20that%20we%20used%20as%20a%20test%20but%20I%20now%20have%2020%2B%20responses%2C%20none%20of%20which%20are%20on%20the%20file.%26nbsp%3B%20Please%20can%20you%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-148256%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-148256%22%20slang%3D%22en-US%22%3EI'm%20glad%20to%20hear%20that%20your%20form%20and%20Excel%20workbook%20work%20well%20for%20you%20again.%3CBR%20%2F%3EPlease%20be%20free%20to%20let%20us%20know%20if%20you%20have%20any%20other%20feedback%20for%20Microsoft%20Forms.%3CBR%20%2F%3E%3CBR%20%2F%3EZhongzhong%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-147877%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-147877%22%20slang%3D%22en-US%22%3EYou%20rock!%20Since%20you%20took%20a%20look%20behind%20the%20scenes%2C%20the%20form%20is%20now%20working%20again.%20Thanks!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-147221%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-147221%22%20slang%3D%22en-US%22%3E%3CP%3ENo%20worry.%20I'm%20glad%20to%20know%20it%20works%20for%20you%20now.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20be%20free%20to%20let%20us%20know%20your%20feedback%20and%20anything%20we%20could%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-147205%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-147205%22%20slang%3D%22en-US%22%3EIt%20actually%20worked%20once%20I%20cleared%20all%20the%20filters%20from%20the%20spreadsheet.%20Thanks%20for%20your%20quick%20response!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-147203%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-147203%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Erik%2C%3C%2FP%3E%0A%3CP%3EI%20have%20already%20received%20your%20form%20URL%20in%20private%20mail.%20We%20will%20do%20investigate%20based%20on%20your%20form%20ID%20(in%20your%20form%20URL)%20and%20try%20to%20recover%20the%20error.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYour%20data%20is%20safe%20in%20both%20Forms%20and%20Excel%20in%20O365.%20Even%20for%20engineering%20team%2C%20we%20don't%20have%20the%20permission%20to%20access%20your%20data.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERegards%2C%3C%2FP%3E%0A%3CP%3EZhongzhong%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-147194%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-147194%22%20slang%3D%22en-US%22%3EThanks%20for%20the%20quick%20response!%20I've%20sent%20you%20a%20link%20to%20the%20form%2C%20but%20can't%20share%20the%20Excel%20Sheet%20itself%20due%20to%20Office%20365%20account%20restrictions.%20Let%20me%20know%20if%20you%20need%20anything%20else%2C%20as%20I'm%20quite%20technical%20when%20it%20comes%20to%20this%20kind%20of%20stuff%20having%20worked%20in%20IT%20for%2010%2B%20years.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-147186%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-147186%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Erik%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'm%20sorry%20for%20the%20error%2C%20could%20you%20please%20send%20the%20form%20URL%20for%20me%2C%20so%20we%20could%20troubleshoot.%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-147185%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-147185%22%20slang%3D%22en-US%22%3E%3CP%3ECould%20you%20send%20me%20your%20form%20URL%2C%20so%20we%20could%20troubleshoot.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-147183%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-147183%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20this%20same%20problem.%20Created%20an%20Excel%20Sheet%20in%20OneDrive%2C%20and%20used%20Forms%20for%20Excelt%20to%20create%20a%20form.%20At%20first%20it%20took%20responses%20just%20fine%20and%20added%20them%20to%20both%20the%20Form%20and%20the%20Spreadsheet%20in%20OneDrive%2C%20but%20now%20it%20no%20longer%20updates%20the%20Spreadsheet%20and%20I%20am%20missing%20some%20responses%20that%20are%20still%20in%20the%20form.%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20now%20I'm%20going%20back%20to%20using%20Google%20Forms%20since%20they're%20much%20less%20clunky%20and%20more%20reliable%20than%20Office%20365's%20Excel%20Forms%20are%2C%20and%20will%20also%26nbsp%3Bbe%20going%20with%20GSuite%20over%20Office%20365%20for%20my%20business%20clients'%20email%20hosting%20due%20to%20reliably.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-147047%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-147047%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20this%20same%20issue!%26nbsp%3B%20There%20are%20responses%20on%20my%20form%2C%20but%20when%20I%20open%20the%20spreadsheet%2C%20no%20responses%20show%20up!%26nbsp%3B%20Please%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-131649%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-131649%22%20slang%3D%22en-US%22%3E%3CP%3EUnfortunately%20I%20did%20not%20managed%20to%20solve%20it%20and%20neither%20did%20our%20IT%20department%20(my%20request%20is%20still%20pending).%20I%20read%20from%20some%20forums%20that%20old%20versions%20of%20Microsoft%20Office%20may%20temporarily%20lock%20the%20excel%20files%20so%20that%20the%20synchronizer%20cannot%20write%20on%20them.%20I%20have%20recent%20OneDrive%20client%20installed%20and%20Excel%202013%20so%20my%20best%20quess%20is%20that%20even%20I%20did%20not%20have%20opened%20any%20files%20locally%20or%20Excel%20even%20running%20when%20students%20were%20answering%20with%20their%20mobile%20phones%2C%20maybe%20some%20files%20were%20somehow%20still%20locked.%20Anyway%2C%20this%20system%20feels%20too%20unreliable%20for%20me%20if%20I%20cannot%20be%20absolutely%20sure%20that%20all%20responses%20are%20in%20excel%20files.%20In%20addition%2C%20it%20seems%20like%20forms%20are%20not%20saved%20in%20excel-files%20so%20I%20cannot%20even%20move%20or%20copy%20excel%20files%20in%20OneDrive%20without%20loosing%20the%20forms.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-127409%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-127409%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20form%20by%20opening%20a%20new%20Excel%20document%2C%20then%20clicking%20Forms%20--%26gt%3B%20%2BNew%20Form.%20I%20created%20my%20survey%2C%20and%20annoyingly%2C%20the%20spreadsheet%20kept%20questions%20I%20had%20deleted%20or%20changed.%20I%20fixed%20the%20columns%20on%20the%20spreadsheet%20to%20match%20the%20questionnaire%20in%20the%20right%20order%2C%20and%20I%20deleted%20the%20ones%20that%20I%20had%20deleted%20off%20the%20form.%20I%20have%20received%20three%20responses%20to%20my%20form%2C%20and%20none%20of%20them%20have%20populated%20the%20spreadsheet.%20I%20can%20see%20them%20in%20the%20%22Responses%22%20tab%20from%20the%20forms%20view.%20When%20I%20click%20%22Open%20in%20Excel%2C%22%20the%20same%20empty%20spreadsheet%20(with%20the%20question%20headers)%20opens%20up.%20Please%20let%20me%20know%20what%20I%20can%20do%20to%20get%20my%20responses%20in%20Excel%2C%20without%20having%20to%20redo%20the%20form%20since%20it%20has%20already%20been%20distributed.%20Thanks!%20PS%3A%20I%20would%20be%20happy%20to%20send%20the%20URL%20but%20I%20do%20not%20want%26nbsp%3Bto%20post%20it%20publicly.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-127081%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-127081%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Tim%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20send%20me%20your%20form%20URL%3F%20I%20could%20help%20connect%20to%20the%20engineering%20team%20for%20troubleshooting.%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-126839%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-126839%22%20slang%3D%22en-US%22%3E%3CP%3EDid%20you%20ever%20get%20this%20issue%20resolved.%20I%20did%20something%20to%20break%20the%20link%20on%20my%20Survey%20as%20well.%20I'm%20getting%20responses%20but%20the%20Excel%20sheet%20is%20empty!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-110499%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-110499%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20same%20problem%3A%20some%20responses%20are%20showing%20only%20on%20Forms%20web%20user%20interface%2C%20not%20in%20Excel%20files.%20My%20files%20were%20created%20with%20Excel%20Online%20(in%20OneDrive)%20then%20added%20forms%20with%20Forms%20for%20Excel.%20I%20have%2012%20files%20with%20forms.%20During%20one%20hour%2C%20two%20persons%20answered%20with%20mobile%20phones%20and%20the%20other%20response%20can%20be%20found%20in%20Excel%20file%20while%20the%20other%20response%20is%20only%20on%20Forms.%20Even%20if%20I%20open%20the%20file%20on%20Forms%20using%20link%20%22Open%20in%20Excel%22.%20the%20other%20response%20is%20still%20missing.%26nbsp%3BSome%20files%20received%20both%20responses.%26nbsp%3B%20I%20already%20contacted%20local%20IT%20support%20(and%20received%20no%20response)%20and%20tried%20to%20contact%20Microsoft%20helpdesk%20by%20phone%20(they%20asked%20to%20contact%20local%20IT%20support).%20If%20synchronization%20between%20Forms%20and%20Excel%20is%20unreliable%2C%20then%20it%20should%20at%20least%20ask%20%22Would%20you%20like%20to%20add%20missing%20responses%20to%20Excel%3F%22%2C%20when%20I%20open%20the%20Forms%20responses%20using%20the%20link%20%22Open%20in%20Excel%22%20on%20Forms.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-107510%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-107510%22%20slang%3D%22en-US%22%3E%3CP%3EMe%20too.%20%26nbsp%3BThe%20only%20thing%20I%20have%20been%20able%20to%20figure%20out%20through%20piecing%20things%20together%20is%20that%20I%20broke%20the%20live%20link%20to%20the%20spread%20sheet%20and%20therefore%20made%20it%20mad.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-107508%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-107508%22%20slang%3D%22en-US%22%3E%3CP%3EHm.%20I%20could%20see%20how%20being%20unable%20to%20see%20responses%20would%20make%20%22sense%22%20if%20the%20Form%20originated%20from%20an%20Excel%20workbook%20in%20OneDrive%2C%20but%20if%20you%20really%20did%20create%20the%20Form%20from%20Forms%20first...I'm%20out%20of%20explanations%20for%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-107507%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-107507%22%20slang%3D%22en-US%22%3E%3CP%3EI%20exported%20from%20forms%20to%20one%20drive%20anf%20then%20deleted%20the%20spreadsheet%20out%20of%20onedrive.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-107439%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-107439%22%20slang%3D%22en-US%22%3E%3CP%3ETo%20confirm%2C%20are%20you%20saying%20that%20you%20created%20the%20Form%20from%20an%20Excel%20workbook%20in%20OneDrive%2C%20or%20that%20you%20exported%20your%20results%20to%20OneDrive%20and%20deleted%20that%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-106204%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-106204%22%20slang%3D%22en-US%22%3E%3CP%3EI%20don't%20know%20if%20this%20makes%20a%20difference%20but%20after%20I%20checked%20to%20make%20sure%20that%20the%20form%20was%20working%20and%20onpened%20it%20in%20excel%20the%20first%20time%2C%20I%20then%20deleted%20the%20spreadsheet%20out%20of%20my%20OneDrive.%20%26nbsp%3BIf%20this%20is%20what%20caused%20the%20problem%2C%20is%20there%20away%20to%20get%20the%20data%20onto%20a%20spreadsheet%20now%3F%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826232%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826232%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20this%20issue%20too.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20a%20form%20here%3A%20lishi.org%2Fconfirm-your-booking%3C%2FP%3E%3CP%3Elinked%20to%20an%20excel%20spreadsheet%3C%2FP%3E%3CP%3Eand%20I%20have%20set%20up%20a%20Zap%20to%20export%20the%20info%20to%20Gist%20and%20to%20Airtable%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20data%20is%20being%20Zapped%20to%20Gist%20and%20Airtable%20but%20I%20cannot%20see%20it%20in%20the%20spreadsheet.%3C%2FP%3E%3CP%3EHow%20can%20I%20view%20the%20data%20from%20the%20form%20in%20the%20spreadsheet%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%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%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-830874%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-830874%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F377614%22%20target%3D%22_blank%22%3E%40lishiben%3C%2FA%3EYou%20can%20open%20your%20Form%20at%20forms.office.com.%20In%20%22Responses%22%20tab%2C%20there%20is%20a%20button%20%22download%20excel%22%2C%20you%20can%20download%20an%20excel%20include%20all%20responses.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-831874%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-831874%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F308102%22%20target%3D%22_blank%22%3E%40longding%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EThanks%20for%20your%20reply%3C%2FP%3E%3CP%3EWhen%20I%20open%20the%20spreadsheet%20it%20only%20shows%203%20responses%20even%20though%20I%20have%20had%2015%20responses.%3C%2FP%3E%3CP%3EThe%20spreadsheet%20is%20not%20updating%20even%20though%20the%20responses%20are%20visible%20in%20Forms.%3C%2FP%3E%3CP%3EHow%20can%20I%20fix%20this%3F%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-832979%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-832979%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F377614%22%20target%3D%22_blank%22%3E%40lishiben%3C%2FA%3EIn%20%22Responses%22%20tab%2C%20There%20is%20a%20%22...%22%20button%20on%20top%20of%20%22Open%20in%20Excel%22.%20Press%20%22...%22%20button%20%2C%20then%20press%20%22Sync%20all%20responses%20to%20a%20new%20workbook%22.%20After%20sync%20is%20done%2C%20try%20%22open%20in%20excel%22%20again%20to%20see%20the%20responses.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-833416%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-833416%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F308102%22%20target%3D%22_blank%22%3E%40longding%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20that%20but%20it%20hasn't%20made%20any%20difference.%3C%2FP%3E%3CP%3EStill%20only%203%20entries%20instead%20of%20the%2019%20it%20should%20be.%3C%2FP%3E%3CP%3EI%20have%20tried%20searching%20my%20file%20system%20for%20the%20same%20file%20name%20to%20see%20if%20there%20is%20a%20duplicate%20anywhere.%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20find%20the%20filepath%20from%20Forms%20of%20the%20spreadsheet%20it%20is%20saving%20responses%20to%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-833924%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-833924%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F377614%22%20target%3D%22_blank%22%3E%40lishiben%3C%2FA%3E%2C%20How%20may%20responses%20show%20at%20%22Responses%22%20tab%3F%20Is%20it%20%22download%20excel%22%20or%20%22Open%20in%20excel%22%20on%20the%20tab%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1174724%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1174724%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%20private%20messaged%20you%20about%20a%20similar%20issue.%20I%20tried%20this%20solution%20(thanks%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F118803%22%20target%3D%22_blank%22%3E%40Nate%20Kennedy%3C%2FA%3E%26nbsp%3B!)%20and%20I%20was%20able%20to%20generate%20a%20new%20excel%20file%20and%20I%20can%20see%20the%20full%20list%20of%20respondents%20but%20their%20response%20to%20the%20survey%20is%20still%20blank.%20Please%20advise%20how%20I%20can%20recover%20this%20data.%20Thank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20survey%20is%20time-sensitive%2C%20so%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F308102%22%20target%3D%22_blank%22%3E%40longding%3C%2FA%3E%26nbsp%3B%3CSPAN%3Eif%20you%20are%20able%20to%20assist%20as%20well%20that%20would%20be%20great.%20Thank%20you!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1356651%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1356651%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F77804%22%20target%3D%22_blank%22%3E%40Stephanie%20Piazza%3C%2FA%3E%26nbsp%3B%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%3C%2FP%3E%3CP%3E%26nbsp%3B%3CBR%20%2F%3E%3CSTRONG%3EMy%20case%3C%2FSTRONG%3E%3A%3C%2FP%3E%3CP%3EI%20had%20the%20same%20problem%20has%20everyone%20else.%20Out%20of%2067%20entries%2C%2015%20or%20so%20were%20missing%20from%20the%20excel%20doc.%20My%20excel%20doc%20consisted%20of%20the%20source%20data%20on%20one%20page%20and%20several%20pages%20taking%20the%20data%20and%20outputting%20it%20in%20a%20specific%20format.%20I%20used%20approximately%201000%20MATCH%20functions%20on%20every%20output%20page.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ESolution%3C%2FSTRONG%3E%3A%3C%2FP%3E%3CP%3EI%20fixed%20it%20by%20moving%20every%20output%20page%20in%20another%20excel%20doc%20with%20the%20formulas%20referencing%20the%20input%20doc.%20Now%20I%20get%20one%20entry%20maximum%20missing%20out%20of%2067.%20This%20way%20you%20can%20also%20have%20your%20output%20in%20a%20different%20folder%20to%20send%20it%20to%20someone%20else.%20I%20also%20don't%20open%20the%20source%20doc%20if%20the%20form%20is%20opened%20and%20opens%20it%20only%20for%20a%20certain%20period%20of%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EProblem%3C%2FSTRONG%3E%3A%3C%2FP%3E%3CP%3EMy%20intuition%20is%20that%20forms%20tries%20inputting%20entries%20while%20excel%20is%20calculating%20every%20output%20page.%20The%20process%20times%20out%20or%20cannot%20input%20more%20than%20one%20entries%20at%20the%20same%20time%20and%20fails.%26nbsp%3B%20By%20moving%20the%20formulas%20outside%20the%20source%20doc%2C%20forms%20don't%20need%20to%20calculate%20them%20every%20time%20it%20wants%20to%20input%20data.%20The%20formulas%20are%20only%20updated%20when%20the%20user%20opens%20the%20output%20doc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20problem%20gets%20worse%20when%20you%20have%20more%20formulas%20and%20more%20entries%20(200%20or%20so).%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20it%20can%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1614593%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1614593%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%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20followed%20the%20steps%20to%20'Sync%20all%20responses%20to%20a%20new%20workbook'%20(%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%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%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fhow-to-get-missing-data-in-forms-9fb98299-4dcc-41a4-bb29-...%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20got%20a%20new%20workbook%20with%20all%20the%20responses.%20However%2C%20when%20we%20submit%20a%20new%20response%2C%20it%20is%20not%20updating%20the%20Excel%20file%20anymore.%20When%20I%20open%20the%20Forms%20from%20the%20Excel%20file%2C%20I%20see%20all%20the%20responses.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%2C%20could%20you%20help%20me%20on%20this%20issue%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFile%20was%20created%20using%20'Forms%20for%20Excel'%20on%20SharePoint%20Online.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1614634%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1614634%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F77804%22%20target%3D%22_blank%22%3E%40Stephanie%20Piazza%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20posted%20a%20solution%20back%20in%20May%20on%20this%20thread%20but%20it%20seemed%20to%20have%20disappeared.%20Here%20is%20a%20summary.%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EI%20had%20the%20same%20problem%20with%2050%25%20of%20the%20responses%20missing.%3C%2FDIV%3E%3CDIV%3EThe%20best%20way%20to%20maximize%20your%20chances%20to%20have%20all%20your%20responses%20in%20your%20Excel%20is%20to%20have%20two%20excel%20documents.%26nbsp%3BOne%20document%20for%20the%20data%20and%20one%20for%20the%20processing%20of%20the%20data.%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EThe%20reason%20is%20that%20Excel%20tries%20to%20calculate%20every%20formula%20each%20time%20forms%20add%20a%20response.%20It%20can%20take%20a%20long%20time%20especially%20if%20you%20have%20a%20lot%20of%20formulas%20(I%20had%201000%20complex%20formulas%20referencing%20the%20data).%20Forms%20is%20like%20a%20user%2C%20it%20tries%20to%20add%20data%20but%20if%20the%20document%20is%20calculating%20or%20blocked%20by%20another%20user%20it%20gives%20up.%20You%20then%20end%20up%20with%20missing%20data.%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EHaving%20a%20document%20for%20data%20allows%20forms%20to%20input%20data%20without%20being%20stuck%20by%20excel%20calculating%20or%20another%20user%20modifying%20the%20document.%20Excel%20will%20only%20try%20to%20calculate%20formulas%20when%20you%20open%20the%20processing%20document%20containing%20the%20formulas.%20It's%20also%20a%20great%20way%20to%20change%20your%20data%20document%20if%20needed.%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EWith%20this%2C%20I%20nearly%20never%20had%20missing%20data.%3C%2FDIV%3E%3CDIV%3EHopes%20it%20helps.%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1830575%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1830575%22%20slang%3D%22en-US%22%3E%3CP%3EHaving%20a%20similar%20issue%20as%20described.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20realised%20that%20the%20link%20between%20my%20Microsoft%20Form%20and%20Microsoft%20Excel%20Workbook%20broke%20when%20I%20added%20a%20macro%20to%20one%20of%20the%20sheets%20and%20it%20saved%20the%20file%20as%20an%20.xlsm%20macro%20enabled%20workbook.%20I%20got%20rid%20of%20the%20macro%20and%20tried%20saving%20as%20an%20.xlsx%20again%20but%20it%20made%20no%20difference.%3CBR%20%2F%3E%26nbsp%3B%3CBR%20%2F%3EHave%20tried%20changing%20the%20False%20to%20True%20as%20described%20several%20times%20earlier%2C%20have%20also%20tried%20syncing%20all%20responses%20to%20a%20new%20workbook%20and%20also%20opening%20in%20Excel%20from%20the%20Forms%20Responses%20tab%20but%20no%20luck.%3CBR%20%2F%3E%3CBR%20%2F%3ERaised%20the%20issue%20with%20our%20IT%20support%203%20weeks%20ago%20who%20raised%20a%20support%20ticket%20with%20Microsoft%2C%20unfortunately%20I%20have%20had%20no%20response%20other%20than%20one%20offer%20of%20a%20callback%20one%20week%20ago%20which%20I%20agreed%20to%2C%20but%20Microsoft%20never%20bothered%20to%20call.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EYesterday%20I%20escalated%20to%20our%20IT%20support%20again%20and%20they%20have%20escalated%20to%20their%20own%20IT%20support%20who%20are%20closer%20to%20Microsoft.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20hoping%20for%20an%20answer%20promptly%20as%20it%20has%20been%20broken%20for%203%20weeks%20and%20I%20need%20to%20have%20this%20resolved%20tomorrow%20as%20I%20need%20to%20use%20the%20data%20for%20end%20of%20month%20reporting.%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20help%20would%20be%20much%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1831659%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1831659%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F849781%22%20target%3D%22_blank%22%3E%40Chris-Smith%3C%2FA%3E%26nbsp%3B%20The%20user%20is%20a%20member%20of%20the%20SharePoint%20site%20or%20the%20owner%20of%20OneDirve%20to%20sync%20to%20a%20new%20workbook%2C%20Please%20first%20make%20sure%20this%20is%20true.%20Then%20try%26nbsp%3B%22Sync%20all%20responses%20in%20a%20new%20workbook%22%20as%20in%20below%20link%2C%20it%20should%20work%20usually.%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fhow-to-get-missing-data-in-forms-9fb98299-4dcc-41a4-bb29-34a9c3daf8cc%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fhow-to-get-missing-data-in-forms-9fb98299-4dcc-41a4-bb29-34a9c3daf8cc%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EIf%26nbsp%3B%22Sync%20all%20responses%20in%20a%20new%20workbook%22%20still%20not%20helping%2C%26nbsp%3B%20please%20collect%20network%20trace%20and%26nbsp%3B%3CSPAN%3Eescalate%20to%20support%20team.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnd%20we%20suggest%20NOT%20to%20change%20the%20workbook%20Forms%20sync%20to%2C%20like%20formula%2C%20macro%2C%20etc.%20It%20may%20cause%20live%20sync%20broken.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1834759%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20responses%20missing%20when%20Excel%20is%20opened%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1834759%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F308102%22%20target%3D%22_blank%22%3E%40longding%3C%2FA%3EI%20have%20tried%20the%20Sync%20all%20responses%20to%20a%20new%20workbook%2C%20but%20either%20I%20am%20unable%20to%20find%20where%20the%20new%20workbook%20is%20going.%3CBR%20%2F%3E%3CBR%20%2F%3EHow%20do%20I%20collect%20network%20trace%3F%3CBR%20%2F%3EHow%20do%20I%20escalate%20within%20the%20support%20team%3F%20(I%20have%20been%20trying%20to%20contact%20Microsoft%20and%20have%20a%20ticket%20raised%20for%20over%203%20weeks%20and%20have%20not%20had%20any%20response)%3CBR%20%2F%3E%3CBR%20%2F%3EWhile%20I%20understand%20not%20changing%20the%20workbook%2C%20sometimes%20additions%20are%20made%20as%20time%20goes%20by%20to%20automate%20tasks%2C%20so%20there%20should%20be%20some%20way%20to%20be%20able%20to%20choose%20where%20the%20responses%20are%20sent.%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20appears%20there%20are%20common%20issues%20of%20the%20workbook%20and%20form%20losing%20their%20connection%20and%20no%20obvious%20way%20to%20reconnect%20them.%20I%20would%20thought%20that%20having%20the%20ability%20to%20re-link%20the%20spreadsheet%20and%20form%20would%20be%20important%20after%202%20years.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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.

124 Replies

I don't know if this makes a difference but after I checked to make sure that the form was working and onpened it in excel the first time, I then deleted the spreadsheet out of my OneDrive.  If this is what caused the problem, is there away to get the data onto a spreadsheet now? Thanks!

To confirm, are you saying that you created the Form from an Excel workbook in OneDrive, or that you exported your results to OneDrive and deleted that?

I exported from forms to one drive anf then deleted the spreadsheet out of onedrive.

Hm. I could see how being unable to see responses would make "sense" if the Form originated from an Excel workbook in OneDrive, but if you really did create the Form from Forms first...I'm out of explanations for this.

Me too.  The only thing I have been able to figure out through piecing things together is that I broke the live link to the spread sheet and therefore made it mad.

I have same problem: some responses are showing only on Forms web user interface, not in Excel files. My files were created with Excel Online (in OneDrive) then added forms with Forms for Excel. I have 12 files with forms. During one hour, two persons answered with mobile phones and the other response can be found in Excel file while the other response is only on Forms. Even if I open the file on Forms using link "Open in Excel". the other response is still missing. Some files received both responses.  I already contacted local IT support (and received no response) and tried to contact Microsoft helpdesk by phone (they asked to contact local IT support). If synchronization between Forms and Excel is unreliable, then it should at least ask "Would you like to add missing responses to Excel?", when I open the Forms responses using the link "Open in Excel" on Forms.

Did you ever get this issue resolved. I did something to break the link on my Survey as well. I'm getting responses but the Excel sheet is empty!

Hi Tim,

 

Could you send me your form URL? I could help connect to the engineering team for troubleshooting.

 

Regards,

Zhongzhong

I created a form by opening a new Excel document, then clicking Forms --> +New Form. I created my survey, and annoyingly, the spreadsheet kept questions I had deleted or changed. I fixed the columns on the spreadsheet to match the questionnaire in the right order, and I deleted the ones that I had deleted off the form. I have received three responses to my form, and none of them have populated the spreadsheet. I can see them in the "Responses" tab from the forms view. When I click "Open in Excel," the same empty spreadsheet (with the question headers) opens up. Please let me know what I can do to get my responses in Excel, without having to redo the form since it has already been distributed. Thanks! PS: I would be happy to send the URL but I do not want to post it publicly. 

Unfortunately I did not managed to solve it and neither did our IT department (my request is still pending). I read from some forums that old versions of Microsoft Office may temporarily lock the excel files so that the synchronizer cannot write on them. I have recent OneDrive client installed and Excel 2013 so my best quess is that even I did not have opened any files locally or Excel even running when students were answering with their mobile phones, maybe some files were somehow still locked. Anyway, this system feels too unreliable for me if I cannot be absolutely sure that all responses are in excel files. In addition, it seems like forms are not saved in excel-files so I cannot even move or copy excel files in OneDrive without loosing the forms.

I am having this same issue!  There are responses on my form, but when I open the spreadsheet, no responses show up!  Please help!

I have this same problem. Created an Excel Sheet in OneDrive, and used Forms for Excelt to create a form. At first it took responses just fine and added them to both the Form and the Spreadsheet in OneDrive, but now it no longer updates the Spreadsheet and I am missing some responses that are still in the form.

For now I'm going back to using Google Forms since they're much less clunky and more reliable than Office 365's Excel Forms are, and will also be going with GSuite over Office 365 for my business clients' email hosting due to reliably.

Could you send me your form URL, so we could troubleshoot.

Hi Erik,

 

I'm sorry for the error, could you please send the form URL for me, so we could troubleshoot.

 

Regards,

Zhongzhong

Thanks for the quick response! I've sent you a link to the form, but can't share the Excel Sheet itself due to Office 365 account restrictions. Let me know if you need anything else, as I'm quite technical when it comes to this kind of stuff having worked in IT for 10+ years.

Hi Erik,

I have already received your form URL in private mail. We will do investigate based on your form ID (in your form URL) and try to recover the error.

 

Your data is safe in both Forms and Excel in O365. Even for engineering team, we don't have the permission to access your data.

 

Regards,

Zhongzhong

 

 

It actually worked once I cleared all the filters from the spreadsheet. Thanks for your quick response!

No worry. I'm glad to know it works for you now.

 

Please be free to let us know your feedback and anything we could help.

You rock! Since you took a look behind the scenes, the form is now working again. Thanks!