Stuck on "Opening Forms for Excel..."

%3CLINGO-SUB%20id%3D%22lingo-sub-377984%22%20slang%3D%22en-US%22%3EStuck%20on%20%22Opening%20Forms%20for%20Excel...%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377984%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20create%20a%20survey.%20When%20I%20click%20%22New%22%2C%20%22Forms%20for%20excel%22%20from%20the%20OneDrive%20page%2C%20or%20%22New%20Form%22%20from%20the%20%22Insert%22%20tab%20in%20a%20excel%20365%20document%2C%20I'm%20brought%20to%2C%20and%20get%20stuck%20on%2C%20the%20%22Opening%20Forms%20for%20Excel...%22%20screen%20with%20the%20loading%20wheel.%20The%20wheel%20spins%20as%20if%20it's%20working%2C%20but%20I%20can't%20progress%20any%20further.%20I've%20tried%20multiple%20computers%20and%20multiple%20browsers%20-%20all%20with%20the%20same%20result.%20Any%20help%20is%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-377984%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1438858%22%20slang%3D%22en-US%22%3ERe%3A%20Stuck%20on%20%22Opening%20Forms%20for%20Excel...%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1438858%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F304864%22%20target%3D%22_blank%22%3E%40DGoga%3C%2FA%3E%26nbsp%3B-%20I%20have%20the%20same%20problem%2C%20and%20in%26nbsp%3B%20my%20case%20it%20was%20caused%20by%20the%20following%3A%3C%2FP%3E%3CP%3E*%20The%20form%20is%20stored%20in%20an%20Office%20365%20group%3C%2FP%3E%3CP%3E*%20I%20have%20permission%20to%20edit%20the%20form%20via%20an%20editing%20link%20but%20I%20am%20not%20a%20member%20of%20the%20group%3C%2FP%3E%3CP%3E*%20When%20I%20click%20'Open%20in%20Excel'%20it%20attempts%20to%20open%20it%20in%20the%20Office%20365%20Group's%20documents%20(SharePoint%20site)%2C%20and%20I%20guess%20this%20fails%20but%20with%20no%20error%20message%20leaving%20me%20stuck%20on%20the%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20that%20this%20is%20the%20cause%2C%20because%20when%20I%20am%20a%20member%20of%20the%20group%2C%20'Open%20in%20Excel'%20works%2C%20when%20I'm%20not%20a%20member%20of%20the%20group%2C%20it%20doesn't.%3C%2FP%3E%3CP%3EProbably%20the%20same%20situation%20would%20happen%20if%20the%20form%20is%20one%20created%20from%20a%20Microsoft%20Teams%20team%2C%20if%20you're%20not%20a%20member%20of%20that%20team%20but%20the%20form%20has%20been%20shared%20with%20you.%20Possibly%20in%20other%20scenarios%20too...%20I'll%20report%20this%20to%20Microsoft%2C%20it%20should%20automatically%20make%20an%20Excel%20sheet%20in%20your%20own%20OneDrive%20in%20this%20scenario.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I'm trying to create a survey. When I click "New", "Forms for excel" from the OneDrive page, or "New Form" from the "Insert" tab in a excel 365 document, I'm brought to, and get stuck on, the "Opening Forms for Excel..." screen with the loading wheel. The wheel spins as if it's working, but I can't progress any further. I've tried multiple computers and multiple browsers - all with the same result. Any help is appreciated.

1 Reply
Highlighted

@DGoga - I have the same problem, and in  my case it was caused by the following:

* The form is stored in an Office 365 group

* I have permission to edit the form via an editing link but I am not a member of the group

* When I click 'Open in Excel' it attempts to open it in the Office 365 Group's documents (SharePoint site), and I guess this fails but with no error message leaving me stuck on the 

I know that this is the cause, because when I am a member of the group, 'Open in Excel' works, when I'm not a member of the group, it doesn't.

Probably the same situation would happen if the form is one created from a Microsoft Teams team, if you're not a member of that team but the form has been shared with you. Possibly in other scenarios too... I'll report this to Microsoft, it should automatically make an Excel sheet in your own OneDrive in this scenario.