Microsoft Forms not appearing in Online Excel despite paid account

Occasional Contributor

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

15 Replies

@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.

@Sergei Baklan 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.

This is the button I'm looking for.

 

CGBakker_0-1612285173500.png

 

@CGBakker 

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 

That's how it works by default - if you initiate the Form from Excel, any answer will be added to the table automatically. Again, I'm in business environment and not sure is there some specific for consumer subscriptions. If you submit the answer (not other person) will it be added to table or not?

Currently it doesn't. All answers need to be downloaded manually as a separate Excel file.
From what I understand it should be both an enterprise and non-enterprise (but paid) feature.

@CGBakker 

Could you please clarify in plain English what is explained in this video why paid subscription with automatic download doesn't work?

Did you ever get a solution to this. I have the same issue@CGBakker 

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.

@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.

@CGBakker 

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-b82...

 

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.