"Open in Excel" option is greyed out on MS Forms

Question

Despite having responses in the form, the open in excel button is currently greyed out. Any ideas why?

Answer 1

Dear N Wright,

Thanks for writing back to us.

As per the further updates, to store the responses Excel workbook of the Form in the cloud location such as OneDrive or SharePoint Online, you need to create the Form directly in the OneDrive for Business or SharePoint Online Document Library as per your requirement: Create a form with Microsoft Forms - Microsoft Support (OneDrive for work or school).

For the existing Form created in https://forms.office.com , you can move the Form to the Group, so that the responses will be stored in Excel workbook in the Shared Document Library of the Group: Move your form to a group - Microsoft Support

Appreciate your patience and understanding with us. Have a great day!!

Best Regards,
Sophia

Answer 2

Thank you. This is not what i want. I want the responses to be stored in the cloud. How do i ensure this happens? Do i need to create the form again in a separate location?

Answer 3

Dear N Wright,

Thanks for writing back and updating with us.

As per the further updates, it seems the form in the question is created in the https://form.office.com and the Form responses Excel workbook is not stored in the cloud location such as OneDrive or SharePoint Online. If yes, clicking on Open in Excel will download the Excel workbook with the responses of the Form.

So, please click on Open in Excel, where the responses of the Form will be downloaded to an Excel workbook.

If still there is any misunderstanding from our end, we sincerely apologize and request you to share back with us with more detailed information, where we will try our best to investigate the issue further.

Appreciate your patience and understanding with us. Have a great day!!

Best Regards,
Sophia

Answer 4

I've sat with the owner of the form. This is what we get

Answer 5

Dear N Wright,

Good day!!

Apologies for the inconvenience caused and please don’t worry, let’s work together on your concern and move towards a resolution path.

I understand your concern and I would like to confirm whether you are the owner of the problematic Form where “Open in Excel” button is grayed out.

If yes, I would like to confirm whether you are having the same problem when you open the problematic Form in the InPrivate or Incognito window of the browser.

If you are not the owner of the Form but having co-author permissions on the problematic Form, the I would like to let you know that you will be able to find the option to download the copy but won’t be able to open the Form responses in the Excel workbook:

However, if you are the owner of the Form and even Open in Excel option is grayed out in the InPrivate or Incognito window of the browser, then I believe the problem should be further investigated by related development team via collecting HAR logs because there is not any related service incident reported at the Microsoft Service Health dashboard.

I do feel regret for not resolving the problem and redirecting you to the related development team but the fix to your concern can be find out through the HAR logs and suggest you raise a support ticket from the Office 365 admin center, where the related team will investigate the problem further by collecting the HAR logs.

Reference: Get support - Microsoft 365 admin | Microsoft Learn

Note: To create a support ticket, you need to have admin privileges and if you aren’t admin of your Office 365 organization, please contact the admin of creating a new ticket.

Appreciate your patience and understanding. Have a great day!!

Best Regards,
Sophia