Forum Discussion

DGoga's avatar
DGoga
Copper Contributor
Mar 20, 2019

Stuck on "Opening Forms for Excel..."

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 "Openin...
office 365
JohnGillanders's avatar
JohnGillanders
Brass Contributor
Jun 03, 2020

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.

Resources