Office Settings & Configuration

How to Enable Forms for Excel and Microsoft 365 Web Add-ins

Elise WilliamsElise Williams Nov 13, 2026 872 views

Question details

The user needs to enable Forms for Excel and Microsoft 365 web add-ins in Excel for the web when the Insert > Form command is missing or add-ins are blocked by licensing, tenant, or policy settings.

How to Enable Forms for Excel and Microsoft 365 Web Add-ins
Product
Microsoft Forms, Excel for the web, Microsoft 365 admin center
Device & OS
not provided
Scenario
Users have Microsoft 365 and Microsoft Forms licenses but cannot see or use Forms for Excel or Microsoft 365 web add-ins in Excel for the web.
Observed behavior
The Insert > Form command is unavailable, or web add-ins are blocked, even though the user has Microsoft 365 and Microsoft Forms licenses.
Before you start

Sign in to the Microsoft 365 admin center with an administrator account and confirm that the affected user has an active license that includes Microsoft Forms. Open Excel for the web and check whether Insert > Form appears on the ribbon before changing tenant settings.

Solution 1Recommended

Check Microsoft 365 licenses and enable the Forms service

Use this first to verify that the user license includes Microsoft Forms and that the Forms service is enabled for the organization.

1
Open Microsoft 365 admin center

Sign in to admin.microsoft.com with a global administrator or user management administrator account.

2
Verify the user license

Go to Users > Active users, select the affected user, and under Licenses and apps confirm that Microsoft Forms is included and assigned.

3
Enable Microsoft Forms for the tenant

Go to Settings > Org settings, search for Microsoft Forms, open the service settings, and enable the features your organization needs.

4
Refresh Excel for the web

Have the user refresh Excel for the web and check whether Insert > Form now appears on the ribbon.

Check Microsoft 365 licenses and enable the Forms service
Expected result: After license and service settings are corrected, Insert > Form should become available in Excel for the web.
Free Microsoft Office alternative

Try WPS Office for Everyday Excel-Compatible Spreadsheets

WPS Office is a free, lightweight Office suite that opens, edits, and saves Excel-compatible spreadsheets with a familiar ribbon interface and strong format compatibility. It is a practical alternative for everyday spreadsheet work while Microsoft 365 admin settings determine Forms and web add-in availability.

Free to download and use for everyday spreadsheet, document, and presentation tasksOpens and saves .xlsx, .xls, and other Microsoft Office-compatible formatsFamiliar ribbon-style interface for a smooth switch from Microsoft ExcelLightweight and easy to use, with no Microsoft 365 admin configuration requiredIncludes PDF and cloud tools that reduce the need for extra add-ins
microsoft office alternative - wps office

Frequently Asked Questions

Why is Insert > Form missing in Excel for the web even though I have Microsoft 365?

The most common causes are that the assigned Microsoft 365 license does not include Microsoft Forms, the Forms service is disabled in the Microsoft 365 admin center, or Office add-in access is restricted. Check the user license under Users > Active users and review Settings > Org settings > Microsoft Forms.

Which Microsoft 365 licenses include Forms for Excel?

Many Microsoft 365 business and education plans include Microsoft Forms, but availability depends on the service description for your specific plan. In the Microsoft 365 admin center, select the user and review Licenses and apps to see whether Microsoft Forms is included.

How do I allow Microsoft 365 web add-ins from the Office Store?

In the Microsoft 365 admin center, go to Settings > Org settings, open the Microsoft 365 apps or Office on the web service page, and enable the option that lets users access the Office Store. Also check for any add-in restrictions assigned to users.

Does WPS Office support Microsoft Forms and Microsoft 365 web add-ins?

WPS Office is not a Microsoft 365 admin tool and does not change Microsoft Forms tenant settings. However, it can open and edit Excel-compatible workbooks and provides a free, lightweight alternative for common spreadsheet tasks without requiring Microsoft 365 add-in configuration.

Do I need to configure SharePoint Online app catalog to enable Forms for Excel?

For the built-in Forms for Excel feature, you usually do not need the SharePoint Online app catalog. The app catalog is mainly used for centrally deployed organizational add-ins, so an administrator only needs to review it if your organization blocks or manages add-ins through SharePoint.