Forum Discussion
Microsoft Forms not appearing in Online Excel despite paid account
Hi everyone,
I noticed that the Microsoft Forms button is not in my Online Excel ribbon. I have a paid account (Office 365 Family). From what I understand I should be able to use Microsoft Forms directly from Excel Online.
I need my form responses to sync with my workbook. That's why I am looking for the button.
I searched for a similar discussion but couldn't find it.
Thank you,
Coen
16 Replies
Hello,
"Note: To enable the Forms button, make sure your Excel workbook is stored in OneDrive for work or school. Also note that Forms for Excel is only available for OneDrive for work or school and new team sites connected with Microsoft 365 Groups. "
It doesn't work if your Excel file is stored on OneDrive for home.
Source: https://support.microsoft.com/en-us/office/create-a-form-with-microsoft-forms-4ffb64cc-7d5d-402f-b82e-b1d49418fd9d#PickTab=Excel_for_the_web
- If you have 365 with Forms and Power Automate that is how I did it before this integration made it easy. Create a Form then Create a workflow in Power Automate that triggers on the Form, Takes values from form and adds them to a table in an Excel Sheet you link. There are some sample workflows that you can use to help you.
JcyMclean I have the same issue as you. So I have two different Microsoft accounts.
1) Personal account with MS365 - where in Excel I have the Forms option.
2) Business account through my work (a large organisation) - where in Excel I have NO Forms option.
It's so frustrating.
- My employer now has a Office 365 business account. So that solved it for me. Personal accounts don't include Forms, after all, it seems. I did not find a way to get to Forms on my personal account.
This is the button I'm looking for.
Sorry, I missed. "Opening the Forms App via Online Excel does provide syncing" - so you can add the Form from Excel Online. Or not? Participants can't sync - does that mean if you fill the form you have an answers in sheet, but for others that doesn't work?
- I can't open Forms from Excel Online atm.
The syncing I want to achieve is this:
Answers of the form get sent to the connected Excel workbook (in the cloud) automatically. Any new answers should be added to this workbook automatically, without downloading the new answers to an Excel file manually. Syncing might not be the right word: auto updating, maybe?
CGBakker I'm not sure about details of Family subscription, but if you have no Microsoft Forms as separate app it shall be no such tab in Excel app.
SergeiBaklan Thank you for replying. I do have the Forms App in my Online Office 365 environment. I can use it to make forms but the participants' answers will not sync with the corresponding Excel workbook. Opening the Forms App via Online Excel does provide syncing.
