Forum Discussion

SW-SoCo2's avatar
SW-SoCo2
Brass Contributor
Jun 27, 2023

"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

    • SW-SoCo2's avatar
      SW-SoCo2
      Brass Contributor

      Patrick2788 

      Thank you Patrick! Both you and Sergei found what I hadn't: that the integration isn't available to GCC tenants 😞

      Thanks again!

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    SW-SoCo2 

    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:

    1. 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.
    2. 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.
    3. 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.
    4. 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-SoCo2's avatar
      SW-SoCo2
      Brass Contributor

      NikolinoDE 

      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 🙂

Resources