Forum Discussion
"Forms for Excel" - Install Web Add-ins for Organization
When trying to create a form with Microsoft Forms [https://support.microsoft.com/en-us/office/create-a-form-with-microsoft-forms-4ffb64cc-7d5d-402f-b82e-b1d49418fd9d#PickTab=OneDrive_for_work_or_school] using ODFB (or Excel on the web), there is no FORMS FOR EXCEL option.
What users expect to see is this:
When trying to get to the "Office Add-ins" in Excel on the web, users see this:
Users are licensed for both Office365 & Forms (G5). I've found some references that indicate that there may be a need to deploy "Web Add-ins" to the SPO app library, but these aren't custom add-ins... simply native Microsoft functionality.
Can anyone offer suggestions about WHAT needs to be added/enabled within our tenant and WHERE - in order to make "Forms for Excel" available to users?
9 Replies
- Patrick2788Silver Contributor
From what I gather, it doesn't look like it's available with a G5.
Microsoft Forms service description - Service Descriptions | Microsoft Learn
- SW-SoCo2Brass Contributor
Thank you Patrick! Both you and Sergei found what I hadn't: that the integration isn't available to GCC tenants 😞
Thanks again!
- SergeiBaklanDiamond Contributor
- SW-SoCo2Brass Contributor
- SergeiBaklanDiamond Contributor
If so most probably it's not available for your subscription. I'm not familiar with G5, the only was able to find this comment
---
Note that this will not work in U.S. Government Community Cloud (GCC), GCC High, or DoD environments because it is an integration between Office Applications.
Forms features in these environments: https://support.microsoft.com/en-us/office/microsoft-forms-features-for-u-s-government-community-cloud-gcc-
gcc-high-and-dod-environments-5cbd407a-eef7-431e-8e3a-eb666eab4b4c
Integrations: https://support.microsoft.com/en-us/office/integration-fd5521ec-bd27-48ee-8aad-84ffe95c2a8b
#Read more: https://www.sharepointdiary.com/2021/11/add-microsoft-forms-to-sharepoint-online.html#ixzz86Q3Egg57---
- NikolinoDEGold Contributor
To enable "Forms for Excel" in your Office 365 tenant and make it available to users, you need to ensure that the necessary settings and licenses are properly configured. Here are some steps you can take:
- Verify Licenses: Confirm that your users have the appropriate licenses assigned to their accounts. "Forms for Excel" is available with certain Office 365 and Microsoft 365 plans. Check if your users have licenses that include Microsoft Forms.
- SharePoint Online App Catalog: Make sure you have a SharePoint Online App Catalog set up in your Office 365 tenant. The SharePoint App Catalog is where you can deploy and manage web add-ins for Excel on the web. If you don't have an App Catalog, you'll need to create one.
- Go to the SharePoint admin center.
- Click on "More features" in the left-hand navigation pane.
- Under "Apps," click on "App catalog."
- Follow the steps to create an App Catalog if you don't already have one.
- Deploy Web Add-in: Once you have the SharePoint Online App Catalog set up, you can deploy the "Forms for Excel" web add-in to make it available to users in Excel on the web.
- Obtain the "Forms for Excel" web add-in package, which is typically provided by Microsoft.
- Upload the web add-in package to the App Catalog in SharePoint Online.
- Approve the deployment of the web add-in.
- Enable Web Add-ins: In the Office 365 admin center, you may need to ensure that web add-ins are enabled for your organization. This setting allows users to access and use web add-ins in Excel on the web.
- Go to the Office 365 admin center.
- Click on "Settings" and then "Services & add-ins."
- Under "Office Add-ins," make sure the toggle for "Let users access the Office Store" is enabled.
By following these steps, you should be able to enable "Forms for Excel" and make it available to users in your Office 365 tenant. Keep in mind that administrative permissions and configuration access may be required to perform these actions.The text was created with the help of AI.
Hope this will help you.
- SW-SoCo2Brass Contributor
Thanks for the reply; these are the steps that I expected to follow, however I'm unable to complete this piece:
I can't find anywhere to download this package, which led me to believe that it's native functionality that I just need to enable, as opposed to uploading - but no success figuring out how to enable either. If anyone can point to a Microsoft location to download "Forms for Excel" please do 🙂